| block size [message #257626] |
Wed, 08 August 2007 16:22  |
mohsinali
Messages: 24
Registered: December 2006
Location: KARACHI PAKISTAN
|
Junior Member |
|
|
Hello,
How we can calculate the maximum number of blocks par datafile
|
|
|
|
|
|
|
|
| Re: block size [message #257790 is a reply to message #257656] |
Thu, 09 August 2007 03:07  |
mohsinali
Messages: 24
Registered: December 2006
Location: KARACHI PAKISTAN
|
Junior Member |
|
|
|
i am attaching a file ... its a question i am not understanding how they are calculating the blocks par datafile
|
|
|
|
|
|
| Re: block size [message #257814 is a reply to message #257797] |
Thu, 09 August 2007 04:22 |
mohsinali
Messages: 24
Registered: December 2006
Location: KARACHI PAKISTAN
|
Junior Member |
|
|
Q:What is the maximum number of bytes that can be stored in a database with DB_FILES=20 and a database block size of 8kb.
A: 655,360 gigabytes
B: 4 exabytes
C: 163,840 terabytes
D: 1 exabytes
Answer is A:
Explanation : you can calculate the maximum amount of space (M) as the maximum number of datafiles (D) multiplied by the maximum number of blocks par datafile (F) multiplied by the tablespace blocksize (B): M =D * F * B = 20 * 4 Billion * 8192 = 655,360,000,000,000 = 655360 gb. The maximum database size given by the maximum block size and the maximum number of datafiles is 65535 files * 4,000,000,000 bytes per file * 32768 block size = 8589,803,520,000,000,000 = 8 Eb.
i am confused with teh calucalation of F that is maximum number of blocks par datafile.?
|
|
|
|
|
|
| Re: block size [message #257844 is a reply to message #257814] |
Thu, 09 August 2007 06:04 |
mohsinali
Messages: 24
Registered: December 2006
Location: KARACHI PAKISTAN
|
Junior Member |
|
|
|
thankyou micheal.... i want to ask that they havent specified that the database contains bigfile tablespace.... can we take it as assumption...
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
