0927

select sql_text from v$sqlarea where sql_text like '%select * from emp where empno%'

select * from emp where empno=7369

startup force

variable vaa number

print vaa

The data dictionary cache,terminology,and tuning

content:Definitions of dictionary objects

terminology:

gets:number of requests on objects

getmisses:number of requests resulting in cache misses

tuning:avoid dictionary cache misses