I have SQL_ID for particular sql query and i need to know how to purge this sql_id from shared pool? Thanks
Oraask Latest Questions
Question
Question
There are three status or stats i know generally (Free & Pinned & Dirty) but not in dept and what is the difference between them all. i will really appreciated if some one briefly clarify this to me. thanks in advance.
Question
I heard this term once before, but i ave confused about the term it self what exactly the dirty block in oracle database ? and those blocks are they cleaned and converted to be dirty at some point? thanks.
Question
How to Create the TKPROF Trace File in oracle ?
Question
How to check Archive log sequence in Oracle DB 11g?
Question
How to kill current session in Oracle (ORA-00027 ) ?
Question