GitHub - soliverr/oracle-tpt: Tanel Poder's Oracle Troubleshooting Scripts

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 40 Commits
README		README
aas.sql		aas.sql
bhla.sql		bhla.sql
d.sql		d.sql
dbid.sql		dbid.sql
ddl.sql		ddl.sql
desc.sql		desc.sql
descx.sql		descx.sql
descx2.sql		descx2.sql
descxx.sql		descxx.sql
descxx2.sql		descxx2.sql
df.sql		df.sql
dir.sql		dir.sql
dirs.sql		dirs.sql
disco.sql		disco.sql
dist.sql		dist.sql
du.sql		du.sql
du2.sql		du2.sql
du_tmp.sql		du_tmp.sql
dump.sql		dump.sql
dumptrc.sql		dumptrc.sql
dumpvar.sql		dumpvar.sql
e2d.sql		e2d.sql
ed.sql		ed.sql
el.sql		el.sql
eoff.sql		eoff.sql
eon.sql		eon.sql
ep.sql		ep.sql
es.sql		es.sql
et.sql		et.sql
ev.sql		ev.sql
evh.sql		evh.sql
evi.sql		evi.sql
evo.sql		evo.sql
hash.sql		hash.sql
html.sql		html.sql
html2.sql		html2.sql
html3.sql		html3.sql
html_.sql		html_.sql
html_settings.sql		html_settings.sql
htmloff.sql		htmloff.sql
htmlon.sql		htmlon.sql
htmlon_.sql		htmlon_.sql
htmlrun.sql		htmlrun.sql
htmlset.sql		htmlset.sql
htmlset2.sql		htmlset2.sql
i.sql		i.sql
i2h.sql		i2h.sql
ind.sql		ind.sql
ind2.sql		ind2.sql
kill.sql		kill.sql
ksmsp.sql		ksmsp.sql
l.sql		l.sql
la.sql		la.sql
latchprof.sql		latchprof.sql
latchprofx.sql		latchprofx.sql
lc.sql		lc.sql
ld.sql		ld.sql
lh.sql		lh.sql
lhp.sql		lhp.sql
lhpx.sql		lhpx.sql
lm.sql		lm.sql
ln.sql		ln.sql
loadset.sql		loadset.sql
login.sql		login.sql
login_format.sql		login_format.sql
login_init.sql		login_init.sql
login_outstanding_alerts.sql		login_outstanding_alerts.sql
ls.sql		ls.sql
nls.sql		nls.sql
nonshared.sql		nonshared.sql
nonshared2.sql		nonshared2.sql
o.sql		o.sql
o2.sql		o2.sql
s.sql		s.sql
s_pid.sql		s_pid.sql
saddr.sql		saddr.sql
saveset.sql		saveset.sql
sd.sql		sd.sql
seg.sql		seg.sql
seg2.sql		seg2.sql
segeof.sql		segeof.sql
segext.sql		segext.sql
segext2.sql		segext2.sql
segstat.sql		segstat.sql
segstat2.sql		segstat2.sql
segstatint.sql		segstatint.sql
sesopt.sql		sesopt.sql
sga.sql		sga.sql
sgai.sql		sgai.sql
sgares.sql		sgares.sql
sgastat.sql		sgastat.sql
sgastatx.sql		sgastatx.sql
sgav.sql		sgav.sql
sid.sql		sid.sql
sl.sql		sl.sql
sleep.sql		sleep.sql
sm.sql		sm.sql
smem.sql		smem.sql
smem_detail.sql		smem_detail.sql

Repository files navigation

Tanel's Oracle Troubleshooting Scripts
--------------------------------------

Here is scripts and tools used at Tanel's Oracle Troubleshooting seminars
 from  http://tech.e2sn.com/oracle-scripts-and-tools/

See also Tanel Poder's blog 
 http://blog.tanelpoder.com/2011/03/24/an-index-of-my-tpt-scripts/

1. Create directories for temporary files:
   mkdir -p ~/tpt/tmp

2. Set up environment:
   TPT_HOME = ~/tpt
   TPT_TEMP = $TPT_HOME/tmp
   export TPT_HOME TPT_TEMP

3. Unarchive sql-scripts to apropriate directory:
   tar zxvf http://files.e2sn.com/scripts/tpt_public_unixmac.tar.gz -C ~/tpt

4. Move executable script tpt_help.sh somewhere in you PATH
   cp ~/tpt/tpt_help ~/bin/tpt_help
   chmod +x ~/bin/tpt_help

5. Create you own $HOME/login.sql file:
   @tpt/login.sql
   --
   -- you can put your own login scripts here 
   --

6. Using sripts

   Now you can use scripts from Oracle SQL*Plus:

   username@servername:~$ sqlplus /nolog

   Copyright (c) 1982, 2005, Oracle.  All rights reserved.

   SQL> conn db_user/db_pwd@db

   Connected to:
   Oracle Database 10g Release ...

   SQL> @tpt/i

   USERNAME   INST_NAME    HOST_NAME    SID   SERIAL#  VERSION    STARTED  SPID     OPID  CPID     SADDR            PADDR
   ---------- ------------ ------------ ----- -------- ---------- -------- -------- ----- -------- ---------------- ----------------
   SYS        test         test.loc     1111  35813    10.2.0.2.0 20160819 7370     21    8986     0000000212C162B0 0000000217B3FA10

   SQL> !tpt_help [ --list | script_name ]
           --list      - list all available scripts with short descriptions
           script_name - get help for specific script

7. Project Home

   Project is hosted on GitHub https://github.com/soliverr/oracle-tpt
   and mirrored on SourceForge: http://sourceforge.net/projects/oracledba


  -- Sergey Kryazhevskikh <[email protected]>