Friday, February 14, 2014

Oracle table space threshold monitor in AIX


www.unixbabuforum.inDoes anyone know of any AIX command that can display Oracle table space 
thresholds? 


We are challenge with some table spaces filling up and don't have 
visibility from the AIX side. 


www.unixbabuforum.inUse this SQL select to get information about free extends in tablespace 

SELECT TABLESPACE_NAME "TABLESPACE", FILE_ID, 
COUNT(*) "PIECES", 
MAX(blocks) "MAXIMUM", 
MIN(blocks) "MINIMUM", 
AVG(blocks) "AVERAGE", 
SUM(blocks) "TOTAL" 

FROM DBA_FREE_SPACE 
GROUP BY TABLESPACE_NAME, FILE_ID; 

www.unixbabuforum.inFirst of all you have 
to connect to DB..You maybe write a shell script that can connect to DB 
and query or show commands may run from sqlplus. 

0 comments:

Post a Comment

 
Design by BABU | Dedicated to grandfather | welcome to BABU-UNIX-FORUM