User talk:Wikiram

java tips

Oracle
explain plan set statement_id 'r' for select * from misc_load_excpt where trans_id in ( select trans_id from intrln_bch_dtl where DOC_NBR in (1818181818))

select operation, options, object_name, id, parent_id,

position

from plan_table where statement_id = 'r'

order by id The below one tells the CPU usage etc select * from plan_table

select lpad(' ', 2 * (LEVEL - 1))|| operation|| ' ' ||

options|| ' '|| object_name || ' ' ||decode(id, 0,

'Cost = '|| position)

"Execution Plan"

from plan_table

start with id = 0

and statement_id = 'r'

connect by prior id = parent_id

and statement_id = 'r'