30 lines
1.0 KiB
MySQL
30 lines
1.0 KiB
MySQL
|
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
||
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
||
|
|
|
||
|
|
--------------------------------------------------------------------------------
|
||
|
|
--
|
||
|
|
-- File name: demo5.sql
|
||
|
|
--
|
||
|
|
-- Purpose: Advanced Oracle Troubleshooting Seminar demo script
|
||
|
|
-- Causes a session hang by creating a pipe instead of a tracefile
|
||
|
|
-- and enabling tracing then
|
||
|
|
--
|
||
|
|
-- Author: Tanel Poder ( http://www.tanelpoder.com )
|
||
|
|
-- Copyright: (c) Tanel Poder
|
||
|
|
--
|
||
|
|
-- Notes: Meant to be executed from an Unix/Linux Oracle DB server
|
||
|
|
-- Requires the TPT toolset login.sql to be executed (via putting
|
||
|
|
-- TPT directory into SQLPATH) so that &trc variable would be
|
||
|
|
-- initialized with tracefile name.
|
||
|
|
--
|
||
|
|
--------------------------------------------------------------------------------
|
||
|
|
|
||
|
|
prompt Starting demo5...
|
||
|
|
|
||
|
|
host mknod &trc p
|
||
|
|
|
||
|
|
alter session set sql_trace=true;
|
||
|
|
|
||
|
|
select * from dual;
|
||
|
|
|