Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

h8dk97 : member's tip(s)


   Found 163 tips, Displaying 151 - 160 
 
Sort by 
 
 Print system diagnostic information
$ prtdiag
 More...
10/03/05
 
 
Category : Operating Systems > Unix > SUN Solaris
 
 
 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
 
 
Category : Databases > Oracle > Performance Tuning
 
 
 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
 
 
Category : Databases > Oracle > Performance Tuning
 
 
 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
 
 
Category : Databases > Oracle > Performance Tuning
 
 
 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
 
 
Category : Databases > Oracle > exp
 
 
 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
 
 
Category : Databases > Oracle
 
 
 Display long text fields in query results
set long [size] - or - set longchunksize [size] Enables to select long text fields (chunks are lines separated by end of line, so it will display them as one line)
     
More...

10/03/05
 
 
Category : Databases > Oracle > SQLPLUS
 
 
 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
 
 
Category : Databases > Oracle > Oracle 10g
 
 
 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
 
 
Category : Internet > Web Design > CSS
 
 
 Datafiles created during RMAN backup cause problems when restoring database
If a new file(s) was created during RMAN backup there will be problems with restore (I had this problem with Oracle 8.1.7.x where 'set until time' in the restore script did not help. Not sure if it's been fixed in later versions). To overcome this register database in a test ...
 More...
09/23/05
 
 
Category : Databases > Oracle > Oracle 8i
 
 


<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Page 16 | 17 >>

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com