ORACLE_OCM.MGMT_DB_LL_METRICS dependencies on DBA_TABLES

Line 725: ' sys.dba_tablespaces dtp';

721: l_segspace ||
722: l_blocksize ||
723: l_bigfile ||
724: ' FROM '||
725: ' sys.dba_tablespaces dtp';
726:
727: -- collect the metric, given the decisions made above
728: write_metric('db_tablespaces',l_sql_db_tablespaces);
729:

Line 1712: v_schema dba_tables.owner%TYPE;

1708: PROCEDURE write_oem
1709: IS
1710: cursor1 integer;
1711: v_count number(1) := 0;
1712: v_schema dba_tables.owner%TYPE;
1713: v_version varchar2(10);
1714: v_component varchar2(20);
1715: l_rows_processed integer;
1716: CURSOR schema_array IS

Line 1718: FROM dba_tables WHERE table_name = 'SMP_REP_VERSION';

1714: v_component varchar2(20);
1715: l_rows_processed integer;
1716: CURSOR schema_array IS
1717: SELECT '"' || owner || '"'
1718: FROM dba_tables WHERE table_name = 'SMP_REP_VERSION';
1719:
1720: CURSOR schema_array_v2 IS
1721: SELECT owner
1722: FROM dba_tables WHERE table_name = 'SMP_VDS_REPOS_VERSION';

Line 1722: FROM dba_tables WHERE table_name = 'SMP_VDS_REPOS_VERSION';

1718: FROM dba_tables WHERE table_name = 'SMP_REP_VERSION';
1719:
1720: CURSOR schema_array_v2 IS
1721: SELECT owner
1722: FROM dba_tables WHERE table_name = 'SMP_VDS_REPOS_VERSION';
1723: BEGIN
1724: BEGIN
1725: SELECT COUNT(*)
1726: INTO v_count FROM ( SELECT DISTINCT program FROM

Line 1836: from dba_tables

1832: 'select 1 from (select sum(tot) CNT from
1833: ( select count(*) tot
1834: from
1835: ( select owner, table_name
1836: from dba_tables
1837: where partitioned=''YES''
1838: -- list of schemas to be excluded
1839: and owner not in (''SYS'',''SYSTEM'',''SH'',''MDSYS'')
1840: minus

Line 1924: from dba_tables

1920: IF g_version_category = VERSION_817 THEN
1921: l_isUsedSQL :=
1922: 'select 1 from (select sum(tot) CNT from
1923: ( select count(*) tot
1924: from dba_tables
1925: where partitioned=''YES''
1926: and owner not in (''SYS'',''SYSTEM'',''SH'',''MDSYS'')
1927: union all
1928: select count(*) tot