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_INDEXES

Line 882: FROM dba_indexes

878:
879: SELECT 'INDEX' type,
880: owner ,
881: index_name name
882: FROM dba_indexes
883: WHERE
884: (
885: table_owner=upper(schemaname)
886: OR owner =upper(schemaname)

Line 1360: FROM dba_indexes di

1356:
1357: SELECT DISTINCT 'TABLE' type ,
1358: table_owner owner,
1359: table_name name
1360: FROM dba_indexes di
1361: WHERE
1362: (
1363: di.table_owner=upper(schemaname)
1364: OR di.owner =upper(schemaname)

Line 1903: FROM dba_indexes a

1899: IS
1900: SELECT a.index_name indname,
1901: a.owner indowner ,
1902: a.uniqueness uniq
1903: FROM dba_indexes a
1904: WHERE table_name = upper(tabname)
1905: AND table_owner= upper(ownname)
1906: ORDER BY index_name;
1907:

Line 2548: FROM dba_indexes

2544: */
2545: /* added to fix bug 2239903 */
2546: SELECT DECODE(index_type,'IOT - TOP', 'TRUE', 'FALSE')
2547: INTO l_iot
2548: FROM dba_indexes
2549: WHERE owner = ownname
2550: AND index_name = indname;
2551:
2552: IF (l_iot = 'TRUE') THEN

Line 2929: dba_indexes b

2925: SELECT DISTINCT column_name col ,
2926: b.table_name tab,
2927: b.table_owner own
2928: FROM dba_ind_columns a,
2929: dba_indexes b
2930: WHERE b.table_owner = upper(SUBSTR(tname,1,instr(tname,'.')-1))
2931: AND
2932: (
2933: b.table_name = upper(SUBSTR(tname,instr(tname,'.')+1))

Line 3399: last_analyzed dba_indexes.last_analyzed%type;

3395: /************************************************************************/
3396: PROCEDURE index_stats(lowner VARCHAR2,
3397: indexName VARCHAR2)
3398: IS
3399: last_analyzed dba_indexes.last_analyzed%type;
3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;

Line 3400: num_rows dba_indexes.num_rows%type;

3396: PROCEDURE index_stats(lowner VARCHAR2,
3397: indexName VARCHAR2)
3398: IS
3399: last_analyzed dba_indexes.last_analyzed%type;
3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;

Line 3401: leaf_blocks dba_indexes.leaf_blocks%type;

3397: indexName VARCHAR2)
3398: IS
3399: last_analyzed dba_indexes.last_analyzed%type;
3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;

Line 3402: distinct_keys dba_indexes.distinct_keys%type;

3398: IS
3399: last_analyzed dba_indexes.last_analyzed%type;
3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;
3406: uniqueness dba_indexes.uniqueness%type;

Line 3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;

3399: last_analyzed dba_indexes.last_analyzed%type;
3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;
3406: uniqueness dba_indexes.uniqueness%type;
3407: val1 VARCHAR2(255);

Line 3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;

3400: num_rows dba_indexes.num_rows%type;
3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;
3406: uniqueness dba_indexes.uniqueness%type;
3407: val1 VARCHAR2(255);
3408: val2 VARCHAR2(255);

Line 3405: clustering_factor dba_indexes.clustering_factor%type;

3401: leaf_blocks dba_indexes.leaf_blocks%type;
3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;
3406: uniqueness dba_indexes.uniqueness%type;
3407: val1 VARCHAR2(255);
3408: val2 VARCHAR2(255);
3409: val3 VARCHAR2(255);

Line 3406: uniqueness dba_indexes.uniqueness%type;

3402: distinct_keys dba_indexes.distinct_keys%type;
3403: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
3404: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
3405: clustering_factor dba_indexes.clustering_factor%type;
3406: uniqueness dba_indexes.uniqueness%type;
3407: val1 VARCHAR2(255);
3408: val2 VARCHAR2(255);
3409: val3 VARCHAR2(255);
3410: val4 VARCHAR2(255);

Line 3428: FROM dba_indexes

3424: avg_leaf_blocks_per_key,
3425: avg_data_blocks_per_key,
3426: clustering_factor ,
3427: uniqueness
3428: FROM dba_indexes
3429: WHERE owner = lowner
3430: AND index_name = indexName;
3431:
3432: val1:= rpad(indexname, 30, ' ')

Line 3633: FROM dba_indexes

3629: CURSOR all_indexes(schema VARCHAR2, tableName VARCHAR2)
3630: IS
3631: SELECT index_name,
3632: owner
3633: FROM dba_indexes
3634: WHERE table_owner = schema
3635: AND table_name = tableName
3636: ORDER BY index_name;
3637: