No question at this time
DBA Top 10
1 A. Kavsek 8400
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. Péran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48407
Total active users1518
Act. users last 24h4
Act. users last hour1
Registered user hits last week254
Registered user hits last month927
Go up

Catch heavy/active SQLs acroos all PDBs
Next thread: CPU time unit
Prev thread: Tracing database user in listener log

Message Score Author Date
Hi, Does someone know how to view the most acti...... Lauri Aug 14, 2019, 10:55
Hi Lauri, how do you find the requested info in...... Bruno Vroman Aug 14, 2019, 14:08
Hi Bruno, Usually (I should say all the time), ...... Lauri Aug 14, 2019, 17:55
Hello Lauri, from Oracle Documentation: <I> F...... Bruno Vroman Aug 15, 2019, 11:01
Hi Bruno, Tnanks. This should be sufficient for...... Lauri Aug 15, 2019, 11:03

Follow up by mail Click here


Subject: Catch heavy/active SQLs acroos all PDBs
Author: Lauri, Netherlands
Date: Aug 14, 2019, 10:55, 5 days ago
Os info: Linux
Oracle info: 12c
Error info: n/a
Message: Hi,

Does someone know how to view the most active sessions (memory, cpu, i/o) across all PDBs of a CDB without to log onto each PDB for a check and without using AWR or ADDM reports?

Thanks by advance for any tip.

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

Subject: Re: Catch heavy/active SQLs acroos all PDBs
Author: Bruno Vroman, Belgium
Date: Aug 14, 2019, 14:08, 5 days ago
Message: Hi Lauri,

how do you find the requested info in a PDB? By querying some DBA_XXXX views?
You can do the same at the CDB level with the "same" CDB_XXXX views (CDB... have extra columns to show the originating PDB).

Best regards,

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

Subject: Re-Catch heavy/active SQLs acroos all PDBs
Author: Lauri, Netherlands
Date: Aug 14, 2019, 17:55, 5 days ago
Message: Hi Bruno,

Usually (I should say all the time), I use the dba_xxx views.
But, is it possible to identify the most active session in a given PDB when logged on the CDB-root?
Do you mean I should use CDB_xxx views?

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

Subject: Re: Re-Catch heavy/active SQLs acroos all PDBs
Author: Bruno Vroman, Belgium
Date: Aug 15, 2019, 11:01, 4 days ago
Message: Hello Lauri,

from Oracle Documentation:
 For every DBA_* view, a CDB_* view is defined.
 ...
 In addition to all the columns found in a given DBA_* view, the corresponding CDB_* view also contains the CON_ID column, which identifies a container whose data a given CDB_* row represents.
 In a non-CDB, the value of a CON_ID column will be 0.
 Data is returned by these views from all open PDBs at the time the query is issued, except for PDBs that are open in RESTRICTED mode.


Best regards,

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

Subject: Re-Catch heavy/active SQLs acroos all PDBs
Author: Lauri, Netherlands
Date: Aug 15, 2019, 11:03, 4 days ago
Message: Hi Bruno,

Tnanks. This should be sufficient for my needs at that moment.

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