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

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to reorg?

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you think "reorganizing" will improve the performances?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 04:38:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.