|
| | Example of how to trace a session and use tkprof
Enable trace for a user session:
SQLPLUS> exec sys.dbms_system.set_sql_trace_in_session(SID, SERIAL, true);
Use tkprof to analyze the trace file:
tkprof [TRACE FILE] [OUTPUT FILE] explain=/ sort=prsela,exeela,fchela table=ops\$oracle.plan_table
| |  
More...
10/03/05 | | | | | | | | |
|
| | Script to detect TX blocking locks
Following script detects TX blocking looks:
set linesize 160
set trimspool on
column name format A28
column type format A18
column sid format 9999
column block format 99
column ctime format 99999
column serial format 99999
column id1 format 99999999
column id2 format 99999999
column LMODE format A12
column request format A12
spool log.lock
select /*+ ordered use_merge(X$KSUSE X$KSQEQ) */
l.ctime ... | | More...
10/03/05 | | | | | | | | |
|
| | View sorts per user session
Run this query to see sorts per user session. Replace BLOCKSIZE with block size for your database i.e. if it's 8Kb replace it with 8192
SELECT s.username
,s.sid
,s.serial#
,u.SESSION_ADDR ... | | More...
10/03/05 | | | | | | | | |
|
| | Compress during export
Example of exporting via a named pipe:
$ /sbin/mknod /tmp/compress_pipe p
$ gzip -c < /tmp/compress_pipe >/opt/ora/export/SID/test_SID_via_pipe.dmp.gz &
$ exp [username]/[password]@[database] full=y file=/tmp/compress_pipe
| | More...
10/03/05 | | | | | | | | |
|
| | Kill user session
Use this procedure to find and kill a user's session:
SQLPLUS> select sid, serial# from v$session where username = 'USER';
SQLPLUS> alter system kill session 'SID,SERIAL#';
| | 
More...
10/03/05 | | | | | | | | |
|
|
| | List patches applied to Oracle installation
This is the Oracle 10 utility to list all the patches applied to $ORACLE_HOME:
$ORACLE_HOME/OPatch/opatch lsinventory
The output should look something like this:
Result:
Installed Patch List:
=====================
1) Patch 4291110 applied on Fri Sep 30 12:28:18 EST 2005
[ Base Bug(s): 4291110 ... | | More...
10/03/05 | | | | | | | | |
|
| | How to change HTML form margins using CSS
Sometimes you don't want to keep the default form margins. Use CSS to change form margines i.e. set to zero:
form {
margin-bottom: 0;
margin-top: 0;
margin-right: 0;
margin-left: 0;
}
| | More...
09/27/05 | | | | | | | | |
|
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Page 16 | 17 >>
|
