Service Desk Practitioners Forum
cancel

Check Database Table Capacity in Oracle

Highlighted
TrisnoBangun
New Member.

Check Database Table Capacity in Oracle

Salomm,
I want ask some silly question :> ,
How to check my table capacity ( unused and used ) ???
And how i maintanance my oracle database ?

Tq for your respons

Trisno
Indonesia
3 REPLIES
Mihai Tita
Outstanding Contributor.

Re: Check Database Table Capacity in Oracle

Hi,

You can use Oracle Enterprise Manager Console from Oracle kit.
You can install it on Oracle client environment.
In Oracle Enterprise Manager Console: Databases -> Storage -> Tablespaces

You can use some comercial products like TOAD for Oracle (http://www.quest.com/oracle/) or other freeware software, like TOAD for Oracle Freeware (http://www.toadsoft.com/lic_agree.html).

Regards,
Mihai
TrisnoBangun
New Member.

Re: Check Database Table Capacity in Oracle

Hi Mihai,

I cannt use Enterprises Manager coz my oracle installed in Unix not a windows. is there any way to check it using some command ??


Regards
TB
Mihai Tita
Outstanding Contributor.

Re: Check Database Table Capacity in Oracle

Hi,

You can use Oracle Enterprise Manager.
Instal Oracle client on a windows machine with Oracle Enterprise Manager.
For example, we run HP OV SD on Solaris.

Regards,
Mihai