Home » RDBMS Server » Performance Tuning » Reg Reorg activity (oracle 9206)
Reg Reorg activity [message #363085] Fri, 05 December 2008 01:18 Go to next message
anand47
Messages: 5
Registered: August 2008
Location: HYDERABAD
Junior Member
Hi all,

Is it possible to know before reorg on a schema. How much approximate space we are going to gain? Any query to find out?
if any one know please help
Re: Reg Reorg activity [message #363092 is a reply to message #363085] Fri, 05 December 2008 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to reorg?

Regards
Michel
Re: Reg Reorg activity [message #363101 is a reply to message #363085] Fri, 05 December 2008 02:07 Go to previous messageGo to next message
anand47
Messages: 5
Registered: August 2008
Location: HYDERABAD
Junior Member
Hi

We are having some performance issues in the database like slow response whenever we executing the queries.
Re: Reg Reorg activity [message #363105 is a reply to message #363101] Fri, 05 December 2008 02:18 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you think "reorganizing" will improve the performances?

Regards
Michel
Previous Topic: whats syntax to keep table in memory?
Next Topic: how to improve
Goto Forum:
  


Current Time: Mon Dec 05 06:59:19 CST 2016

Total time taken to generate the page: 0.13316 seconds