eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_STATS dependencies on DBA_TABLES

Line 77: TABLE OF dba_tables.table_name%TYPE;

73: schemaname IN VARCHAR2)
74: IS
75: TYPE name_tab
76: IS
77: TABLE OF dba_tables.table_name%TYPE;
78: tmp_str VARCHAR2(200);
79: names name_tab;
80: num_tables NUMBER := 0;
81: modeval VARCHAR2(5);

Line 107: FROM dba_tables

103: /* schema_cur */
104: ELSE -- schemaname<>'ALL'
105: SELECT table_name BULK COLLECT
106: INTO names
107: FROM dba_tables
108: WHERE owner = upper(schemaname)
109: AND
110: (
111: iot_type <> 'IOT_OVERFLOW'

Line 843: TABLE OF dba_tables.table_name%TYPE;

839: invalidate IN VARCHAR2 DEFAULT 'Y' )
840: IS
841: TYPE name_tab
842: IS
843: TABLE OF dba_tables.table_name%TYPE;
844: TYPE partition_tab
845: IS
846: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
847: TYPE partition_type_tab

Line 849: TABLE OF dba_tables.partitioned%TYPE;

845: IS
846: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
847: TYPE partition_type_tab
848: IS
849: TABLE OF dba_tables.partitioned%TYPE;
850: part_flag partition_type_tab;
851: names name_tab;
852: pnames partition_tab;
853: num_tables NUMBER := 0;

Line 871: FROM dba_tables dt

867: FROM
868: ( SELECT 'TABLE' type,
869: owner ,
870: table_name name
871: FROM dba_tables dt
872: WHERE owner=upper(schemaname)
873: AND
874: (
875: iot_type <> 'IOT_OVERFLOW'

Line 923: FROM dba_tables dt

919: CURSOR nomon_tab(schemaname VARCHAR2)
920: IS
921: SELECT owner,
922: table_name
923: FROM dba_tables dt
924: WHERE owner=upper(schemaname)
925: AND
926: (
927: iot_type <> 'IOT_OVERFLOW'

Line 946: FROM dba_tables dt

942: CURSOR nomon_tab_lt(schemaname VARCHAR2) -- this is for locking stats on table
943: IS
944: SELECT owner,
945: table_name
946: FROM dba_tables dt
947: WHERE owner=upper(schemaname)
948: AND
949: (
950: iot_type <> 'IOT_OVERFLOW'

Line 981: FROM dba_tables dt

977: FROM
978: ( SELECT 'TABLE' type,
979: owner ,
980: table_name name
981: FROM dba_tables dt
982: WHERE owner=upper(schemaname)
983: AND
984: (
985: iot_type <> 'IOT_OVERFLOW'

Line 1090: FROM dba_tables dt

1086: SELECT table_name ,
1087: partitioned BULK COLLECT
1088: INTO names,
1089: part_flag
1090: FROM dba_tables dt
1091: WHERE owner = upper(schemaname)
1092: AND
1093: (
1094: iot_type <> 'IOT_OVERFLOW'

Line 1194: FROM dba_tables dt

1190: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1191: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962
1192: AND EXISTS
1193: ( SELECT NULL
1194: FROM dba_tables dt
1195: WHERE dt.owner =dtm.table_owner
1196: AND dt.table_name=dtm.table_name
1197: AND
1198: (

Line 1363: FROM dba_tables dt

1359: SELECT table_name ,
1360: partitioned BULK COLLECT
1361: INTO names,
1362: part_flag
1363: FROM dba_tables dt
1364: WHERE owner = upper(schemaname)
1365: AND
1366: (
1367: iot_type <> 'IOT_OVERFLOW'

Line 1485: FROM dba_tables dt

1481: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1482: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962
1483: AND EXISTS
1484: ( SELECT NULL
1485: FROM dba_tables dt
1486: WHERE dt.owner =dtm.table_owner
1487: AND dt.table_name=dtm.table_name
1488: AND
1489: (

Line 1738: TABLE OF dba_tables.table_name%TYPE;

1734: invalidate IN VARCHAR2 DEFAULT 'Y' )
1735: IS
1736: TYPE name_tab
1737: IS
1738: TABLE OF dba_tables.table_name%TYPE;
1739: TYPE partition_tab
1740: IS
1741: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
1742: TYPE partition_type_tab

Line 1744: TABLE OF dba_tables.partitioned%TYPE;

1740: IS
1741: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
1742: TYPE partition_type_tab
1743: IS
1744: TABLE OF dba_tables.partitioned%TYPE;
1745: part_flag partition_type_tab;
1746: names name_tab;
1747: pnames partition_tab;
1748: num_tables NUMBER := 0;

Line 1767: FROM dba_tables dt

1763: FROM
1764: ( SELECT 'TABLE' type,
1765: owner ,
1766: table_name name
1767: FROM dba_tables dt
1768: WHERE owner=upper(schemaname)
1769: AND
1770: (
1771: iot_type <> 'IOT_OVERFLOW'

Line 1830: FROM dba_tables dt

1826: CURSOR nomon_tab(schemaname VARCHAR2)
1827: IS
1828: SELECT owner,
1829: table_name
1830: FROM dba_tables dt
1831: WHERE owner=upper(schemaname)
1832: AND
1833: (
1834: iot_type <> 'IOT_OVERFLOW'

Line 1853: FROM dba_tables dt

1849: CURSOR nomon_tab_lt(schemaname VARCHAR2) -- this is for locking stats on table
1850: IS
1851: SELECT owner,
1852: table_name
1853: FROM dba_tables dt
1854: WHERE owner=upper(schemaname)
1855: AND
1856: (
1857: iot_type <> 'IOT_OVERFLOW'

Line 1888: FROM dba_tables dt

1884: FROM
1885: ( SELECT 'TABLE' type,
1886: owner ,
1887: table_name name
1888: FROM dba_tables dt
1889: WHERE owner=upper(schemaname)
1890: AND
1891: (
1892: iot_type <> 'IOT_OVERFLOW'

Line 2001: FROM dba_tables dt

1997: SELECT table_name ,
1998: partitioned BULK COLLECT
1999: INTO names,
2000: part_flag
2001: FROM dba_tables dt
2002: WHERE owner = upper(schemaname)
2003: AND
2004: (
2005: iot_type <> 'IOT_OVERFLOW'

Line 2104: FROM dba_tables dt

2100: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2101: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962
2102: AND EXISTS
2103: ( SELECT NULL
2104: FROM dba_tables dt
2105: WHERE dt.owner =dtm.table_owner
2106: AND dt.table_name =dtm.table_name
2107: AND dt.partitioned='NO'
2108: AND

Line 2247: FROM dba_tables dt

2243: SELECT table_name ,
2244: partitioned BULK COLLECT
2245: INTO names,
2246: part_flag
2247: FROM dba_tables dt
2248: WHERE owner = upper(schemaname)
2249: AND
2250: (
2251: iot_type <> 'IOT_OVERFLOW'

Line 2369: FROM dba_tables dt

2365: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2366: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962
2367: AND EXISTS
2368: ( SELECT NULL
2369: FROM dba_tables dt
2370: WHERE dt.owner =dtm.table_owner
2371: AND dt.table_name =dtm.table_name
2372: AND dt.partitioned='NO'
2373: AND

Line 3552: FROM dba_tables

3548: WHEN no_data_found THEN
3549: BEGIN
3550: SELECT 'EXIST'
3551: INTO exist_flag
3552: FROM dba_tables
3553: WHERE table_name = upper(tabname)
3554: AND owner =
3555: ( SELECT b.oracle_username
3556: FROM fnd_product_installations a,

Line 3566: || ' does not exist in fnd_tables/dba_tables for the

3562: EXCEPTION
3563: WHEN no_data_found THEN
3564: raise_application_error(-20000, 'Table '
3565: || tabname
3566: || ' does not exist in fnd_tables/dba_tables for the
3567: given application ');
3568: END;
3569: END;
3570: -- Now insert

Line 4305: last_analyzed dba_tables.last_analyzed%type;

4301: /************************************************************************/
4302: PROCEDURE table_stats(schema VARCHAR2,
4303: tableName VARCHAR2)
4304: IS
4305: last_analyzed dba_tables.last_analyzed%type;
4306: sample_size dba_tables.sample_size%type;
4307: num_rows dba_tables.num_rows%type;
4308: blocks dba_tables.blocks%type;
4309: BEGIN

Line 4306: sample_size dba_tables.sample_size%type;

4302: PROCEDURE table_stats(schema VARCHAR2,
4303: tableName VARCHAR2)
4304: IS
4305: last_analyzed dba_tables.last_analyzed%type;
4306: sample_size dba_tables.sample_size%type;
4307: num_rows dba_tables.num_rows%type;
4308: blocks dba_tables.blocks%type;
4309: BEGIN
4310: SELECT last_analyzed ,

Line 4307: num_rows dba_tables.num_rows%type;

4303: tableName VARCHAR2)
4304: IS
4305: last_analyzed dba_tables.last_analyzed%type;
4306: sample_size dba_tables.sample_size%type;
4307: num_rows dba_tables.num_rows%type;
4308: blocks dba_tables.blocks%type;
4309: BEGIN
4310: SELECT last_analyzed ,
4311: sample_size ,

Line 4308: blocks dba_tables.blocks%type;

4304: IS
4305: last_analyzed dba_tables.last_analyzed%type;
4306: sample_size dba_tables.sample_size%type;
4307: num_rows dba_tables.num_rows%type;
4308: blocks dba_tables.blocks%type;
4309: BEGIN
4310: SELECT last_analyzed ,
4311: sample_size ,
4312: TRUNC(num_rows),

Line 4318: FROM dba_tables

4314: INTO last_analyzed,
4315: sample_size ,
4316: num_rows ,
4317: blocks
4318: FROM dba_tables
4319: WHERE table_name = tableName
4320: AND owner = schema;
4321:
4322: dbms_output.put_line('===================================================================================================');

Line 4723: FROM dba_tables dt

4719: CURSOR all_tables(schema VARCHAR2)
4720: IS
4721: SELECT table_name,
4722: owner
4723: FROM dba_tables dt
4724: WHERE owner = schema
4725: AND
4726: (
4727: iot_type <> 'IOT_OVERFLOW'