OraFAQ Forum: Server Administration » Need help with tablespace usage script

Home » RDBMS Server » Server Administration » Need help with tablespace usage script (8.0.6)

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

Need help with tablespace usage script [message #457564]

Tue, 25 May 2010 04:15

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Hi,

I am looking for a script to find the tbs usage including datafiles. Please see that the format is of this kind:

Tablespaces Datafile Size Used Free Used% Free% Max MB

Need all the data in MB and all the datafile space in every tablespace.

I have searched internet,but couldn't find this type of format.

Best Regards,

Report message to a moderator

Re: Need help with tablespace usage script [message #457568 is a reply to message #457564]

Tue, 25 May 2010 04:20

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

Senior Member
Account Moderator

There are so many scripts for this that I'm surprised you didn't find one during the search you made before posting (I can't imagine you didn't do it, did you?).

Regards
Michel

Report message to a moderator

Re: Need help with tablespace usage script [message #457576 is a reply to message #457568]

Tue, 25 May 2010 04:45

halim
Messages: 100
Registered: September 2008

Senior Member

OK, I generate it from toad 9.6

MC: Query removed due to copyright. See below.

[Updated on: Tue, 25 May 2010 07:55] by Moderator

Report message to a moderator

Re: Need help with tablespace usage script [message #457580 is a reply to message #457576]

Tue, 25 May 2010 04:56

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

Senior Member
Account Moderator

Quote:

OK, I generate it from toad 9.

What does this mean?

Regards
Michel

Report message to a moderator

Re: Need help with tablespace usage script [message #457587 is a reply to message #457580]

Tue, 25 May 2010 05:13

halim
Messages: 100
Registered: September 2008

Senior Member

Michel sir, forget it.

Report message to a moderator

Re: Need help with tablespace usage script [message #457590 is a reply to message #457587]

Tue, 25 May 2010 05:33

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

Senior Member
Account Moderator

I can't forget it, so please answer, do you copy a query that TOAD generates for its report?

Regards
Michel

Report message to a moderator

Re: Need help with tablespace usage script [message #457593 is a reply to message #457590]

Tue, 25 May 2010 05:54

halim
Messages: 100
Registered: September 2008

Senior Member

Yes sir.

Report message to a moderator

Re: Need help with tablespace usage script [message #457600 is a reply to message #457593]

Tue, 25 May 2010 06:08

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

Senior Member
Account Moderator

Are you sure you have the right to post it and it is not protected by any coyright law?

Regards
Michel

Report message to a moderator

Re: Need help with tablespace usage script [message #457615 is a reply to message #457600]

Tue, 25 May 2010 07:00

halim
Messages: 100
Registered: September 2008

Senior Member

I read its copyright law.
Please Michel sir remove this above message from here.

[Updated on: Tue, 25 May 2010 07:01]

Report message to a moderator

Re: Need help with tablespace usage script [message #457631 is a reply to message #457615]

Tue, 25 May 2010 07:55

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

Senior Member
Account Moderator

Done.

Regards
Michel

Report message to a moderator

Previous Topic:	10.2.0.4 upgrade
Next Topic:	moving the archivelog location

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 05:52:12 CST 2025