- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SQL_TRACE
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:08 PM
тАО04-05-2004 09:08 PM
I'm running Oracle9i Enterprise Edition Release 9.2.0.4.0 64-bit on a HP-UX rx2600 ia 64-bit B11.23 (11i version 2) box. For some reason SQL_TRACE can not be activated.
I tried:
* SQL_TRACE=TRUE in the init file
* ALTER SESSION
* SET EVENTS
* LOGON TRIGGER that does an alter session or a set events.
I check that the software owner can write to the directory specified by the parameter user_dump_dest and that the file system is not full.
Anybody out there with a similar config where SQL Trace works?
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:21 PM
тАО04-05-2004 09:21 PM
Re: SQL_TRACE
select name, value from v$parameter where name like '%trace%';
select name, value from v$parameter where name like '%dump%';
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:25 PM
тАО04-05-2004 09:25 PM
Re: SQL_TRACE
SQL_TRACE is an initialization parameter. However, when you change its value with an ALTER SESSION statement, the results are not reflected in the V$PARAMETER view. Therefore, in this context it is considered a session parameter only.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:26 PM
тАО04-05-2004 09:26 PM
Re: SQL_TRACE
Here is the output.
SQL> /
NAME VALUE
---------------------------------------- ----------------------------------------
shadow_core_dump partial
background_core_dump partial
background_dump_dest /u01/app/oracle/admin/THALES/bdump
user_dump_dest /u01/app/oracle/admin/THALES/udump
max_dump_file_size UNLIMITED
core_dump_dest /u01/app/oracle/admin/THALES/cdump
6 rows selected.
NAME VALUE
---------------------------------------- ----------------------------------------
tracefile_identifier
trace_enabled TRUE
log_archive_trace 0
oracle_trace_enable FALSE
oracle_trace_facility_path ?/otrace/admin/fdf
oracle_trace_collection_path ?/otrace/admin/cdf
oracle_trace_facility_name oracled
oracle_trace_collection_name
oracle_trace_collection_size 5242880
sql_trace TRUE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:30 PM
тАО04-05-2004 09:30 PM
Re: SQL_TRACE
sql_trace=true
timed_statistics=true
user_dump_dest=
restart database.
Else
alter system set sql_trace=true
alter system set timed_statistics=true
Revert with the results
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:39 PM
тАО04-05-2004 09:39 PM
Re: SQL_TRACE
try
alter system set timed_statistics=true;
execute sys.dbms_system.set_sql_trace_in_session(
Does this work ?
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:42 PM
тАО04-05-2004 09:42 PM
Re: SQL_TRACE
Thanks anyway.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:51 PM
тАО04-05-2004 09:51 PM
Re: SQL_TRACE
Do you have permissions on the dir where the trace files are pointed out
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 09:58 PM
тАО04-05-2004 09:58 PM
Re: SQL_TRACE
Unfortunately no cigar either.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-05-2004 11:12 PM
тАО04-05-2004 11:12 PM
Re: SQL_TRACE
I perfer autotrace feature in sqlplus.
SQL> set autotrace on