Home » RDBMS Server » Server Administration » I need some explanations!!
I need some explanations!! [message #242235] Fri, 01 June 2007 03:38 Go to next message
Messages: 666
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
When I was testing, I found one question like that:

When you created Dictionary Managed Tablespace without specifying a value for the Next parameter, what should be the size for the second extent allocated to that tablespace?

Please see my uploaded image.

And this is my question:

- I don't know why Oracle Server specifies the default value for Next parameter is 5 data blocks when without specifying. And I tried to search in Oracle documents and my books, however, I did not find.

- If my Oracle db_block_size is to be set as 8K, which is value for this scenario? It is 40K, isn't it?

Thank you for your help! ./fa/2558/0/

[Updated on: Fri, 01 June 2007 03:41]

Report message to a moderator

Re: I need some explanations!! [message #242237 is a reply to message #242235] Fri, 01 June 2007 03:49 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It says db block size is 2K.
So 5*2K = 10K.

Actually it is surely and old software. Nobody creates a db with 2K block size since many years.

Previous Topic: Install part of Oracle
Next Topic: Oracle 8.1.7 on windows 2003 64Bit
Goto Forum:

Current Time: Sun Oct 23 11:23:38 CDT 2016

Total time taken to generate the page: 0.04843 seconds