OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » HMV scripts (9.2.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HMV scripts [message #429672]

Thu, 05 November 2009 02:48

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

pablolee
Messages: 2882
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

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

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Migration from Oracle8i to Oracle 10G
Next Topic:	Buffer Catche

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 05:08:43 CST 2024