Home » RDBMS Server » Server Administration » maximum block size
maximum block size [message #56383] Tue, 25 March 2003 22:13 Go to next message
Depa
Messages: 30
Registered: June 2002
Member
what could be the maximum block size .

I know that preferred is multiples of os block size.

Is 16k a good one

Report message to a moderator

Re: maximum block size [message #56417 is a reply to message #56383] Thu, 27 March 2003 16:34 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
In Oracle you can have up to 32 Kb of db_block_size. The size depends on the type of the db you are having - OLTP or DWH.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: renaming database???
Next Topic: indexing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:32:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.