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.

APPS.FND_STATS dependencies on DBA_TAB_MODIFICATIONS

Line 846: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;

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
848: IS
849: TABLE OF dba_tables.partitioned%TYPE;
850: part_flag partition_type_tab;

Line 1187: FROM sys.dba_tab_modifications dtm

1183: pnames -- ,spnames
1184: FROM
1185: ( SELECT dtm.table_name,
1186: dtm.partition_name
1187: FROM sys.dba_tab_modifications dtm
1188: WHERE dtm.table_owner = upper(schemaname)
1189: AND dtm.partition_name IS NULL
1190: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1191: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 1207: FROM sys.dba_tab_modifications dtm

1203: UNION ALL
1204:
1205: SELECT dtm.table_name,
1206: dtm.partition_name
1207: FROM sys.dba_tab_modifications dtm
1208: WHERE dtm.table_owner = upper(schemaname)
1209: AND dtm.partition_name IS NOT NULL
1210: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1211: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 1296: -- in dba_tab_modifications for next time.

1292: END LOOP;
1293: -- Check if there are any tables in the schema which does not have
1294: -- monitoring enabled. If yes, gather stats for them using 10% and
1295: -- enable monitoring for such tables so that we have data for them
1296: -- in dba_tab_modifications for next time.
1297: FOR c_rec IN nomon_tab(upper(schemaname))
1298: LOOP
1299: IF (upper(OPTIONS)='GATHER AUTO') THEN
1300: -- changes done for bug 11835452

Line 1478: FROM sys.dba_tab_modifications dtm

1474: pnames -- ,spnames
1475: FROM
1476: ( SELECT dtm.table_name,
1477: dtm.partition_name
1478: FROM sys.dba_tab_modifications dtm
1479: WHERE dtm.table_owner = upper(schemaname)
1480: AND dtm.partition_name IS NULL
1481: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1482: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 1506: FROM sys.dba_tab_modifications dtm

1502: UNION ALL
1503:
1504: SELECT dtm.table_name,
1505: dtm.partition_name
1506: FROM sys.dba_tab_modifications dtm
1507: WHERE dtm.table_owner = upper(schemaname)
1508: AND dtm.partition_name IS NOT NULL
1509: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
1510: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 1613: -- in dba_tab_modifications for next time.

1609: END LOOP;
1610: -- Check if there are any tables in the schema which does not have
1611: -- monitoring enabled. If yes, gather stats for them using 10% and
1612: -- enable monitoring for such tables so that we have data for them
1613: -- in dba_tab_modifications for next time.
1614: FOR c_rec IN nomon_tab_lt(upper(schemaname))
1615: LOOP
1616: IF (upper(OPTIONS)='GATHER AUTO') THEN
1617: -- changes done for bug 11835452

Line 1741: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;

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
1743: IS
1744: TABLE OF dba_tables.partitioned%TYPE;
1745: part_flag partition_type_tab;

Line 2097: FROM sys.dba_tab_modifications dtm

2093: pnames -- ,spnames
2094: FROM
2095: ( SELECT dtm.table_name,
2096: dtm.partition_name
2097: FROM sys.dba_tab_modifications dtm
2098: WHERE dtm.table_owner = upper(schemaname)
2099: AND dtm.partition_name IS NULL
2100: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2101: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 2117: FROM sys.dba_tab_modifications dtm

2113: )
2114: UNION ALL
2115: SELECT dtm.table_name,
2116: dtm.partition_name
2117: FROM sys.dba_tab_modifications dtm
2118: WHERE dtm.table_owner = upper(schemaname)
2119: AND dtm.partition_name IS NOT NULL
2120: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2121: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 2192: -- in dba_tab_modifications for next time.

2188: END LOOP;
2189: -- Check if there are any tables in the schema which does not have
2190: -- monitoring enabled. If yes, gather stats for them using 10% and
2191: -- enable monitoring for such tables so that we have data for them
2192: -- in dba_tab_modifications for next time.
2193: FOR c_rec IN nomon_tab(upper(schemaname))
2194: LOOP
2195: IF (upper(OPTIONS)='GATHER AUTO') THEN
2196: -- changes done for bug 11835452

Line 2362: FROM sys.dba_tab_modifications dtm

2358: pnames -- ,spnames
2359: FROM
2360: ( SELECT dtm.table_name,
2361: dtm.partition_name
2362: FROM sys.dba_tab_modifications dtm
2363: WHERE dtm.table_owner = upper(schemaname)
2364: AND dtm.partition_name IS NULL
2365: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2366: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 2389: FROM sys.dba_tab_modifications dtm

2385: )
2386: UNION ALL
2387: SELECT dtm.table_name,
2388: dtm.partition_name
2389: FROM sys.dba_tab_modifications dtm
2390: WHERE dtm.table_owner = upper(schemaname)
2391: AND dtm.partition_name IS NOT NULL
2392: AND dtm.TABLE_NAME NOT LIKE 'DR$%' -- added for Bug 8452962
2393: AND dtm.table_name not like 'DR#%' -- added for Bug 8452962

Line 2483: -- in dba_tab_modifications for next time.

2479: END LOOP;
2480: -- Check if there are any tables in the schema which does not have
2481: -- monitoring enabled. If yes, gather stats for them using 10% and
2482: -- enable monitoring for such tables so that we have data for them
2483: -- in dba_tab_modifications for next time.
2484: FOR c_rec IN nomon_tab(upper(schemaname))
2485: LOOP
2486: IF (upper(OPTIONS)='GATHER AUTO') THEN
2487: -- changes done for bug 11835452