skip to main
|
skip to sidebar
From a Small Potato DBA:
a collections of tips and scripts I've used at work
Wednesday, November 21, 2007
Calculate free space in TEMP tablespace
select tablespace_name, SUM(bytes_used), sum(bytes_free)
from v$temp_space_header
where tablespace_name = ‘TEMP’
group by tablespace_name;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
cytodex
- a small potato DBA.
View my complete profile
Blog Archive
▼
2007
(9)
▼
November
(9)
System Statistics
List all existing database links
Calculate free space in TEMP tablespace
Commands on AIX
SQLPlus could not be started
Unable to connect SQLState=IM004 [Microsoft][ODBC ...
ORA-27092: skgfofi: size of file exceeds file size...
Using ODBC driver in VBScript to connect to Oracle DB
Resize redo log files
Links
http://tkyte.blogspot.com/
No comments:
Post a Comment