By Vishal Gupta, on May 2nd, 2009 | Category:
Oracle |
In case you wanted to know which Oracle version a particular SQL hint is applicable in or was introduced in. You can query V$SQL_HINT introduced in 11g for that. It holds even historical information. Column “version” gives oracle version in which a particular hint was introduced and version_outline probably gives upto which version upto which
… Continue reading more
By Vishal Gupta, on December 2nd, 2008 | Category:
Oracle |
Here are some interesting articles regarding log file writing and associated I/O waits.
Jonanthan Lewis – Log File Write
Riyaj Shamsudeen – Log file sync tuning
Christian Bilien – Log file sync wait
By Vishal Gupta, on October 10th, 2008 | Tags:
Performance,
Statspack | Category:
Performance,
Statspack |
For quite some time we had been experiencing slow statspack snapshots, taking about 300sec. In a worst case scenario it took 7 hours. My colleague was investigating it, it turned out that on this particular database “_optimizer_ignore_hints”
… Continue reading more
By Vishal Gupta, on September 23rd, 2008 | Category:
Oracle |
Yesterday I received a request from a developer to load file into a BLOB. To be honest I have never loaded a file into a BLOB in past. I had some idea that I would have to use DBMS_LOB pl/sql
… Continue reading more
By Vishal Gupta, on August 24th, 2008 | Tags:
Oracle | Category:
Oracle |
For past 3 weeks i was covering for a project dedicated DBA who had gone on leave for 3 weeks (some people are just lucky). Its an Oracle Peoplesoft General Ledger application on Oracle 10.2.0.3 database. Lot of copies of application are hosted in same database as multiple copies for different stages of software lifecyle.
I
… Continue reading more
By Vishal Gupta, on August 23rd, 2008 | Category:
General |
Finally i managed to start my own blog. I had been thinking about starting my own blog on my website for some time. But somehow it never took off. I am pleased that its up and running….
Watch this space for some interesting oracle reading.