OPTIMIZER_MODE = FIRST_ROWS_N
(Andrew Reid) I have known about the first_rows optimizer mode for some time. This tells Oracle to use an execution path which will return the first few rows as quickly as possible. However, I recentl...
(Bane Radulovic) The REQUIRED_MIRROR_FREE_MB and the USABLE_FILE_MB are two very interesting columns in the V$ASM_DISKGROUP[_STAT] view. Oracle Support gets many questions about the meaning of those c...
Oracle TKPROF Hidden/Undocumented Parameters
(Gokhan Atil) While I was examining with tkprof, I noticed that there are 2 undocumented parameters (Oracle 11gR2): verbose and diag. Let’s take a look at them. ...
Oracle Bloom Filters
(David Fitzjarrell) In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. What is a B...
PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME
(Andrew Reid) I tested this on Oracle 11.2. I created a profile called FOR_ANDREW with PASSWORD_REUSE_MAX set to 1. This meant that I could not reuse a password until I had used one other password fir...
Oracle DIP filtering
(Frank) In the course of a major redesign of AD Domains at the site I work for, the question arose how to select only those users, which completely migrated to the consolidated domain....
Today I am catching up on my backlog of reader response emails for various topics.
Mark – Traits of a Good Software Developer
I think your point about passion is key. ...
SQL> Select * From Alert_XML;
(Harry Dragstra) By mapping an external table to some text file, you can view the file contents as if it were
data in a database table. External tables are available since Oracle 9i Database, and fr...