Visits

2992 (since Aug 23, 2008)

Personal

V$SQL_HINT

By Vishal Gupta, on May 2nd, 2009 | Category: Oracle | Leave a comment

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

Log File Write And Waits

By Vishal Gupta, on December 2nd, 2008 | Category: Oracle | Leave a comment

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

Slow Statspack Snapshots

By Vishal Gupta, on October 10th, 2008 | Tags: , | Category: Performance, Statspack | 2 comments

 

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

Loading File into a Blob

By Vishal Gupta, on September 23rd, 2008 | Category: Oracle | 4 comments

 

 

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

Slow drop user

By Vishal Gupta, on August 24th, 2008 | Tags: | Category: Oracle | 4 comments

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

My first post

By Vishal Gupta, on August 23rd, 2008 | Category: General | 3 comments

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.