查询oracle dump文件位置:
SQL> show parameter dump;
NAMETYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dumpstring partial
background_dump_deststring/oracle/admin/insmix/bdump
core_dump_deststring/oracle/admin/insmix/cdump
max_dump_file_sizestring UNLIMITED
shadow_core_dumpstring partial
user_dump_dest
string /oracle/admin/insmix/udump
查询v$session中重要的列信息:
SQL> select sid,serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
105 40950 SYS
109 44692 TRAVEL
114 13454 TRAVEL
115 16376 TRAVEL
117 16717 TRAVEL
120 27350 TRAVEL
123 48541
133 19474 TRAVEL
141 52625 SYS
142 8549 TRAVEL
149 2
150 3
153 57669 TRAVEL
155 1
158 54 TRAVEL
160 1
161 1
162 1
163 1
164 1
SID SERIAL# USERNAME
---------- ---------- ------------------------------
165 1
166 1
167 1
168 1
169 1
170 1
发现username为空的是oracle系统的连接。
设置sql_trace参数跟踪执行的sql:
SQL> alter session set sql_trace=true;
Sessionaltered
SQL> select * from dual;
DUMMY
-----
X
SQL> show parameter dump;
NAME
TYPE VALUE
------------------------------------ -----------------------------------------
background_core_dumpstring partial
background_dump_deststring/var/oracle/oracle/admin/traveldb/bdump
core_dump_deststring/var/oracle/oracle/admin/traveldb/cdump
max_dump_file_sizestring UNLIMITED
shadow_core_dumpstring partial
user_dump_dest
string /var/oracle/oracle/admin/traveldb/udump
这个文件名字中的数字对应oracle进程的pid:
Cat一下这个trace文件:
发现了刚才执行的sql。
也可以针对不同的用户产生trace文件,oracle提供了一个包:set_sql_trace_in_session:
首先确定要跟踪的用户:
executedbms_system.set_sql_trace_in_session(139,72,true);
让travel用户执行一些sql:
Cat一下这个trace文件:
发现了我们刚才执行的语句。
这个参数是控制全局的sql是不是trace 一般不用这个,而是精确控制到用户的trace。
分享到:
相关推荐
介绍如何在VanetMobiSim中产生NS2能够使用的trace file
其中控制文件、数据文件、重做日志文件、跟踪文件及警告日志(trace files,alert files)属于数据库文件;参数文件(parameter file)口令文件(password file)是非数据库文件。SGA:是用于存储数据库信息的内存区...
LTOM runs on the customer's UNIX server, is tightly integrated with the host operating system and provides an integrated solution for detecting and collecting trace files for system performance ...
Trace File Manager (TFM) - Using PHP and Oracle to manage your distributed trace files--------------------------------------------------------------------------------------Deployment ...
This Second Edition includes an introduction to IPv6, ICMPv6 and DHCPv6 analysis, updated Wireshark functionality and new trace files. Refer to wiresharkbook.com for book supplements, index, table of ...
10.trace files: ethereal-traces.zip (most recent version: 1.0) Programming Assignments All labs open in a new window. Assignment 1: Building a Multi-Threaded Web Server in Java (Chapter 2) ...
Trace Files The Alert File Part II Oracle Database Server Messages 2 ORA-00000 to ORA-00899 3 ORA-00900 to ORA-01499 4 ORA-01500 to ORA-02099 5 ORA-02100 to ORA-04099 6 ORA-04100 to ORA-07499 7 ORA-...
Finally, the book focuses on pocket analysis for security tasks, command-line utilities, and tools that manage trace files. By the end of the book, you'll have learned how to use Wireshark for ...
Cocoa Packet Analyzer... CPA supports the industry-standard PCAP packet capture format for reading and writing packet trace files. With CPA you are able to analyze, display and filter packet trace files.
sdk中的tools文件夹中缺少traceview.bat文件,导致报DDMS files not found:sdk\\tools\traceview.bat
2.1.1 Choosing Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.1.2 Choosing Modes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
日志文件详解 Oracle数据库中的日志常用的有: Redo log files 联机日志或重做日志 Archived log files 归档日志 ...Trace files user_dump_dest 用户信息日志(如跟踪会话日志) Backupground_dump_dest 进程日志
高清原版文档,非扫描件 一、SQL................................................... 1.1、基本概念:........................................... 1.2、数据库安全:......................................... ...
DDMS files not found traceview.bat问题,将traceview.bat文件放到SDK相应tools文件夹下,重启eclipse
项目中有用AS也有用eclipse的,一次更新sdk导致eclipse提示ddms丢失traceview.bat,复制此文件到sdk下的tools文件下,重启eclipse即可
福利,解决 DDMS files not found: C:\Users\Administrator\AppData\Local\Android\Sdk\tools\traceview.bat
std::list< std::string > files; void initialize() { if( _access( "filelist.txt", 06 ) == 0 ) { // 如果文件存在则从文件中读取有效的文件名 std::ifstream file( "filelist.txt" ); std::string ...
android ADT升级后删除该文件,eclipse会报错。提示DDMS files not found,将本文件复制至sdk/tools目录下即可