What is Latch Free Event? When will you encounter this type of event? How will you solve it?
Latest Answer: The latch free Oracle metric occurs when the process is waiting for a latch held by another process (this wait event does not apply to processes that are spinning while waiting for a latch; when a process is spinning, it is not waiting).If you experience ...
Latest Answer: It's just an overview of the query which tell us how this query is going to perform. But it's not actual. In most cases it's actual but it may be changed while at run time due to some factors.People, who says to watch cost for explain plan ...
Latest Answer: 'Performance tuning' is the term used to improve the performance of a query..that is, quickening the query execution time...a query that involves a large no of db tables may take around 20-30 min to execute for ex...In such case, the developer ...
