Dear Freinds,
I treid to create an APM component monitor using Oracle User Experience Monitor, following is the query
select * from (select round((s.us/d.maxbytes )*100,3) || ' [' || t.tablespace_name || ']' used from dba_tablespaces t, (select tablespace_name, sum(ma) maxbytes from (select tablespace_name, sum(bytes) ma from dba_data_files where maxbytes=0 group by tablespace_name union all select tablespace_name, sum(maxbytes) ma from dba_data_files where maxbytes<>0 group by tablespace_name) group by tablespace_name) d, (select tablespace_name,sum(bytes) us from dba_segments group by tablespace_name) s where t.tablespace_name=d.tablespace_name(+) and t.tablespace_name=s.tablespace_name(+) and t.tablespace_name not like 'UNDO%' and (s.us/d.maxbytes) <> 0 order by round((s.us/d.maxbytes)*100,3) desc) where ROWNUM <= 1;
After creating the component the status was showing error. When checked the component again I was surprised to see that only half of my query is saved,
select * from (select round((s.us/d.maxbytes )*100,3) || ' [' || t.tablespace_name || ']' used from dba_tablespaces t, (select tablespace_name, sum(ma) maxbytes from (select tablespace_name, sum(bytes) ma from dba_data_files where maxbytes=0 group by tablespace_name union all select tablespace_name, sum(maxbytes) ma from dba_data_files where maxbytes<>0 group by tablespace_name) group by tablespace_name) d, (select tablespace_name,sum(bytes) us from dba_segments group by tablespace_name) s where t.tablespac
I would like to know is there any limitations in number of characters for SQL Query field in APM.
Regards,
Biju.
