| ARCn and PMON!! [message #138501] |
Thu, 22 September 2005 05:24  |
ankurgodambe
Messages: 45
Registered: March 2005
|
Member |
|
|
Hi,
My question is regarding PMON and ARCn process. I know that PMON process cleans a failed session and ARCn arechives the redo log files.
When I query v$session view i see some value for sql_hash_value column for the two sessions. When checked in v$sql it shows some queries that are against some application schema and not the dictionary. Now my question is how does sql_hash_value has some value for these sessions in v$session? Do they serve any other purpose as well, apart from the documented stuff? Can someone explain in which cases will we PMON and ARCn process do query against non dictionary tables?
Thanks
|
|
|
|
| Re: ARCn and PMON!! [message #140262 is a reply to message #138501] |
Mon, 03 October 2005 05:05  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Are you sure your query is correct?
Please post the suspect statements that PMON and ARCn are performing so we can look into it.
Best regards.
Frank
|
|
|
|
| Re: ARCn and PMON!! [message #140267 is a reply to message #140262] |
Mon, 03 October 2005 05:29 |
ankurgodambe
Messages: 45
Registered: March 2005
|
Member |
|
|
Hi,
Although, now I do not find any sql_hash_value for pmon, ARCn still has. Here is the series of sqlplus commands I have used:
SQL> select vb.name, vp.program, vp.spid,vs.sid
from v$session vs, v$process vp, v$bgprocess vb
where vb.paddr != '00'
and vb.paddr = vp.addr
and vp.addr = vs.paddr;
2 3 4 5
NAME PROGRAM SPID SID
----- ------------------------------------------------ --------- ----------
PMON oracle@scds017 (PMON) 3753 1
DBW0 oracle@scds017 (DBW0) 3755 2
DBW1 oracle@scds017 (DBW1) 3757 3
DBW2 oracle@scds017 (DBW2) 3759 4
DBW3 oracle@scds017 (DBW3) 3761 5
LGWR oracle@scds017 (LGWR) 3763 6
CKPT oracle@scds017 (CKPT) 3765 7
SMON oracle@scds017 (SMON) 3767 8
RECO oracle@scds017 (RECO) 3769 9
SNP0 oracle@scds017 (SNP0) 3771 59
SNP1 oracle@scds017 (SNP1) 3773 206
ARC0 oracle@scds017 (ARC0) 3775 12
ARC1 oracle@scds017 (ARC1) 7578 77
13 rows selected.
SQL> select sql_hash_value from v$session where sid=77;
SQL_HASH_VALUE
--------------
2417900230
SQL> select sql_text from v$sql where hash_value=2417900230;
SQL_TEXT
-----------------------------------------------------------------------------------------------------------------------------
SELECT COUNT(PNUMBER) FROM ECUsers.USERPERMISSIONS WHERE PNUMBER=96 and UREFITEM=:1
SELECT COUNT(PNUMBER) FROM ECUsers.USERPERMISSIONS WHERE PNUMBER=96 and UREFITEM=:1
SELECT COUNT(PNUMBER) FROM ECUsers.USERPERMISSIONS WHERE PNUMBER=96 and UREFITEM=:1
SELECT COUNT(PNUMBER) FROM ECUsers.USERPERMISSIONS WHERE PNUMBER=96 and UREFITEM=:1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
