-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Each schema may require a PLAN_TABLE to debug performance so instead of creating the PLAN_TABLE within each schema, one can… READ MORE
|
CREATE OR REPLACE TRIGGER sys.session_trace_on– to be created by sys userAFTER LOGON ON databaseDECLAREmachinename VARCHAR2(64);osuserid VARCHAR2(30);ora_username VARCHAR2(30) DEFAULT NULL;os_username VARCHAR2(30);v_sid… READ MORE
|
Using Oracle SID and SERIAL# can turn trace on/off a Oracle session that has already started. The values of SID… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 