Home » RDBMS Server » Performance Tuning » HMV scripts (9.2.0.7)
HMV scripts [message #429672] Thu, 05 November 2009 02:48 Go to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member

Please provide a free space report for the one of my PROD instance.

The report should show the total free space available below the HWM of each table. The report should show the Total per tablespace and a summary total for the instance.

The goal is to determine how much space would be reclaimed if the client had us export and import the entire pap1 database. They want to know how much free space is below the high water mark.

Please help....
Re: HMV scripts [message #429686 is a reply to message #429672] Thu, 05 November 2009 04:03 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
Have you made any attempt whatsoever to complete this task yourself or do you just expect others to do your job for you?
Re: HMV scripts [message #429688 is a reply to message #429672] Thu, 05 November 2009 04:14 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
The below link may be helpful for you
http://www.labyrinth-it.co.uk/HighWater.pdf

[Updated on: Thu, 05 November 2009 04:15]

Report message to a moderator

Re: HMV scripts [message #429693 is a reply to message #429686] Thu, 05 November 2009 04:34 Go to previous messageGo to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member

I'm sorry Mr/Mrs pablolee....

I wanted the script, if you have please give it... I don't need any special comments here.

Thanks for understanding.

Cheers
Puneet Sachar
Re: HMV scripts [message #429703 is a reply to message #429693] Thu, 05 November 2009 05:35 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you didn't chose the appropriate forum for you.
Here will help people learn, we help them in their job, we DON'T do it for them.

Regards
Michel
Previous Topic: Migration from Oracle8i to Oracle 10G
Next Topic: Buffer Catche
Goto Forum:
  


Current Time: Wed Sep 28 07:28:20 CDT 2016

Total time taken to generate the page: 0.07968 seconds