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

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, 212 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, 212 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, 211 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