Thursday, December 09, 2010

nfs volumes on Linux


-         Set the mount options explictly. Here are the mount options that need to be used for nfs volumes on Linux.

Use : rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

default rsize and wsize for NFS is 4096 Blocks so if you have rsize=32k and wsize=32k then NFS would be able to read and write large datagram as compared to deafult one TCP option will make sure that your client are getting the data or not Hard & INTR - The program accessing a file on a NFS mounted file system will hang when the server crashes. The process cannot be interrupted or killed unless you also specify intr. When the NFS server is back online the program will continue undisturbed from where it was. actimeo is for access timeout and it should be 0 .
Hope this Helps!. Rupam

Monday, December 06, 2010

Table lock in Oracle


Explanation

Dropping or truncating a table requires you to acquire an exclusive lock on the table. A table is a "busy" resource if there are other sessions modifying or holding a lock on the same table.

Wednesday, November 24, 2010

Generate tkprof output the 10046 trace files using following syntax


 # (change the file name, username & password):

    tkprof sys=no explain=/
   
    tkprof ${1} ${1}.log sys=no explain=sysadm/wdutsrff \
    waits=yes \
    sort=exeqry,fchqry,prsqry
    sort=exeela,exeqry,fchela,fchqry,prsela,prsqry
    sort=exeela,fchela,prsela

Hope this helps. Regards Rupam

10046 Trace a Session sid and serial #


Step 1
Get sid and serial #

Step 2
Start trace
sqlplus as sysdba
exec sys.dbms_system.set_ev(130, 54378, 10046, 12, '');  # where (sid=130 and serial#=54378)

Step 3
end trace

exec sys.dbms_system.set_ev(130, 54378, 10046, 0, '');
Hope this helps. Regards Rupam

oradebug 10053 using pid


How to Trace SQL Using oradebug

To collect the event 10053 trace file, the following syntax was used in SQLPlus:

step 1
get pid

step 2
SQL> connect / as sysdba
SQL> oradebug setmypid
SQL> oradebug unlimit
SQL> oradebug event 10053 trace name context forever, level 1
SQL> ...enter your query here...
SQL> oradebug event 10053 trace name context off
SQL> oradebug tracefile_name
Top of Form
Hope this helps. Regards Rupam