# 43867
xxq780815
|
|
To:
寻找sql语句的语句
在通过V$sqltext,V$session得到sql时,在eygle的书中,看到两种取sql的语句
通过pid来获取sql
select sql_text from V$sqltext a where (a.hash_value,a.address) in
(select decode(sql_hash_value,0,pre_hash_value,sql_hash_value),decode(sql_address,0,pre_sql_address,sql_address) from V$session b where b.paddr =(select addr from V$process c where c.spid='$pid') order by piece ASC
通过sid来获取sql
select sql_text from V$sqltext a where a.hash_value =
(select sql_hash_value from V$session b where bsid='$sid'order by piece ASC
这两种方式感觉不是太一样的吧,不是很理解,望大虾解答下
hash_value和address才能确定一个sql吧
From: xxq780815 2008.01.20 22:52
|
|
|
|
To: xxq780815
[COLOR=blue]前者更加严谨,后者在绝大多数情况下也不会有问题。[/COLOR]
From: eygle 2008.01.22 21:46
|
|
|
|
# 43866
rigel
|
|
To:
大师,刚买了您的书,看到了1.2.5关于instance_name的含义和作用
但是我按照你的方法修改了oracle_sid
能在ps -ef|grep pmon 中看到2个实例但是这时候
show parameter instance_name 却是我修改后的SID,
请问一下大概是什么原因....
From: rigel 2008.01.20 20:23
|
|
|
|
To: rigel
[COLOR=blue]
和版本不同有关:
http://www.eygle.com/archives/2007/12/oracle9i_10g_instance_name.html
[/COLOR]
From: eygle 2008.01.20 21:48
|
|
|
|
# 43865
larry
|
|
To: eygle
大师您好:
我想请问下,我装的oracle10的oracle directory manager无法连接,说是服务器未启动和运行,我找了好久都不知道怎么解决,请问这是什么原因,或者能否提供个解决方法,先谢谢啦!
From: larry 2008.01.19 02:48
|
|
|
|
# 43864
xenos
|
|
To:
eygle,非加广告不可吗?!
From: xenos 2008.01.18 02:18
|
|
|
|
To: xenos
[COLOR=blue]赚点小钱,否则网站该倒闭了,可是还没什么人点击![/COLOR]
From: eygle 2008.01.19 20:34
|
|
|
|
# 43861
海人
来自: 上海
|
|
To: eygle
*** 2008-01-17 15:10:20.785
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
WARNING:Oracle process running out of OS kernel I/O resources
*** 2008-01-17 18:15:24.697
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
WARNING:Oracle process running out of OS kernel I/O resources
/u01/oracle/admin/peet/udump/peet_ora_2633910.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/oracle/product/db10gr2
System name: AIX
Node name: P05_peet
Release: 3
Version: 5
Machine: 00C24AC04C00
Instance name: peet
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 2633910, image: oraclepeet@peet
*** 2008-01-17 18:49:28.904
opiino: Attach failed! error=-1 ifvp=0
客户那边报错:
EPP_F_INC_TEST1: connect failed forenv: PTEST, user: wpaa, password: *****
Oracle error: -12547
ORA-12547: TNS:lost contact
From: 海人 2008.01.17 17:35
|
|
|
|
|