SQL TRACE File Locations

最新推荐文章于 2022-08-01 09:27:49 发布

心毅

最新推荐文章于 2022-08-01 09:27:49 发布

阅读量281

点赞数

分类专栏： ORACLE 文章标签： file sql server database oracle query

本文链接：https://blog.csdn.net/guhui2509/article/details/6203661

版权

ORACLE 专栏收录该内容

84 篇文章 1 订阅

订阅专栏

Whether you use SQL_TRACE or the extended trace facility, Oracle will start generating a trace
file on the database server machine in one of two locations:
• If you are using a dedicated server connection, the trace file will be generated in the
directory specified by the USER_DUMP_DEST parameter.
• If you are using a shared server connection, the trace file will be generated in the directory
specified by the BACKGROUND_DUMP_DEST parameter.
To see where the trace files will go, you may either issue SHOW PARAMETER DUMP_DEST from
SQL*Plus or query the V$PARAMETER view directly:
ops$tkyte@ORA10G> select name, value
2 from v$parameter
3 where name like '%dump_dest%'
4 /
NAME VALUE
------------------------------ -------------------------------
background_dump_dest /home/ora10g/admin/ora10g/bdump
user_dump_dest /home/ora10g/admin/ora10g/udump
core_dump_dest /home/ora10g/admin/ora10g/cdump