No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

Where to find history of v$process and v$session
Next thread: Oracle12c Upgrade from Oracle11g 11.2.0.4
Prev thread: Creating a standby DataGuard database from RMAN backup done through Commvault

Message Score Author Date
Hi, I have found in a trace file an ospid havin...... Lauri Oct 29, 2019, 13:26
Hi, if you have a license for Diagnostic pack t...... Ales Kavsek Oct 29, 2019, 14:39
Hi Ales, In this situation I do not have the D...... Lauri Oct 30, 2019, 15:36

Follow up by mail Click here


Subject: Where to find history of v$process and v$session
Author: Lauri, Netherlands
Date: Oct 29, 2019, 13:26, 21 days ago
Os info: Linux x86 64bit
Oracle info: 12cR2
Error info: na
Message: Hi,

I have found in a trace file an ospid having used a high percentage of allocated memory.
I cannot find this ospid in v$process anymore.
Does someone where to find history of ospid/sid/serial#/username/process?

Thanks by advance for sharing your experience.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Where to find history of v$process and v$session
Author: Ales Kavsek, Slovenia
Date: Oct 29, 2019, 14:39, 21 days ago
Message: Hi,

if you have a license for Diagnostic pack then try ASH/AWR.

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

Subject: Re-Where to find history of v$process and v$session
Author: Lauri, Netherlands
Date: Oct 30, 2019, 15:36, 20 days ago
Message: Hi Ales,

In this situation I do not have the Diagnostic pack for this system...
But, if I look at the list of the AWR views, where can I find the history for sis.serial#,ospid?
I cannot see it in DBA_HIST_ACTIVE_SESS_HISTORY.

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