InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Many Maximum Datafiles Can There Be In Oracle Database? |
|
Answer» Regardless of the setting of this paramter, maximum per DATABASE: 65533 (May be less on some operating systems) Maximum number of datafiles per tablespace: OS dependent = USUALLY 1022 Limited also by size of database blocks and by the DB_FILES initialization PARAMETER for a particular instance Bigfile tablespaces can contain only one file, but that file can have up to 4G blocks. Regardless of the setting of this paramter, maximum per database: 65533 (May be less on some operating systems) Maximum number of datafiles per tablespace: OS dependent = usually 1022 Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance Bigfile tablespaces can contain only one file, but that file can have up to 4G blocks. |
|