Members   Search   Help    Register    Login   Home
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....
Report message to a moderator
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: 1673
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?
Report message to a moderator
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: 127
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
Report message to a moderator
Re: HMV scripts [message #429703 is a reply to message #429693] Thu, 05 November 2009 05:35 Go to previous message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
Previous Topic:Migration from Oracle8i to Oracle 10G
Next Topic:Buffer Catche
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 19:38:29 CST 2009

Total time taken to generate the page: 0.12654 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.