| how to set DB_BLOCK_SIZE??????help meeeeeee...... [message #159228] |
Thu, 16 February 2006 21:00  |
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
|
Member |
|
|
HI ALL,
My database contain 1000 record. Size of a record is 250kb.
Can anybody help me to set size of DB_BLOCK_SIZE,PCT FREE,PCT USED,MAX EXTENTS... so that memory is used effectively and fast access
|
|
|
|
| Re: how to set DB_BLOCK_SIZE??????help meeeeeee...... [message #159230 is a reply to message #159228] |
Thu, 16 February 2006 21:53  |
newworld
Messages: 3
Registered: February 2006
|
Junior Member |
|
|
You can not change DB_BLOCK_SIZE of a database. The only way to change this parameter is export the whole database, then drop the databse and recreate it, and import the database.
And you can use:
ALTER TABLE XXX PCTFREE 30 PCTUSED 50 MAXEXTENTS 100;
to change other parameters.
|
|
|
|
|
|
|
|
| Re: how to set DB_BLOCK_SIZE??????help meeeeeee...... [message #159274 is a reply to message #159253] |
Fri, 17 February 2006 02:07 |
newworld
Messages: 3
Registered: February 2006
|
Junior Member |
|
|
DB_Block_Size is set to 4K~32K, you can't set it to 7000K. There is no need for you to change the DB_Block_Size, you can manully allocate some space to the table.
Usually, PCT_Free is set to 30, but it demands on your application. If you don't change the data in your table, you can set it to 0.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how to set DB_BLOCK_SIZE??????help meeeeeee...... [message #159382 is a reply to message #159357] |
Fri, 17 February 2006 22:52 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
I agree with Scot. This whole conversation concerns me. You should not be mucking about with DB_BLOCK_SIZE unless you are an experienced DBA. And - to be honest - that doesn't sound like an accurate description of the OP.
And how the heck do you get a 250Kb record anyway? That's a lot of full VARCHAR(2000) columns!!!
And if the entire database contains only a thousand rows, that's only 250Mb. You can fit the entire thing in memory!!!
Here's the second best advice you'll ever receive: Get out the phone book and your cheque book, and get an EXPERIENCED Oracle DBA Consultant to come out for 4 hours. It might cost you a few thousand bucks, but it will save you heaps.
The people who respond to this forum are good (especially since the advice is free), but there are limits when they cannot see your database first hand, or speak to you directly in your native language.
_____________
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
