Blogs about: Internals
Featured Blog
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
In my last AOT post I published my LatchProf script which is able to sample detailed latchholder data from V$LATCHHOLDER. Latchprof allows you to drill down into your latching problems at session leve… more »
Tanel Poder's blog: Core IT for geeks and pros
Advanced Oracle Troubleshooting Guide, Part 8: Even more detailed latch troubleshooting using LatchProfX
— 1 comment
tanelp wrote 3 days ago: In my last AOT post I published my LatchProf script which is able to sample detailed latchholder dat … more »
Indices e Estatisticas
agleite wrote 1 week ago: O ponto a discutir neste post, é como o Oracle avalia blocos de indices vazios, no cálculo de esta … more »
Closed database and WITH subquery
— 8 comments
tanelp wrote 1 week ago: Here’s an interesting issue I found when running a query using WITH subquery factoring when da … more »
Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf
— 2 comments
tanelp wrote 2 weeks ago: I have been too busy since getting back from vacation, thus no posts for a while. But I hope the wai … more »
Another use case for WaitProf - diagnosing "events in waitclass Other"
— 3 comments
tanelp wrote 1 month ago: I recently diagnosed a performance issue where the “events in waitclass Other” occasiona … more »
Killing an Oracle process from inside Oracle
— 6 comments
tanelp wrote 1 month ago: I had a following situation few days ago - I was running a CREATE TABLE AS SELECT over a heterogenou … more »
cursor_space_for_time To Be Deprecated
— 5 comments
tanelp wrote 1 month ago: If you haven’t seen the Meatlink note 565424.1 in the news yet, cursor_space_for_time paramete … more »
Advanced Oracle Troubleshooting Guide, Part 6: Understanding Oracle execution plans with os_explain
— 4 comments
tanelp wrote 1 month ago: Get ready for some more adventures in Oracle process stack! Before proceeding though, please read th … more »
Short note on KGX Mutexes
— 3 comments
tanelp wrote 1 month ago: I received a question on what’s the point of the use of Mutexes for Oracle cursors in library … more »
Sun Microsystem Member Technical Staff Walk-in 30th June 2008 at Bangalore
— 2 comments
govjobs wrote 1 month ago: Experience:0 Yrs, Location: Bangalore, Education: B.E/B.Tech/M.Tech/MCA Job Title : Member Technical … more »
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!
— 16 comments
tanelp wrote 1 month ago: I bet you thought I’ll be writing about direct SGA access?! Nope! Direct SGA access has excel … more »
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue
— 1 comment
tanelp wrote 1 month ago: There was a recent thread in Oracle Forums about a session getting stuck somewhere when a specific S … more »
Performance and Scalalability Improvements in Oracle 10g and 11g
— 2 comments
tanelp wrote 2 months ago: I have uploaded the slides of my “Performance and Scalalability Improvements in Oracle 10g and … more »
Using autonomous transactions for sleeping
— 9 comments
tanelp wrote 2 months ago: There was a question in a recent Oracle-L thread about various uses of autonomous transactions. Auto … more »
Been a while
Manoj Sterex wrote 2 months ago: Its over a fortnight since I posted anything on my blog. Just that my ideas don’t get transla … more »
how does Garbage collection works?
ramsonit wrote 3 months ago: Tess has posted a great informative article on this blog about how does Garbage collection works. Mu … more »
prologue
noteblogger wrote 3 months ago: This blog will be for notes according to some of my pc related projects. The next things i’m g … more »
SQL*Net break/reset to client
— 9 comments
tanelp wrote 3 months ago: There was a question in Oracle-L mailinglist recently, regarding excessive SQL*Net break/reset to cl … more »
SunLine Racing S15
Leon wrote 3 months ago: This tidy S15 is one of the demo cars of the Japan’s SunLine racing; not exactly a tuning hous … more »
Have your say. Start a blog.
See our free features »
An 
Ruckus
