Home » RDBMS Server » Performance Tuning » PCTFREE and PCTUSED (10g Warehouse database on RHEL4)
PCTFREE and PCTUSED [message #393306] Sat, 21 March 2009 04:43 Go to next message
nandusb
Messages: 4
Registered: March 2009
Location: INDIA
Junior Member
hi,

Currently I am working on 10g warehouse database,
I want to set PCTFREE and PCTUSED for a table
which will not have any insert and update operation
Only salact operation will be performed
but in future it is most likely that some delete operations might be performed.

So please sugest me value for PCTFREE and PCTUSED and also for INITRANS and INITMAX


Thanks,
Re: PCTFREE and PCTUSED [message #393308 is a reply to message #393306] Sat, 21 March 2009 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
which will not have any insert and update operation

If there is never any insert then the table is empty and parameters are not important. Razz

As there is no update, set PCTFREE to 0 (or as less as possible), use LMT and ASSM then PCTUSED is meaningless.
As there is no transaction, don't care about INITRANS. MAXTRANS is obsolete in 10g.

Regards
Michel
Re: PCTFREE and PCTUSED [message #393311 is a reply to message #393308] Sat, 21 March 2009 05:27 Go to previous messageGo to next message
nandusb
Messages: 4
Registered: March 2009
Location: INDIA
Junior Member
The table is imported from other database
which is near abot 0.5GB
Re: PCTFREE and PCTUSED [message #393324 is a reply to message #393306] Sat, 21 March 2009 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
If you are using Local Managed Tablespace (LMT), you do not have to worry about these details.
Re: PCTFREE and PCTUSED [message #397118 is a reply to message #393324] Thu, 09 April 2009 02:08 Go to previous messageGo to next message
rakesh.c.purohit
Messages: 3
Registered: September 2008
Location: New Delhi
Junior Member

Hi all,

my database is in testing phase.

when I looked the data block (used and pctfree) it shows me almost full. Like

Total block size = 8
used block = 7

so what should I do

Rakesh
New Delhi


Re: PCTFREE and PCTUSED [message #397122 is a reply to message #397118] Thu, 09 April 2009 02:39 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when I looked the data block (used and pctfree) it shows me almost full. Like

Copy and paste what you did, don't explain it.

Quote:
so what should I do

Nothing. Why do you think there is something to do? What is your concern?

Regards
Michel

Previous Topic: Report Taking So Much Of Time and goes into ORA-01555
Next Topic: Can any one help me to tune this query.
Goto Forum:
  


Current Time: Sun Dec 11 00:17:50 CST 2016

Total time taken to generate the page: 0.17817 seconds