I haven’t written a non-Oracle post into my blog yet, so here’s one for you :)
I recently developed a little web service with a friend. Shortly, check out http://n.otepad.com and any feedback is appreciated (especially about the parts which suck, so we could improve those :)
The longer story is that for years I used to [...]
In recent past I’ve blogged few scripts which use specially crafted ordered nested loop for sampling contents of V$ and X$ views fast, with plain SQL.
If you haven’t read them yet, here are the links:
WaitProf
LatchProf
LatchProfX
I wrote the above scripts having special purposes in mind (e.g. profile session waits or latching activity).
Now I introduce a simple [...]
I will speak at four more conferences this year, so if you like what I’m offering at this blog, you can get more at these conferences. Also it’s a chance to meet up and match the names with faces :)
21-25 September, Oracle OpenWorld 2008 in San Francisco
I’ll be presenting my 1-hour Advanced Oracle Troubleshooting guide
22-24 [...]
I got a question regarding Metalink note 296235.1 about a describe bug which causes objects to “disappear” when they are described when database is not open.
It was an interesting case involving a bug, so I wrote a quite long analysis with test cases today. However when posting the entry to wordpress, it managed to completely [...]
I just replied to an Oracle Forum Thread about why does even a small difference in SQL statement text cause it to be hard parsed and loaded as a different cursor. The reason is actually very simple - and I’m posting it into my blog too:
–
The reason why a statement with even a minor difference [...]
I wrote a little script pvalid.sql for listing valid values for multioption parameters (the ones which are not string, number or boolean type, but accept a parameter from predetermined list, like optimizer_mode which can have values of ALL_ROWS, FIRST_ROWS, CHOOSE, FIRST_ROWS_1, etc).
The script accepts a (part of) Oracle parameter name as first argument, for example [...]
When someone asks you to take a quick look into database performance and for whatever reason you can’t run your usual scripts or performance tools on there, ), then what query would you run first?
Yeah sometimes I’ve been not allowed to run custom scripts nor even touch the keyboard due security policies in effect.
Whenever you’re [...]
If you like the stuff in my blog or my conference sessions, you will sure like my seminar :)
I’m happy to announce the dates of my first public Advanced Oracle Troubleshooting seminars:
Vienna, Austria
03.-04. November 2008
Düsseldorf, Germany
06.-07. November 2008
Munich, Switzerland
10.-11. November 2008
Zurich, Switzerland
13.-14. November 2008
The above four seminars are organized by Trivadis
Vilnius, Lithuania
18.-19. November 2008
Riga, Latvia
20.-21. November 2008 [...]
In Oracle 11g even more library cache operations have been changed to use KGX mutexes instead of latches.
In Oracle 10.2.0.2+ the library cache pin latch usage was replaced with mutexes whenever _kks_use_mutex_pin was true, also few other things like V$SQLSTATS arrays and parent cursor examination were protected by mutexes. However the traversing of library [...]
RSS
Email
