How to get trace file from getbfno.sql gettrcname.sql
来源:互联网 发布:java 字符串查找 编辑:程序博客网 时间:2024/06/10 18:56
根据块rdba地址,找到文件号,块号.
getbfno.sql
CREATE OR REPLACE FUNCTION getbfno (p_dba IN VARCHAR2) RETURN VARCHAR2IS l_str VARCHAR2 (255) DEFAULT NULL; l_fno VARCHAR2 (15); l_bno VARCHAR2 (15);BEGIN l_fno := DBMS_UTILITY.data_block_address_file (TO_NUMBER (LTRIM (p_dba, '0x'), 'xxxxxxxx' ) ); l_bno := DBMS_UTILITY.data_block_address_block (TO_NUMBER (LTRIM (p_dba, '0x'), 'xxxxxxxx' ) ); l_str := 'datafile# is:' || l_fno || CHR (10) || 'datablock is:' || l_bno || CHR (10) || 'dump command:alter system dump datafile ' || l_fno || ' block ' || l_bno || ';'; RETURN l_str;END;/
引自http://www.eygle.com/archives/2007/07/function_rdba_convert.html
gettrcname.sql
SELECT a.VALUE || b.symbol || c.instance_name || '_ora_' || d.spid || '.trc' trace_file FROM (SELECT VALUE FROM v$parameter WHERE NAME = 'user_dump_dest') a, (SELECT SUBSTR (VALUE, -6, 1) symbol FROM v$parameter WHERE NAME = 'user_dump_dest') b, (SELECT instance_name FROM v$instance) c, (SELECT spid FROM v$session s, v$process p, v$mystat m WHERE s.paddr = p.addr AND s.SID = m.SID AND m.statistic# = 0) d;
引自http://www.eygle.com/archives/2007/05/script_gettrcname.html
- How to get trace file from getbfno.sql gettrcname.sql
- To get SQL Trace
- how to make&get trace file
- How to get file from classpath
- 转载-gettrcname.sql
- How to Generate SQL Trace In OAF
- How to Find the Offending SQL from a ORA-600 or ORA-7445 Trace File (文档 ID 154170.1)转到底部 In this
- How To Use TKPROF To Trace And Analyze Sql Explan
- SQL TRACE File Locations
- How to get file extension from string in C++
- [cernRoot]How to get tree name from root file
- How to read a SQL Trace in PeopleSoft
- How to Use Oradebug to Get Trace File Name and Location
- How To Load CLOB Data from a File into a CLOB column using PL/SQL
- How to get SQL server 2016
- How to use SQL store procedure to trace SQL performance instead of SQL profiler
- How to transfer the data from CSV file to Oracle database use the PL/SQL developer tool
- How to make a random selection from an SQL table
- Oracle IN & EXISTS
- Oracle cursor
- ThinkPHP的调用css,js和图片的路径
- Oracle Block Extent Segment Tablespace
- ORA-19588: archived log recid 181834 stamp 780173554 is no longer valid
- How to get trace file from getbfno.sql gettrcname.sql
- JAVA Socket超时浅析
- Oracle ASM - 条带化
- Oracle Transport Tablespace by RMAN
- Oracle 10g managing asm disk and diskgroup
- Oracle Transport Tablespace
- How to calculate a session redolog bytes from get_stat_val
- Linux input variable parameter
- Oracle dba_tables tablespace_name is null