Home » RDBMS Server » Server Administration » block size
block size [message #257626] Wed, 08 August 2007 16:22 Go to next message
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 #257628 is a reply to message #257626] Wed, 08 August 2007 16:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How we can calculate the maximum number of blocks par datafile
You don't calculate it. It is Operating System dependent.

Whose blocks, Oracle blocks or file system blocks?
With Oracle V9 or higher supports multiple blocks sizes.
So it depends.
Re: block size [message #257656 is a reply to message #257626] Wed, 08 August 2007 23:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Reference
Annex A Database Limits
Section Physical Database Limits
Quote:
Operating system dependent. Limited by maximum operating system file size; typically 2^22 or 4 MB blocks

Regards
Michel
Re: block size [message #257790 is a reply to message #257656] Thu, 09 August 2007 03:07 Go to previous messageGo to next message
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 #257797 is a reply to message #257790] Thu, 09 August 2007 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't download JPG file.
Copy and paste in text format.

Regards
Michel
Re: block size [message #257814 is a reply to message #257797] Thu, 09 August 2007 04:22 Go to previous messageGo to next message
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 #257826 is a reply to message #257814] Thu, 09 August 2007 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same page:
Quote:
A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion (2^32) blocks.


Regards
Michel
Re: block size [message #257844 is a reply to message #257814] Thu, 09 August 2007 06:04 Go to previous messageGo to next message
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...
Re: block size [message #257855 is a reply to message #257844] Thu, 09 August 2007 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We can.

Regards
Michel
Re: block size [message #257905 is a reply to message #257855] Thu, 09 August 2007 08:32 Go to previous message
mohsinali
Messages: 24
Registered: December 2006
Location: KARACHI PAKISTAN
Junior Member
thankyou soo much
Previous Topic: login
Next Topic: How Can Create Table With diffrent TableSpaces in oracle 10g
Goto Forum:
  


Current Time: Sat Dec 10 07:08:06 CST 2016

Total time taken to generate the page: 0.08967 seconds