Visits

4401 (since Aug 23, 2008)

Personal

Linux auto start/stop scripts

By Vishal Gupta, on May 17th, 2010, at 10:43 pm | Tags: , | Category: Oracle

Normally DBAs and SAs have a tendency to create the auto start/stop scripts like following.

# cat /etc/init.d/oracle

case $1 in
start)
/opt/oracle/product/11.1.0/bin/dbstart;
;;
stop)
/opt/oracle/product/11.1.0/bin/dbshut;
;;
esac

# ln -s /etc/init.d/Oracle /etc/rc.d/rc0.d/K01oracle
# ln -s /etc/init.d/Oracle /etc/rc.d/rc3.d/S99oracle
# ln -s /etc/init.d/Oracle /etc/rc.d/rc4.d/S99oracle
#

… Continue reading more

V$SQL_HINT

By Vishal Gupta, on May 2nd, 2009, at 8:17 pm | 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 it

… Continue reading more

Log File Write And Waits

By Vishal Gupta, on December 2nd, 2008, at 9:12 pm | 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

… Continue reading more

Slow Statspack Snapshots

By Vishal Gupta, on October 10th, 2008, at 4:24 pm | Tags: , | 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” was

… Continue reading more

Loading File into a Blob

By Vishal Gupta, on September 23rd, 2008, at 11:07 am | 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 package

… Continue reading more

Slow drop user

By Vishal Gupta, on August 24th, 2008, at 3:04 am | Tags: | 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 was

… Continue reading more