No question at this time
DBA Top 10
1 M. Cadot 10800
2 A. Kavsek 10100
3 B. Vroman 4800
4 P. Wisse 4200
5 J. Schnackenberg 2900
6 J. Péran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48515
Total active users1426
Act. users last 24h5
Act. users last hour0
Registered user hits last week153
Registered user hits last month718
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, 328 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, 328 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, 328 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, 327 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, 327 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