1745人阅读
异常排查（28）
最近一直在做，通过java后台，如何知道Oracle正在执行sql。因为不能与客户进行有效的沟通，也没有到现场了解，数据是如何进行的导入，所以这方面一直没有得到有效的突破；
在查找资料的时候，发现了一条Sql语句。通过这条语句，可以知道当前连接的数据库正在执行的sql语句是什么。是一种比较有效的获取当前数据库动态的方式；通过获取当前执行的sql语句，来判断当前数据库是否有在执行；
先执行以下查询语句
select a.program, b.spid, c.sql_text,c.SQL_ID
& from v$session a, v$process b, v$sqlarea c
&where a.paddr = b.addr
&& and a.sql_hash_value = c.hash_value
racgimon@cdcj1 (TNS V1-V3)
&DECLARE&& reason_id
65vuzhm491wk9
oracleRLZY@rx6600-2 (TNS V1-V3)
SELECT &AKB020& FROM &KB
09rp36jmgpj5a
oracleRLZY@rx6600-2 (TNS V1-V3)
&& SELECT &AAC001&,&BTC102&
oracleRLZY@rx6600-2 (TNS V1-V3)
&&& SELECT &AAC001&,&BTC102&
plsqldev.exe
&& select a.program, b.spid
5qq47bz3tzfws
JDBC Thin Client
& select * from ( select r
686nqabc8sgs2
如上表中的program列中的jdbc thin client代表的是通过jdbc连接执行的sql语句由于sql_text列没有显示完整的sql语句，所以可以利用sql_id字段686nqabc8sgs2再查询v$sql
Sql语句如下：
selecta.* from v$sql a where a.SQL_ID='686nqabc8sgs2'
可以查看完整的sql文本内容
&&相关文章推荐
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：67119次
积分：2299
积分：2299
排名：第17242名
原创：156篇
文章：13篇
阅读：3594
文章：12篇
阅读：3777
文章：13篇
阅读：4499
文章：23篇
阅读：8350
文章：68篇
阅读：27325
(4)(13)(15)(18)(18)(26)(17)(21)(16)(16)(10)
(window.slotbydup = window.slotbydup || []).push({
id: '4740881',
container: s,
size: '200,200',
display: 'inlay-fix'博客分类：
1.曾经不小心把开发库的数据库表全部删除，当时吓的要死。结果找到下面的语句恢复到了1个小时之前的数据！很简单。
注意使用管理员登录系统：
select * from 表名 as of timestamp sysdate-1/12
//查询两个小时前的某表数据！既然两小时以前的数据都得到了，继续怎么做，知道了吧。。
如果drop了表，怎么办？？见下面：
drop table 表名;
数据库误删除表之后恢复:（ 绝对ok，我就做过这样的事情，汗 ）不过要记得删除了哪些表名。 flashback table 表名
2.查询得到当前数据库中锁，以及解锁：
查锁SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL) LOCK_LEVEL,o.owner,o.object_name,o.object_type,s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuserFROM v$session s,v$lock l,dba_objects oWHERE l.sid = s.sidAND l.id1 = o.object_id(+)AND s.username is NOT NULL;解锁alter system kill session 'sid,serial'; 如果解不了。直接倒os下kill进程kill －9 spid
3.关于查询数据库用户，权限的相关语句：
1.查看所有用户：
select * from dba_
select * from all_
select * from user_
2.查看用户系统权限：
select * from dba_sys_
select * from all_sys_
select * from user_sys_
3.查看用户对象权限：
select * from dba_tab_
select * from all_tab_
select * from user_tab_
4.查看所有角色：
select * from dba_
5.查看用户所拥有的角色：
select * from dba_role_
select * from user_role_
1.查看所有用户：
select * from dba_
select * from all_
select * from user_
2.查看用户系统权限：
select * from dba_sys_
select * from all_sys_
select * from user_sys_
3.查看用户对象权限：
select * from dba_tab_
select * from all_tab_
select * from user_tab_
4.查看所有角色：
select * from dba_
5.查看用户所拥有的角色：
select * from dba_role_
select * from user_role_
4.几个经常用到的oracle视图：注意表名使用大写....................
1. 查询oracle中所有用户信息
* from dba_
2. 只查询用户和密码
select username,password from dba_
3. 查询当前用户信息
select * from dba_
4. 查询用户可以访问的视图文本
select * from dba_
5. 查询数据库中所有视图的文本
select * from dba_
6.查询全部索引
select * from user_
查询全部表格
select * from user_
查询全部约束
select * from user_
查询全部对象
select * from user_
1. 查询oracle中所有用户信息
* from dba_
2. 只查询用户和密码
select username,password from dba_
3. 查询当前用户信息
select * from dba_
4. 查询用户可以访问的视图文本
select * from dba_
5. 查询数据库中所有视图的文本
select * from dba_
6.查询全部索引
select * from user_
查询全部表格
select * from user_
查询全部约束
select * from user_
查询全部对象
select * from user_
5.查看当前数据库中正在执行的语句，然后可以继续做很多很多事情，例如查询执行计划等等
(1).查看相关进程在数据库中的会话
a.sid,a.serial#,a.program,
substr(a.machine,1,20),
a.terminal,b.spid
a.paddr=b.addr
(2).查看数据库中被锁住的对象和相关会话
a.sid,a.serial#,a.username,a.program,
c.object_name
v$locked_object
all_objects
a.sid=b.session_id
c.object_id
(3).查看相关会话正在执行的SQL
sql_address
(1).查看相关进程在数据库中的会话
a.sid,a.serial#,a.program,
substr(a.machine,1,20),
a.terminal,b.spid
a.paddr=b.addr
(2).查看数据库中被锁住的对象和相关会话
a.sid,a.serial#,a.username,a.program,
c.object_name
v$locked_object
all_objects
a.sid=b.session_id
c.object_id
(3).查看相关会话正在执行的SQL
sql_address
6.查询表的结构：表名大写！！
select t.COLUMN_NAME,
t.DATA_TYPE,
nvl(t.DATA_PRECISION, t.DATA_LENGTH),
nvl(T.DATA_SCALE, 0),
c.comments
from all_tab_columns t, user_col_comments c whEre t.TABLE_NAME = c.table_name
and t.COLUMN_NAME = c.column_name
and t.TABLE_NAME = UPPER('OM_EMPLOYEE_T') order by t.COLUMN_ID
7.行列互换：
建立一个例子表：
CREATE TABLE t_col_row(
c1 VARCHAR2(10),
c2 VARCHAR2(10),
c3 VARCHAR2(10));
INSERT INTO t_col_row VALUES (1, 'v11', 'v21', 'v31');
INSERT INTO t_col_row VALUES (2, 'v12', 'v22', NULL);
INSERT INTO t_col_row VALUES (3, 'v13', NULL, 'v33');
INSERT INTO t_col_row VALUES (4, NULL, 'v24', 'v34');
INSERT INTO t_col_row VALUES (5, 'v15', NULL, NULL);
INSERT INTO t_col_row VALUES (6, NULL, NULL, 'v35');
INSERT INTO t_col_row VALUES (7, NULL, NULL, NULL);
下面的是列转行:创建了一个视图
CREATE view v_row_col AS
SELECT id, 'c1' cn, c1 cv
FROM t_col_row
SELECT id, 'c2' cn, c2 cv
FROM t_col_row
SELECT id, 'c3' cn, c3 cv FROM t_col_
下面是创建了没有空值的一个竖表:
CREATE view v_row_col_notnull AS
SELECT id, 'c1' cn, c1 cv
FROM t_col_row
where c1 is not null
SELECT id, 'c2' cn, c2 cv
FROM t_col_row
where c2 is not null
SELECT id, 'c3' cn, c3 cv
FROM t_col_row
where c3 is not null;
建立一个例子表：
CREATE TABLE t_col_row(
c1 VARCHAR2(10),
c2 VARCHAR2(10),
c3 VARCHAR2(10));
INSERT INTO t_col_row VALUES (1, 'v11', 'v21', 'v31');
INSERT INTO t_col_row VALUES (2, 'v12', 'v22', NULL);
INSERT INTO t_col_row VALUES (3, 'v13', NULL, 'v33');
INSERT INTO t_col_row VALUES (4, NULL, 'v24', 'v34');
INSERT INTO t_col_row VALUES (5, 'v15', NULL, NULL);
INSERT INTO t_col_row VALUES (6, NULL, NULL, 'v35');
INSERT INTO t_col_row VALUES (7, NULL, NULL, NULL);
下面的是列转行:创建了一个视图
CREATE view v_row_col AS
SELECT id, 'c1' cn, c1 cv
FROM t_col_row
SELECT id, 'c2' cn, c2 cv
FROM t_col_row
SELECT id, 'c3' cn, c3 cv FROM t_col_
下面是创建了没有空值的一个竖表:
CREATE view v_row_col_notnull AS
SELECT id, 'c1' cn, c1 cv
FROM t_col_row
where c1 is not null
SELECT id, 'c2' cn, c2 cv
FROM t_col_row
where c2 is not null
SELECT id, 'c3' cn, c3 cv
FROM t_col_row
8.下面可能是dba经常使用的oracle视图吧。呵呵
1.示例：已知hash_value:，查询sql语句：
select * from v$sqltext
where hashvalue=''
order by piece
2.查看消耗资源最多的SQL：
SELECT hash_value, executions, buffer_gets, disk_reads, parse_calls
FROM V$SQLAREA
WHERE buffer_gets & OR disk_reads & 1000000
ORDERBY buffer_gets + 100 * disk_reads DESC;
3.查看某条SQL语句的资源消耗：
SELECT hash_value, buffer_gets, disk_reads, executions, parse_calls
FROM V$SQLAREA
WHERE hash_Value = AND address = hextoraw('CBD8E4B0');
4.查询sql语句的动态执行计划:
首先使用下面的语句找到语句的在执行计划中的address和hash_code
SELECT sql_text, address, hash_value FROM v$sql t
where (sql_text like '%OM_FUNCTION_T%OM_RESOURCE_AUTHORITY_T%OM_BUSI_PERSON_RELA_T%')
SELECT operation, options, object_name, cost FROM v$sql_plan
WHERE address = 'CD248' AND hash_value = ;
5.查询oracle的版本:
select * from v$
6.查询数据库的一些参数:
select * from v$parameter
7.查找你的session信息
SELECT SID, OSUSER, USERNAME, MACHINE, PROCESS
FROM V$SESSION WHERE audsid = userenv('SESSIONID');
8.当machine已知的情况下查找session
SELECT SID, OSUSER, USERNAME, MACHINE, TERMINAL
FROM V$SESSION
WHERE terminal = 'pts/tl' AND machine = 'rgmdbs1';
9.查找当前被某个指定session正在运行的sql语句。假设sessionID为100
select b.sql_text
from v$session a,v$sqlarea b
where a.sql_hashvalue=b.hash_value and a.sid=100
1.示例：已知hash_value:，查询sql语句：
select * from v$sqltext
where hashvalue=''
order by piece
2.查看消耗资源最多的SQL：
SELECT hash_value, executions, buffer_gets, disk_reads, parse_calls
FROM V$SQLAREA
WHERE buffer_gets & OR disk_reads & 1000000
ORDERBY buffer_gets + 100 * disk_reads DESC;
3.查看某条SQL语句的资源消耗：
SELECT hash_value, buffer_gets, disk_reads, executions, parse_calls
FROM V$SQLAREA
WHERE hash_Value = AND address = hextoraw('CBD8E4B0');
4.查询sql语句的动态执行计划:
首先使用下面的语句找到语句的在执行计划中的address和hash_code
SELECT sql_text, address, hash_value FROM v$sql t
where (sql_text like '%OM_FUNCTION_T%OM_RESOURCE_AUTHORITY_T%OM_BUSI_PERSON_RELA_T%')
SELECT operation, options, object_name, cost FROM v$sql_plan
WHERE address = 'CD248' AND hash_value = ;
5.查询oracle的版本:
select * from v$
6.查询数据库的一些参数:
select * from v$parameter
7.查找你的session信息
SELECT SID, OSUSER, USERNAME, MACHINE, PROCESS
FROM V$SESSION WHERE audsid = userenv('SESSIONID');
8.当machine已知的情况下查找session
SELECT SID, OSUSER, USERNAME, MACHINE, TERMINAL
FROM V$SESSION
WHERE terminal = 'pts/tl' AND machine = 'rgmdbs1';
9.查找当前被某个指定session正在运行的sql语句。假设sessionID为100
select b.sql_text
from v$session a,v$sqlarea b
where a.sql_hashvalue=b.hash_value and a.sid=100
9.树形结构connect by 排序：
查询树形的数据结构，同时对一层里面的数据进行排序
SELECT last_name, employee_id, manager_id, LEVEL
FROM employees
START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
&SPAN style="BACKGROUND-COLOR: #ff0000"& ORDER SIBLINGS BY last_&/SPAN&
下面是查询结果
EMPLOYEE_ID MANAGER_ID
查询树形的数据结构，同时对一层里面的数据进行排序
SELECT last_name, employee_id, manager_id, LEVEL
FROM employees
START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
ORDER SIBLINGS BY last_
下面是查询结果
EMPLOYEE_ID MANAGER_ID
------------------------- ----------- ---------- ----------
10.有时候写多了东西，居然还忘记最基本的sql语法，下面全部写出来，基本的oracle语句都在这里可以找到了。是很基础的语句！
1.在数据字典查询约束的相关信息：
SELECT constraint_name, constraint_type,search_condition
user_constraints WHERE
table_name = 'EMPLOYEES';
//这里的表名都是大写！
2对表结构进行说明：
desc Tablename
3查看用户下面有哪些表
select table_name from user_
4查看约束在那个列上建立：
SELECT constraint_name, column_name
user_cons_columns
table_name = 'EMPLOYEES';
10结合变量查找相关某个表中约束的相关列名：
select constraint_name,column_name from user_cons_columns where table_name = '&tablename'
12查询数据字典看中间的元素：
object_name, object_type
user_objects
object_name LIKE 'EMP%'
object_name LIKE 'DEPT%'
14查询对象类型：
SELECT DISTINCT object_type FROM
17改变对象名：（表名，视图,序列）
emp to emp_newTable
18添加表的注释：
COMMENT ON TABLE employees IS 'Employee Information';
20查看视图结构：
describe view_name
23在数据字典中查看视图信息：
select viewe_name,text from user_views
25查看数据字典中的序列：
select * from user_sequences
33得到所有的时区名字信息：
* from v$timezone_names
34显示对时区‘US/Eastern’的时区偏移量
select TZ_OFFSET('US/Eastern') from DUAL
显示当前会话时区中的当前日期和时间:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
ALTER SESSION SET TIME_ZONE = '-5:0';
SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL;
SELECT CURRENT_TIMESTAMP FROM DUAL;
SELECT CURRENT_TIMESTAMP FROM DUAL;
35显示数据库时区和会话时区的值：
select datimezone,sessiontimezone from
13普通的建表语句：
CREATE TABLE dept
NUMBER(2),
VARCHAR2(14),
VARCHAR2(13));
15使用子查询建立表:
CREATE TABLE
employee_id, last_name,
salary*12 ANNSAL,
department_id = 80;
6添加列：// alter table EMP add column (dept_id number(7))；错误！！
alter table EMP add (dept_id number(7));
7删除一列：
alter table emp drop column dept_
8添加列名同时和约束：
alter table EMP add (dept_id number(7)
constraint my_emp_dept_id_fk
references dept(ID));
9改变列：//注意约束不能够修改 的！！
alter table dept80 modify(last_name varchar2(30));//这里使用的是modify而不是alter!
24增加一行：
insert into table_name values();
5添加主键:
alter Table EMP
add constraint my_emp_id_pk primary key (ID);
11添加一个有check约束的新列：
alter table EMP
add (COMMISSION number(2) constraint emp_commission_ck check(commission&0))
16删除表：
drop table
19创建视图：
CREATE VIEW
employee_id, last_name, salary
department_id = 80;
21删除视图：
drop view view_name
22找到工资最高的5个人。（top-n分析）（行内视图）
select rownum,employee_id from (select employee_id,salary from
employees order by salary desc)
where rownum&5;
26建立同义词：
create synonym 同义词名 for 原来的名字
create public synonym 同义词名 for 原来的名字
27建立序列：（注意，这里并没有出现说是哪个表里面的序列！！）
CREATE SEQUENCE dept_deptid_seq
INCREMENT BY 10
START WITH 120
MAXVALUE 9999
28使用序列：
insert into dept(ID,NAME) values(DEPT_ID_SEQ.nextval,'Administration');
29建立索引：//默认就是nonunique索引，除非使用了关键字：unique
CREATE INDEX emp_last_name_idx ON employees(last_name);
30建立用户：（可能有错，详细查看帮助）
create user
nuesoft(用户名)
identified by oracle(密码)
default tablespace
data01(表空间名//默认存在system表空间里面)
quota 10M(设置大小，最大为unlimited)
on 表空间名//必须分配配额！
31创建角色：create ROLE manager
赋予角色权限：grant create table,create view to manage
赋予用户角色：grant manager to DENHAAN,KOCHHAR( 两个用户)
32分配权限：
update (department_name, location_id)
departments
select, insert
departments
36从时间中
浏览: 3728 次
来自: 深圳v$sqlarea字段含义
VARCHAR2(1000)
First thousand characters of the SQL text for the current cursor
VARCHAR2(13)
SQL identifier of the parent cursor in the library cache
SHARABLE_MEM
Amount of shared memory used by a cursor. If multiple child cursors exist, then the sum of all shared memory used by all child cursors.
PERSISTENT_MEM
Fixed amount of memory used for the lifetime of an open cursor. If multiple child cursors exist, the fixed sum of memory used for the lifetime of all the child cursors.
RUNTIME_MEM
Fixed amount of memory required during execution of a cursor. If multiple child cursors exist, the fixed sum of all memory required during execution of all the child cursors.
Sum of the number of sorts that were done for all the child cursors
VERSION_COUNT
Number of child cursors that are present in the cache under this parent
LOADED_VERSIONS
Number of child cursors that are present in the cache and have their context heap (KGL heap 6) loaded
OPEN_VERSIONS
The number of child cursors that are currently open under this current parent
USERS_OPENING
Number of users that have any of the child cursors open
Number of fetches associated with the SQL statement
EXECUTIONS
Total number of executions, totalled over all the child cursors
END_OF_FETCH_COUNT
Number of times this cursor was fully executed since the cursor was brought into the library cache. The value of this statistic is not incremented when the cursor is partially executed, either because it failed during the execution or because only the first few rows produced by this cursor are fetched before the cursor is closed or re-executed. By definition, the value of the END_OF_FETCH_COUNT column should be less or equal to the value of the EXECUTIONS column.
USERS_EXECUTING
Total number of users executing the statement over all child cursors
Number of times the object was loaded or reloaded
FIRST_LOAD_TIME
VARCHAR2(19)
Timestamp of the parent creation time
INVALIDATIONS
Total number of invalidations over all the child cursors
PARSE_CALLS
Sum of all parse calls to all the child cursors under this parent
DISK_READS
Sum of the number of disk reads over all child cursors
DIRECT_WRITES
Sum of the number of direct writes over all child cursors
BUFFER_GETS
Sum of buffer gets over all child cursors
APPLICATION_WAIT_TIME
Application wait time
CONCURRENCY_WAIT_TIME
Concurrency wait time
CLUSTER_WAIT_TIME
Cluster wait time
USER_IO_WAIT_TIME
User I/O Wait Time
PLSQL_EXEC_TIME
PL/SQL execution time
JAVA_EXEC_TIME
Java execution time
ROWS_PROCESSED
Total number of rows processed on behalf of this SQL statement
COMMAND_TYPE
Oracle command type definition
OPTIMIZER_MODE
VARCHAR2(25)
Mode under which the SQL statement was executed
PARSING_USER_ID
User ID of the user that has parsed the very first cursor under this parent
PARSING_SCHEMA_ID
Schema ID that was used to parse this child cursor
KEPT_VERSIONS
Number of child cursors that have been marked to be kept using the DBMS_SHARED_POOL package
RAW(4 | 8)
Address of the handle to the parent for this cursor
HASH_VALUE
Hash value of the parent statement in the library cache
OLD_HASH_VALUE
Old SQL hash value
VARCHAR2(64)
Contains the name of the module that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_MODULE
MODULE_HASH
Hash value of the module that is named in the MODULE column
VARCHAR2(64)
Contains the name of the action that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_ACTION
ACTION_HASH
Hash value of the action that is named in the ACTION column
SERIALIZABLE_ABORTS
Number of times the transaction fails to serialize, producing ORA-08177 errors, totalled over all the child cursors
CPU time (in microseconds) used by this cursor for parsing/executing/fetching
ELAPSED_TIME
Elapsed time (in microseconds) used by this cursor for parsing/executing/fetching
IS_OBSOLETE
VARCHAR2(1)
Indicates whether the cursor has become obsolete (Y) or not (N). This can happen if the number of child cursors is too large.
CHILD_LATCH
Child latch number that is protecting the cursor
PROGRAM_ID
Program identifie
关键字段：
V$SQLAREA中的信息列
HASH_VALUE：SQL语句的Hash值。ADDRESS：SQL语句在SGA中的地址。这两列被用于鉴别SQL语句，有时，两条不同的语句可能hash值相同。这时候，必须连同ADDRESS一同使用来确认SQL语句。PARSING_USER_ID：为语句解析第一条CURSOR的用户VERSION_COUNT：语句cursor的数量KEPT_VERSIONS：SHARABLE_MEMORY：cursor使用的共享内存总数PERSISTENT_MEMORY：cursor使用的常驻内存总数RUNTIME_MEMORY：cursor使用的运行时内存总数。SQL_TEXT：SQL语句的文本（最大只能保存该语句的前1000个字符）。MODULE,ACTION：使用了DBMS_APPLICATION_INFO时session解析第一条cursor时的信息
V$SQLAREA中的其它常用列
SORTS: 语句的排序数CPU_TIME: 语句被解析和执行的CPU时间ELAPSED_TIME: 语句被解析和执行的共用时间PARSE_CALLS: 语句的解析调用(软、硬)次数EXECUTIONS: 语句的执行次数INVALIDATIONS: 语句的cursor失效次数LOADS: 语句载入(载出)数量ROWS_PROCESSED: 语句返回的列总数
V$SQLAREA中的连接列Column View Joined Column(s)HASH_VALUE, ADDRESS V$SESSION SQL_HASH_VALUE, SQL_ADDRESSHASH_VALUE, ADDRESS V$SQLTEXT, V$SQL, V$OPEN_CURSOR HASH_VALUE, ADDRESSSQL_TEXT V$DB_OBJECT_CACHE NAME
&&最后修改于
请各位遵纪守法并注意语言文明查看: 5494|回复: 5
为什么通过sql_id在v$sqlarea中找不到对语句
论坛徽章:1
为什么通过sql_id在v$sqlarea中找不到对语句&&要找的是一个select语句 还有 貌似所有 analyze table这样的语句在v$sqlarea中也找不到 想问一下这个视图存储历史记录的规则是什么 为什么有些语句没有保存
认证徽章论坛徽章:41
数据库版本？
论坛徽章:13
只要这个sql被age out出shared pool,那么你就从v$sql和v$sqlarea中找不到了。
但是你可以尝试从DBA_HIST_SQLTEXT，DBA_HIST_SQL_PLAN，DBA_HIST_SQLSTAT中查找，如果是10g以上版本的话
这个视图实际上是直接查询x$表，所以是直接访问内存（shared pool）中的东西
SQL& select VIEW_DEFINITION from V$FIXED_VIEW_DEFINITION where view_name like '%GV$SQL';
VIEW_DEFINITION
--------------------------------------------------------------------------------
select inst_id,kglnaobj,kglfnobj,kglobt03, kglobhs0+kglobhs1+kglobhs2+kglobhs3+k
globhs4+kglobhs5+kglobhs6+kglobt16, kglobt08+kglobt11, kglobt10, kglobt01, decod
e(kglobhs6,0,0,1), decode(kglhdlmd,0,0,1), kglhdlkc, kglobt04, kglobt05, kglobt4
8, kglobt35, kglobpc6, kglhdldc, substr(to_char(kglnatim,'YYYY-MM-DD/HH24:MI:SS'
),1,19), kglhdivc, kglobt12, kglobt13, kglobwdw, kglobt14, kglobwap, kglobwcc, k
globwcl, kglobwui, kglobt42, kglobt43, kglobt15, kglobt02, decode(kglobt32,
& &0, 'NONE',& && &&&1, 'ALL_ROWS',& && &&&2, 'FIRST_ROWS',& && &&&3, 'RULE',
& &&&4, 'CHOOSE',& && && &&&'UNKNOWN'), kglobtn0, kglobcce, kglobcceh, kglobt17,
kglobt18, kglobts4, kglhdkmk, kglhdpar, kglobtp0, kglnahsh, kglobt46, kglobt30,
kglobt09, kglobts5, kglobt48, kglobts0, kglobt19, kglobts1, kglobt20, kglobt21,
kglobts2, kglobt06, kglobt07, decode(kglobt28, 0, to_number(NULL), kglobt28), k
glhdadr, kglobt29, decode(bitand(kglobt00,64),64, 'Y', 'N'), decode(kglobsta,
& &&&1, 'VALID',& && &&&2, 'VALID_AUTH_ERROR',& && &&&3, 'VALID_COMPILE_ERROR',
& && & 4, 'VALID_UNAUTH',& && &&&5, 'INVALID_UNAUTH',& && &&&6, 'INVALID'), kglo
bt31, substr(to_char(kglobtt0,'YYYY-MM-DD/HH24:MI:SS'),1,19), decode(kglobt33, 1
, 'Y', 'N'),&&kglhdclt, kglobts3, kglobt44, kglobt45, kglobt47, kglobt49, kglobc
la,&&kglobcbca, kglobt22&&from x$kglcursor_child
[ 本帖最后由 symield 于
22:05 编辑 ]
论坛徽章:1
回复 #3 symield 的帖子
谢楼上 ~ 10G 后来找到了那些数据字典 现在还是需要在了解下具体的 比如我知道sql_id 如何查询一个语句的具体开始结束时间 session的一些信息 如登陆用户主机名等等 呵呵 有没有一些常用的查询语句呢
论坛徽章:13
具体开始结束时间是查不到的。
session的一些信息 如登陆用户主机名 有时候是可以查到的。
常用的查询语句我手头没有...
论坛徽章:1
发现可以通过查询等待事件的时间来大概估计语句的运行时间~~&&dba_hist_active_sess_history&&多谢
itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：10　广播电视节目制作经营许可证：编号（京）字第1149号