TPack
TPack is my personal library which I use for analyzing Oracle peformance problems.
You can get more informations on TPack site.
Dion Cho – Oracle Performance Storyteller
We are natural born scientists
Pages
10053 trace all_rows AWR bind value block class callstack colored sql commit copy_table_stats cursor expression dba_hist_sqlstat dbms_avanced_rewrite dbms_job dbms_rls dbms_spm dbms_sqltune dbms_stats dbms_workload_repository dbms_xplan db_file_multiblock_read_count DDL trigger delayed block cleanout dependency diff dynamic sampling end to end tracing errorstack execution plan external table fast commit first_rows full table scan function based index gc buffer busy gc current request hard parse hash join right join index full scan inline INVALID_UNAUTH keep buffer pool library cache latch lock escalation materialize mismatch object_status ORA-4030 OR predicate Parallel Execution parallel query parallel slaves parameter3 plan statistics right join runstats serial direct path read session cursor caching sql*trace sql profile sql_trace stored outline subquery factoring swap_join_inputs TCF tkprof transformation v$pq_tqstat v$sql v$sql_shared_cursor view merging windows oerr _db_file_exec_read_count _db_file_optimizer_read_count _optimizer_rownum_pred_based_fkr _with_subqueryCategories
Recent Posts
- Interesting case of the restriction of global hints
- Interpreting Parallel MERGE Statement
- Making self deadlock on the library cache pin
- Batching NLJ optimization and ordering
- _gby_hash_aggregation_enabled bug
Recent Comments
Archives
Blogroll
- Exem
- H.Tonguç Yılmaz
- Jonathan Lewis
- My Blog in Japanese(Draft)
- My Blog in Korean
- Randolf Geist
- Richard Foote
- Tanel Poder
Top Posts
- The secret of session_cached_cursors
- Interpreting Parallel MERGE Statement
- Batching NLJ optimization and ordering
- Oracle Ace
- When do we have SQL*Net message from dblink wait events?
Top Clicks
My Books
Blog Stats
- 563,380 hits
Dion Cho - Oracle Performance Storyteller 
[…] TPack‘s Wait Detail Report gives more detailed information on the deadlocked library cache pin contention. […]
Making self deadlock on the library cache pin « Dion Cho – Oracle Performance Storyteller
September 16, 2010 at 2:07 am