Explore >> Select a destination
|
You are here 
|
tanelpoder.com | ||
| | | | |
blog.tanelpoder.com
|
|
| | | | | Some years ago I wrote about how sqlplus allows you to run sqlplus scripts directly from HTTP and FTP locations instead of the local filesystem. By the way, I didn't even notice - my blog is over 5 years old already! :) I a recent email thread Marco Gralike just showed the simplest way I to open a HTTP URL and download + list its contents in a CLOB datatype. It's the HTTPURITYPE and its getCLOB (and getBLOB) methods. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | 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 level (which V$LATCH, V$LATCH_PARENT and V$LATCH_CHILDREN can't do). It allows you to get valuable details about individual sessions who are holding a latch the most, therefore likely contributing to the latch contention problem the most. However after you have discovered the troublemaking session, then what next? One way forward is looking into V$SESSTAT counters using Snapper tool. Depending on what latch is the problematic one, you would look for different stats like various buffer get stats for cache buffers chains latches and parsing/executing stats when looking into library cache latches. However if those stats look "normal", is there any other way do drill down further? Yeah, there is and lets look into it! - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | After Randolf's comment on my last post about identifying cursor SQL text from sql trace file I think one thing needs elaboration. I mentioned earlier in this post that this cursor dumping technique works "as long as the cursor of interest is still open". So how do you know whether this cursor of interest is still open or has been closed and that slot reused by some other statement instead? You would not want to get misled to wrong SQL statement... - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
timothymiller.dev
|
|
| | | My adventure in creating my own NAS on a budget. | ||
