| Usage in Temp-Tablespace [message #110502] |
Tue, 08 March 2005 03:24  |
alfie
Messages: 5
Registered: February 2005
|
Junior Member |
|
|
Hello,
i have a 9.2.0.5-db in a solaris9-environment for a SAP-system.
The temp-tablespace has a size of 12 G.
Now I want to know how much space is free in this tablespace.
And there is my problem:
SAP says: tablespace temp is completly free.
OEM says: in tablespace temp is only 1 % free-space left.
v$sort_segment says: all blocks free.
v$temp_space_header says: all bytes used.
v$temp_extent_pool says: no bytes used, but all bytes are cached.
So: how much space I have left in my temp-tablespace.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
