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


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,

now i have changed them to new values,like
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: 64967
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"alter table move"

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

"alter table move"
Rebuild Indexes.

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

Current Time: Thu Jun 29 11:11:51 CDT 2017

Total time taken to generate the page: 0.09440 seconds