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 904: FROM dba_indexes

900:
901: SELECT 'INDEX' type,
902: owner ,
903: index_name name
904: FROM dba_indexes
905: WHERE
906: (
907: table_owner=upper(schemaname)
908: OR owner =upper(schemaname)

Line 1021: FROM dba_indexes

1017:
1018: SELECT 'INDEX' type,
1019: owner ,
1020: index_name name
1021: FROM dba_indexes
1022: WHERE
1023: (
1024: table_owner=upper(schemaname)
1025: OR owner =upper(schemaname)

Line 1801: FROM dba_indexes di

1797:
1798: SELECT DISTINCT 'TABLE' type ,
1799: table_owner owner,
1800: table_name name
1801: FROM dba_indexes di
1802: WHERE
1803: (
1804: di.table_owner=upper(schemaname)
1805: OR di.owner =upper(schemaname)

Line 1928: FROM dba_indexes

1924:
1925: SELECT 'INDEX' type,
1926: owner ,
1927: index_name name
1928: FROM dba_indexes
1929: WHERE
1930: (
1931: table_owner=upper(schemaname)
1932: OR owner =upper(schemaname)

Line 2727: FROM dba_indexes a

2723: IS
2724: SELECT a.index_name indname,
2725: a.owner indowner ,
2726: a.uniqueness uniq
2727: FROM dba_indexes a
2728: WHERE table_name = upper(tabname)
2729: AND table_owner= upper(ownname)
2730: ORDER BY index_name;
2731: -- New cursor for 11g extended stats

Line 3501: FROM dba_indexes

3497: */
3498: /* added to fix bug 2239903 */
3499: SELECT DECODE(index_type,'IOT - TOP', 'TRUE', 'FALSE')
3500: INTO l_iot
3501: FROM dba_indexes
3502: WHERE owner = ownname
3503: AND index_name = indname;
3504:
3505: IF (l_iot = 'TRUE') THEN

Line 3882: dba_indexes b

3878: SELECT DISTINCT column_name col ,
3879: b.table_name tab,
3880: b.table_owner own
3881: FROM dba_ind_columns a,
3882: dba_indexes b
3883: WHERE b.table_owner = upper(SUBSTR(tname,1,instr(tname,'.')-1))
3884: AND
3885: (
3886: b.table_name = upper(SUBSTR(tname,instr(tname,'.')+1))

Line 4352: last_analyzed dba_indexes.last_analyzed%type;

4348: /************************************************************************/
4349: PROCEDURE index_stats(lowner VARCHAR2,
4350: indexName VARCHAR2)
4351: IS
4352: last_analyzed dba_indexes.last_analyzed%type;
4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;

Line 4353: num_rows dba_indexes.num_rows%type;

4349: PROCEDURE index_stats(lowner VARCHAR2,
4350: indexName VARCHAR2)
4351: IS
4352: last_analyzed dba_indexes.last_analyzed%type;
4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;

Line 4354: leaf_blocks dba_indexes.leaf_blocks%type;

4350: indexName VARCHAR2)
4351: IS
4352: last_analyzed dba_indexes.last_analyzed%type;
4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;

Line 4355: distinct_keys dba_indexes.distinct_keys%type;

4351: IS
4352: last_analyzed dba_indexes.last_analyzed%type;
4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;
4359: uniqueness dba_indexes.uniqueness%type;

Line 4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;

4352: last_analyzed dba_indexes.last_analyzed%type;
4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;
4359: uniqueness dba_indexes.uniqueness%type;
4360: val1 VARCHAR2(255);

Line 4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;

4353: num_rows dba_indexes.num_rows%type;
4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;
4359: uniqueness dba_indexes.uniqueness%type;
4360: val1 VARCHAR2(255);
4361: val2 VARCHAR2(255);

Line 4358: clustering_factor dba_indexes.clustering_factor%type;

4354: leaf_blocks dba_indexes.leaf_blocks%type;
4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;
4359: uniqueness dba_indexes.uniqueness%type;
4360: val1 VARCHAR2(255);
4361: val2 VARCHAR2(255);
4362: val3 VARCHAR2(255);

Line 4359: uniqueness dba_indexes.uniqueness%type;

4355: distinct_keys dba_indexes.distinct_keys%type;
4356: avg_leaf_blocks_per_key dba_indexes.avg_leaf_blocks_per_key%type;
4357: avg_data_blocks_per_key dba_indexes.avg_data_blocks_per_key%type;
4358: clustering_factor dba_indexes.clustering_factor%type;
4359: uniqueness dba_indexes.uniqueness%type;
4360: val1 VARCHAR2(255);
4361: val2 VARCHAR2(255);
4362: val3 VARCHAR2(255);
4363: val4 VARCHAR2(255);

Line 4381: FROM dba_indexes

4377: avg_leaf_blocks_per_key,
4378: avg_data_blocks_per_key,
4379: clustering_factor ,
4380: uniqueness
4381: FROM dba_indexes
4382: WHERE owner = lowner
4383: AND index_name = indexName;
4384:
4385: val1:= rpad(indexname, 30, ' ')

Line 4744: FROM dba_indexes

4740: CURSOR all_indexes(schema VARCHAR2, tableName VARCHAR2)
4741: IS
4742: SELECT index_name,
4743: owner
4744: FROM dba_indexes
4745: WHERE table_owner = schema
4746: AND table_name = tableName
4747: ORDER BY index_name;
4748: