No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

ACTIVE_SESSION_HISTORY
Next thread: ORA-01839: date not valid for month specified
Prev thread: Audit successful login session for sql developer in oracle database

Message Score Author Date
HI Masters, i have one procedure written in PL/...... javed akhtar May 08, 2020, 09:30
Javed, Ash contains sampled data. Every second ...... Philip Wisse May 08, 2020, 10:02

Follow up by mail Click here


Subject: ACTIVE_SESSION_HISTORY
Author: javed akhtar, India
Date: May 08, 2020, 09:30, 20 days ago
Os info: linux
Oracle info: 12c
Message: HI Masters,

i have one procedure written in PL/SQL, which is having multiple sql queries written.

now i want to know from top sql id, how many sqi_id is related to top sql is, and running time.


as of now i m searching the child query from this command.

SQL_ID PROGRAM MODULE MACHINE CLIENT_ID QC_SESSION_ID SEQ# SQL_OPNAME PROGRAM CURRENT_OBJ# TOP_LEVEL_SQL PLSQL_OBJECT_ID SAMPLE_TIME
------------- -------------------- -------------------- -------------------- -------------------- ------------- ---------- -------------------- -------------------- ------------ ------------- --------------- -----------------------------------
bpgfrkmg7gvxd pkbfstrupd.exe pkbfstrupd.exe JDADELIVERS\KORCATST 22927 INSERT pkbfstrupd.exe -1 bpgfrkmg7gvxd 03-MAY-20 08.30.31.725 AM
EP1



how i can find please help
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ACTIVE_SESSION_HISTORY
Author: Philip Wisse, Netherlands
Date: May 08, 2020, 10:02, 20 days ago
Message: Javed,

Ash contains sampled data. Every second all running (non-idle) sessions produce a record in this history table.

So if your SQL runs for half a second it may be recorded in ash but also it may be not.

As for child sql it will be recorded with the same SESSION_ID, SESSION_SERIAL# and USER_ID.

https://docs.oracle.com/database/121/REFRN/GUID-69CEA3A1-6C5E-43D6-982C-F353CD4B984C.htm#REFRN30299

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here