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_TAB_MODIFICATIONS

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

838: IS
839: TABLE OF dba_tables.table_name%TYPE;
840: TYPE partition_tab
841: IS
842: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
843: TYPE partition_type_tab
844: IS
845: TABLE OF dba_tables.partitioned%TYPE;
846: part_flag partition_type_tab;

Line 1074: FROM sys.dba_tab_modifications dtm

1070: pnames -- ,spnames
1071: FROM
1072: ( SELECT dtm.table_name,
1073: dtm.partition_name
1074: FROM sys.dba_tab_modifications dtm
1075: WHERE dtm.table_owner = upper(schemaname)
1076: AND dtm.partition_name IS NULL
1077: AND EXISTS
1078: ( SELECT NULL

Line 1093: FROM sys.dba_tab_modifications dtm

1089: UNION ALL
1090:
1091: SELECT dtm.table_name,
1092: dtm.partition_name
1093: FROM sys.dba_tab_modifications dtm
1094: WHERE dtm.table_owner = upper(schemaname)
1095: AND dtm.partition_name IS NOT NULL
1096: AND EXISTS
1097: ( SELECT NULL

Line 1187: -- in dba_tab_modifications for next time.

1183: END LOOP;
1184: -- Check if there are any tables in the schema which does not have
1185: -- monitoring enabled. If yes, gather stats for them using 10% and
1186: -- enable monitoring for such tables so that we have data for them
1187: -- in dba_tab_modifications for next time.
1188: FOR c_rec IN nomon_tab(upper(schemaname))
1189: LOOP
1190: IF (upper(OPTIONS)='GATHER AUTO') THEN
1191: FND_STATS.GATHER_TABLE_STATS(ownname => c_rec.owner,

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

1305: IS
1306: TABLE OF dba_tables.table_name%TYPE;
1307: TYPE partition_tab
1308: IS
1309: TABLE OF sys.dba_tab_modifications.partition_name%TYPE;
1310: TYPE partition_type_tab
1311: IS
1312: TABLE OF dba_tables.partitioned%TYPE;
1313: part_flag partition_type_tab;

Line 1563: FROM sys.dba_tab_modifications dtm

1559: pnames -- ,spnames
1560: FROM
1561: ( SELECT dtm.table_name,
1562: dtm.partition_name
1563: FROM sys.dba_tab_modifications dtm
1564: WHERE dtm.table_owner = upper(schemaname)
1565: AND dtm.partition_name IS NULL
1566: AND EXISTS
1567: ( SELECT NULL

Line 1583: FROM sys.dba_tab_modifications dtm

1579: UNION ALL
1580:
1581: SELECT dtm.table_name,
1582: dtm.partition_name
1583: FROM sys.dba_tab_modifications dtm
1584: WHERE dtm.table_owner = upper(schemaname)
1585: AND dtm.partition_name IS NOT NULL
1586: AND EXISTS
1587: ( SELECT NULL

Line 1665: -- in dba_tab_modifications for next time.

1661: END LOOP;
1662: -- Check if there are any tables in the schema which does not have
1663: -- monitoring enabled. If yes, gather stats for them using 10% and
1664: -- enable monitoring for such tables so that we have data for them
1665: -- in dba_tab_modifications for next time.
1666: FOR c_rec IN nomon_tab(upper(schemaname))
1667: LOOP
1668: IF (upper(OPTIONS)='GATHER AUTO') THEN
1669: FND_STATS.GATHER_TABLE_STATS(ownname => c_rec.owner, tabname => c_rec.table_name,