Step-1 : Find the Query and its SQL_ID to trace from AWR reports. Step-2 : Execute following query to find real execution plan: SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position) “Query Plan” FROM v$sql_plan START WITH id = 0 and sql_id=’8ska10yfjx4b5′ CONNECT BY PRIOR id = parent_id and sql_id=’8ska10yfjx4b5′;…
SELECT owner, name, type FROM v$db_object_cache WHERE kept = ‘YES’ AND TYPE = ‘CURSOR’;
http://www.cedet.dk/perl/ #!c:perlbinperl use DBI; # Following line is necessary of you are using perl to write html in browser. print “Content-type: text/htmlnn”; print ““; print “CGI Test“; print ““; print “Newer Verion of File Management Operations !“; my $dbname = “pvmeh”; ## DB Name from tnsnames.ora my $user = “pvmeh”; my $passwd = “pvmeh”; print…
This is the script used for merging multiple text files in single large text(ASCII) file. for i in `ls *sql *sh` { echo “****************************************************” >> myfile echo File Name : $i >> myfile echo “****************************************************” >> myfile cat $i >> myfile echo ” ” >> myfile }
13:01:01 SYS@AWRTEST:-> select lebsz from x$kccle; LEBSZ ——— 512 512 512 3 rows selected. or df -g on unix prompt.
Oracle Identifiers: =================== In order not to make using Oracle confusing, there are some identifiers whose meaning must be totally clear if one want to work on Oracle: SID (System Identifier): ======================== A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less;…
To obtain the shared memory id and semaphore id for 8.1.X you can do either of the following: $ORACLE_HOME/bin/sysresv IPC Resources for ORACLE_SID “V817” : Shared Memory: ID KEY 14851 0x8a85a74c Semaphores: ID KEY 11206656 0x4bd4814c Oracle Instance alive for sid “V817” OR %sqlplus internal SQL> oradebug ipc Information written to trace file. Trace file…
Read More “DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS” »
copying/removing directory with all its subdirectory use -r flag for recursive copy (cp) or remove (rm). use -f flag for forcefully. I used “rm -fr dir_name” and “cp -r src_dir dest_dir”.
SQL> variable komal number SQL> begin 2 :komal := add_me(45,12); 3 end; 4 / PL/SQL procedure successfully completed. SQL> print komal KOMAL ———- 57 SQL> variable tejal number; SQL> execute :tejal := add_me(10,20) PL/SQL procedure successfully completed. SQL> print tejal TEJAL ———- 30 SQL>
How to execute any DML statement in Parallel mode?? (1) ALTER SESSION ENABLE PARALLEL DML; (2) Apply Parallel(table_name, parallel_degree) in hint. You can see three new clumns (TQ, IN-OUT, PQ Distribut) in execution plan of “select * from table(dbms_xplan.display())”. These new columns will specify the query is running in parallel mode.
