OraFAQ Forum: Performance Tuning » PCTFREE and PCTUSED

Home » RDBMS Server » Performance Tuning » PCTFREE and PCTUSED (10g Warehouse database on RHEL4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PCTFREE and PCTUSED [message #393306]

Sat, 21 March 2009 04:43

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,

Report message to a moderator

Re: PCTFREE and PCTUSED [message #393308 is a reply to message #393306]

Sat, 21 March 2009 04:54

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: PCTFREE and PCTUSED [message #393311 is a reply to message #393308]

Sat, 21 March 2009 05:27

nandusb
Messages: 4
Registered: March 2009
Location: INDIA

Junior Member

The table is imported from other database
which is near abot 0.5GB

Report message to a moderator

Re: PCTFREE and PCTUSED [message #393324 is a reply to message #393306]

Sat, 21 March 2009 09:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If you are using Local Managed Tablespace (LMT), you do not have to worry about these details.

Report message to a moderator

Re: PCTFREE and PCTUSED [message #397118 is a reply to message #393324]

Thu, 09 April 2009 02:08

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

Report message to a moderator

Re: PCTFREE and PCTUSED [message #397122 is a reply to message #397118]

Thu, 09 April 2009 02:39

Michel Cadot
Messages: 68664
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 11:41:34 CDT 2024