Home » RDBMS Server » Server Administration » Verify Tablespace space (Oracle 10.2.0.4.0, SunOS)
Verify Tablespace space [message #538698] Mon, 09 January 2012 01:42 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Application team requested hosting team to add some space to tablespace as it was exceeding 80% used.Now the hosting team have added the space as per recomendation and the application team wants us to verify if the space was added.

Can somebody tell me how to check the space was added in GB to list of tablesapces ?

Thank you

Report message to a moderator

Re: Verify Tablespace space [message #538701 is a reply to message #538698] Mon, 09 January 2012 01:54 Go to previous messageGo to next message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
Can you not use the same query that your application team used when they determined that the tablespace was 80% full?

[update: typo]

[Updated on: Mon, 09 January 2012 01:55]

Report message to a moderator

Re: Verify Tablespace space [message #538707 is a reply to message #538698] Mon, 09 January 2012 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can somebody tell me how to check the space was added in GB to list of tablesapces ?

DBA_DATA_FILES
DBA_FREE_SPACE

All catalog views are described in Database Reference

Regards
Michel

Report message to a moderator

Re: Verify Tablespace space [message #538711 is a reply to message #538701] Mon, 09 January 2012 02:20 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member

Sorry to mention is that we do not know how much the size was before hosting team added space.

Report message to a moderator

Re: Verify Tablespace space [message #538713 is a reply to message #538711] Mon, 09 January 2012 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
(Almost) All ALTER DATABASE or ALTER TABLESPACE statements are reported in alert.log.

Regards
Michel

[Updated on: Mon, 09 January 2012 02:24]

Report message to a moderator

Re: Verify Tablespace space [message #538718 is a reply to message #538713] Mon, 09 January 2012 03:37 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member

Thank you Michel for your answer.

Report message to a moderator

Previous Topic: Convert dictionary managed tablespace to Locally managed tablespace
Next Topic: finding private and public db_links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 20:34:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.