[Home] [Help]
23: g_Errors Error_Out;
24: -- New cursort to support MVs
25: CURSOR schema_cur IS
26: SELECT upper(oracle_username) sname
27: FROM fnd_oracle_userid
28: WHERE oracle_id BETWEEN 900 AND 999
29: AND read_only_flag = 'U'
30:
31: UNION ALL
30:
31: UNION ALL
32:
33: SELECT DISTINCT upper(oracle_username) sname
34: FROM fnd_oracle_userid a,
35: fnd_product_installations b
36: WHERE a.oracle_id = b.oracle_id
37: ORDER BY sname;
38:
545: a.table_name tabname,
546: a.column_name colname,
547: a.partition partname
548: from FND_HISTOGRAM_COLS a,
549: FND_ORACLE_USERID b,
550: FND_PRODUCT_INSTALLATIONS c
551: where a.application_id = c.application_id
552: and c.oracle_id = b.oracle_id
553: order by ownname, tabname, column_name;
558: a.table_name tabname ,
559: a.column_name colname ,
560: a.partition partname
561: FROM FND_HISTOGRAM_COLS a,
562: FND_ORACLE_USERID b ,
563: FND_PRODUCT_INSTALLATIONS c
564: WHERE a.application_id = c.application_id (+)
565: AND c.oracle_id = b.oracle_id (+)
566: ORDER BY ownname,
985: )
986: AND NOT EXISTS
987: (SELECT NULL
988: FROM fnd_exclude_table_stats fets,
989: fnd_oracle_userid fou ,
990: fnd_product_installations fpi
991: WHERE fou.oracle_username=upper(schemaname)
992: AND fou.oracle_id =fpi.oracle_id
993: AND fpi.application_id = fets.application_id
1343: -- leave alone if excluded table
1344: AND NOT EXISTS
1345: (SELECT NULL
1346: FROM fnd_exclude_table_stats fets,
1347: fnd_oracle_userid fou ,
1348: fnd_product_installations fpi
1349: WHERE fou.oracle_username=upper(schemaname)
1350: AND fou.oracle_id =fpi.oracle_id
1351: AND fpi.application_id = fets.application_id
1368: AND di.last_analyzed IS NULL
1369: AND NOT EXISTS
1370: (SELECT NULL
1371: FROM fnd_exclude_table_stats fets,
1372: fnd_oracle_userid fou ,
1373: fnd_product_installations fpi
1374: WHERE fou.oracle_username=upper(schemaname)
1375: AND fou.oracle_id =fpi.oracle_id
1376: AND fpi.application_id =fets.application_id
1475: -- leave alone if excluded table
1476: AND NOT EXISTS
1477: (SELECT NULL
1478: FROM fnd_exclude_table_stats fets,
1479: fnd_oracle_userid fou ,
1480: fnd_product_installations fpi
1481: WHERE fou.oracle_username=upper(schemaname)
1482: AND fou.oracle_id =fpi.oracle_id
1483: AND fpi.application_id = fets.application_id
2108: SELECT a.column_name ,
2109: NVL(a.hsize,254) hsize,
2110: NVL(a.owner, upper(b.oracle_username)) ownname
2111: FROM FND_HISTOGRAM_COLS a,
2112: FND_ORACLE_USERID b ,
2113: FND_PRODUCT_INSTALLATIONS c
2114: WHERE a.application_id = appl_id
2115: AND a.application_id = c.application_id (+)
2116: AND c.oracle_id = b.oracle_id (+)
2232: IS
2233: SELECT DISTINCT a.table_name,
2234: a.application_id
2235: FROM FND_HISTOGRAM_COLS a,
2236: FND_ORACLE_USERID b ,
2237: FND_PRODUCT_INSTALLATIONS c
2238: WHERE
2239: (
2240: b.oracle_username= upper(ownname)
2600: WHERE table_name = upper(tabname)
2601: AND owner =
2602: ( SELECT b.oracle_username
2603: FROM fnd_product_installations a,
2604: fnd_oracle_userid b
2605: WHERE a.application_id = appl_id
2606: AND b.oracle_id = a.oracle_id
2607: );
2608:
2677: BEGIN
2678: SELECT DISTINCT('EXIST')
2679: INTO exist_flag
2680: FROM dba_tab_columns a ,
2681: fnd_oracle_userid b,
2682: fnd_product_installations c
2683: WHERE a.table_name = upper(tabname)
2684: AND a.column_name = upper(colname)
2685: AND c.application_id = appl_id
3637:
3638: /*cursor all_histograms(schema varchar2, tableName varchar2) is
3639: select a.column_name
3640: from fnd_histogram_cols a,
3641: fnd_oracle_userid b,
3642: fnd_product_installations c
3643: where a.application_id = c.application_id
3644: and c.oracle_id = b.oracle_id
3645: and b.oracle_username = schema