Re: SQLTrace
You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLTrace
Title: RE: SQLTrace Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Gene Sais [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Subject: Re: SQLTrace You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLTrace
You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: SQLTrace
You can also use _trace_files_public=TRUE in your init.ora file too. I know it works with Oracle 8.0 and above on Solaris. Kevin Toepke snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLTrace
Title: RE: SQLTrace Hi Riyas, I had used this in previous versions. I'm on 8.1.6 now. I looked before sending this response and I didn't see this in v$parameter. What version are you on? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: SQLTrace You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: SQLTrace
Slightly off-topic: Has anybody used the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure? If so what's the syntax etc. to use this? Cheers Mark -Original Message- [EMAIL PROTECTED] Sent: Monday, April 23, 2001 04:56 To: Multiple recipients of list ORACLE-L You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RE: SQLTrace
To set on: REM Script to turn TRACE MODE on for a selected SID. set serveroutput ON size 2000; set verify OFF; DECLARE r_sid NUMBER; v_sid NUMBER; v_serial NUMBER; v_usernameVARCHAR(30); v_status VARCHAR2(8); v_server VARCHAR2(9); p_server_pid VARCHAR2(9); BEGIN -- Accept r_sid Number 'What SID do you wish to trace? - ' r_sid := SID; SELECT s.sid, s.serial#, s.status, s.server, p.spid INTO v_sid, v_serial, v_status, v_server, p_server_pid FROM v$session s, v$process p WHERE s.sid = r_sid AND s.paddr = p.addr; DBMS_OUTPUT.PUT_LINE ('Sid ' || TO_CHAR(v_sid) || ' Serial# ' || TO_CHAR(v_serial) || ' Username ' || v_username || ' Status ' || v_status || ' Server ' || v_server ); IF v_server != 'DEDICATED' THEN DBMS_OUTPUT.PUT_LINE ('Tracing only produces valid results for a Dedicated Connection'); DBMS_OUTPUT.PUT_LINE ('Tracing *NOT* turned on.'); RETURN; END IF; -- Time to Turn Trace ON SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(v_sid, v_serial, TRUE); DBMS_OUTPUT.PUT_LINE ('Trace Mode is ON for '||v_sid); DBMS_OUTPUT.PUT_LINE ('Output sent to udump/ora_'||p_server_pid||'.trc'); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('Cannot find a session for SID '||TO_CHAR(r_sid)); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('Error: '||SQLERRM); END; / To set off: REM Script to turn TRACE MODE off for a selected SID. set serveroutput ON size 2000; set verify OFF; DECLARE r_sid NUMBER; v_sid NUMBER; v_serial NUMBER; v_usernameVARCHAR(30); v_status VARCHAR2(8); v_server VARCHAR2(9); p_server_pid VARCHAR2(9); BEGIN -- Accept r_sid Number 'What SID do you wish to trace? - ' r_sid := SID; SELECT s.sid, s.serial#, s.status, s.server, p.spid INTO v_sid, v_serial, v_status, v_server, p_server_pid FROM v$session s, v$process p WHERE s.sid = r_sid AND s.paddr = p.addr; DBMS_OUTPUT.PUT_LINE ('Sid ' || TO_CHAR(v_sid) || ' Serial# ' || TO_CHAR(v_serial) || ' Username ' || v_username || ' Status ' || v_status || ' Server ' || v_server ); -- Time to Turn Trace OFF SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(v_sid, v_serial, FALSE); DBMS_OUTPUT.PUT_LINE ('Trace Mode is OFF for '||v_sid); DBMS_OUTPUT.PUT_LINE ('Output is in udump/ora_'||p_server_pid||'.ora'); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('Cannot find a session for SID '||TO_CHAR(r_sid)); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('Error: '||SQLERRM); END; / [EMAIL PROTECTED] 04/23/01 12:55PM Slightly off-topic: Has anybody used the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure? If so what's the syntax etc. to use this? Cheers Mark -Original Message- [EMAIL PROTECTED] Sent: Monday, April 23, 2001 04:56 To: Multiple recipients of list ORACLE-L You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do
RE: SQLTrace
Hi Lisa This is an underscore parameter. Hence v$parameter will not show this parameter.. You got to look at x$ksppi and x$psppcv fixed tables to see this parameter..Here is the SQL used if you are interested: --cut set linesize 80 pagesize 50 newpage 0 col param_dflt form a5 head 'Dflt?' col param_name form a41 head 'Parameter' col param_value form a31 head 'Value' select decode (ksppstdf, 'FALSE', 'NO', ' ') param_dflt, ksppinm param_name,ksppdesc descp, ksppstvl param_value from x$ksppi, x$ksppcv where x$ksppi.indx = x$ksppcv.indx order by ksppinm -cut Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 11:40 AM Please respond to ORACLE-L Hi Riyas, I had used this in previous versions. I'm on 8.1.6 now. I looked before sending this response and I didn't see this in v$parameter. What version are you on? -Original Message- Sent: Monday, April 23, 2001 11:56 AM To: Multiple recipients of list ORACLE-L You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner
RE: SQLTrace
DBMS_system.set_sql_trace_in_session(sid,serial#,true/False); u have to get the sid and serial# for which u want to set the trace. HTH -- On Mon, 23 Apr 2001 08:55:33 Mark Leith wrote: Slightly off-topic: Has anybody used the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure? If so what's the syntax etc. to use this? Cheers Mark -Original Message- [EMAIL PROTECTED] Sent: Monday, April 23, 2001 04:56 To: Multiple recipients of list ORACLE-L You can also set _trace_files_public=TRUE in the init. ora file.This will create trace files with 644 file permissions.. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com My opinions. Use at your risk Koivu, Lisa lkoivu@qode.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: RE: SQLTrace root@fatcity. com 04/23/01 09:10 AM Please respond to ORACLE-L Dave, you can also set a command in the cron to chmod the trace files frequently so everyone can access them. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Monday, April 23, 2001 9:26 AM To: Multiple recipients of list ORACLE-L You can also set the user_dump_dest in init.ora to /tmp/oracle where all users have access. [EMAIL PROTECTED] 04/20/01 05:27PM If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mª¿ªm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
RE: SQLTrace
Hi Dave, Pl change permission on the existing trace files that belong to the user. Add _trace_files_public = true in the init.ora file and bounce the db to make it effective. All future trace files will have public read access. However, tkprof should already be public executable. They don't need oracle's password to run it. More info? Check Metalink for Note:1022776.6 HTH.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: David Turner [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Subject: SQLTrace I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLTrace
Hi ! You can use the undocumented paramter _trace_files_public=true -Original Message- Turner Sent: Saturday, April 21, 2001 1:24 AM To: Multiple recipients of list ORACLE-L I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQLTrace
If I remember correctly the user can set autotrace on in the session and the output if sent to the terminal after the sql command is completed. Give it a try.. You might have to set up permessions or privileges to get it to work for a user. ROR mm [EMAIL PROTECTED] 04/20/01 03:54PM I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).