Home » RDBMS Server » Performance Tuning » help please...
help please... [message #234036] Sun, 29 April 2007 02:44 Go to next message
gaur_poonam
Messages: 20
Registered: April 2007
Location: India
Junior Member

hello,


i have a query about two prameters called PCTFREE and PCTUSED. if for better performance i need to tune both the parameters for a database, then it will affect the logical storage structure.for example i have old values set for both as,

PCTFREE=20
PCTUSED=40
now i have changed them to new values,like
PCTFREE=10
PCTUSED=50
so it will only effect to the new storage structures the old data which are already exist in database will not be affected by it. so if i want to give the changed values effect to the old data also, then is it possible? or i need to take the dump and need to restore to the new schema settings. please help me to get it solved.....

Re: help please... [message #234042 is a reply to message #234036] Sun, 29 April 2007 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"alter table move"

Regards
Michel
Re: help please... [message #234048 is a reply to message #234042] Sun, 29 April 2007 04:00 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
"alter table move"
Plus
Rebuild Indexes.

Regards
Taj
Previous Topic: Please help find the problem
Next Topic: Help - Rows accessed in FTS and Explain Plan
Goto Forum:
  


Current Time: Sun Dec 04 06:30:49 CST 2016

Total time taken to generate the page: 0.10939 seconds