57 lines
3.1 KiB
SQL
57 lines
3.1 KiB
SQL
--
|
|
-- Tanel Poder's Troubleshooting scripts for Oracle v2.0.1
|
|
--
|
|
-- Copyright: (c) 2004-2009 http://www.tanelpoder.com
|
|
--
|
|
-- None of the TPT scripts change or alter the database by design,
|
|
-- nevertheless use those scripts at your own risk. Always make
|
|
-- sure you know what the script is doing by reviewing its contents
|
|
-- before running it!
|
|
--
|
|
--
|
|
-- Get more information on Oracle internals, tuning and troubleshooting
|
|
-- from [ http://www.tanelpoder.com ]
|
|
|
|
COL help_content HEAD DESCRIPTION FOR A100
|
|
COL help_script_name HEAD NAME FOR A12
|
|
|
|
WITH sq AS (
|
|
SELECT 1 id, 'i' topic, '' parameters, 'Session info' title, '"who am i" script for Oracle. Also sets Window title' content FROM dual UNION ALL
|
|
SELECT 1 id, 'ii' topic, 'More session info' parameters, '' title, 'Lists some session info in decimal and hex' content FROM dual UNION ALL
|
|
SELECT 1 id, 'source' topic, '<owner> <object> <text>' parameters, 'List PL/SQL source' title, 'Lists PL/SQL source code from DBA_SOURCE' content FROM dual UNION ALL
|
|
SELECT 1 id, 'ash' topic, 'ASH query' parameters, '@ash event,p1 "event like ''latch%''" -5m now' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
--SELECT 1 id, '' topic, '' parameters, '' title, '' content FROM dual UNION ALL
|
|
SELECT 1 id, 'dummy' topic, '' parameters, '' title, '' content FROM dual
|
|
)
|
|
SELECT
|
|
topic help_script_name
|
|
, parameters parameters
|
|
, title script_title
|
|
, content help_content
|
|
FROM
|
|
sq
|
|
WHERE
|
|
LOWER(topic) LIKE LOWER('&1')
|
|
OR LOWER(title) LIKE LOWER('&1')
|
|
OR LOWER('&1') = 'index'
|
|
/
|