DBA Data[Home] [Help]

APPS.HZ_DQM_DIAGNOSTICS_XML dependencies on DBA_TABLES

Line 602: FROM sys.dba_tables

598: l_size NUMBER;
599:
600: CURSOR c_number_of_blocks(t_name varchar2, l_own1 varchar2) is
601: SELECT blocks - empty_blocks
602: FROM sys.dba_tables
603: WHERE table_name = t_name and owner = l_own1;
604: CURSOR c_db_block_size is SELECT value
605: FROM v$parameter
606: WHERE name = 'db_block_size' ;