Solution : https://service.sap.com/sap/support/notes/129439 (SAP Service marketplace login required)
Summary :
The SAP Note addresses Oracle database file size limitations on various operating systems, particularly impacting data files exceeding 2GB. Updating to Oracle 9 or beyond allows a 32GB per file limit under a configured 8k DB_BLOCK_SIZE parameter. The document discusses preparations necessary to manage large data files within an SAP environment, such as ensuring the appropriate system settings (ulimit, large file systems configuration) are in place for operation on platforms like HPUX, Solaris, and Linux. It also outlines steps to increase max_file_size parameters and the relevance of using large files for better management and system performance, focusing on how these mitigations and settings must be tailored for the specific operating conditions and software releases.
Key words :
_______________________________________________________________________hp_ux_______________________________________________________________________ release hp-rel fs/raw aio > 2gb exp/imp sql loader> 8, hp tru64_______________________________________________________________________release os-rel fs/raw aio > 2gb exp/imp sql loader >=8, 6_______________________________________________________________________ release fs raw exp/imp sql loadr problems, 2 release fs raw exp/imp sql-loader <=8, fewer required file handle resources fewer file headers, fileaix 128gb 64gbhp 128gb 128gblinux 2 tb 1tb, fs raw aio > 2gb_______________________________________________________________________>=8, large file enabled journaled file system, <2gb >=2gb <2gb <2gbfor files > 2gb, sun file limit file system limitas
Related Notes :
| 606395 | FAQ: Oracle Limitations |
| 592393 | FAQ: Oracle |
| 553854 | Oracle: Problems with file size limit |
| 546006 | Problems with Oracle due to operating system errors |
| 482435 | AUTOEXTEND/RESIZE with Oracle 8i and NT/2000 |
| 90937 | SAPDBA: Database files larger than 2G |