No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48536
Total active users1398
Act. users last 24h2
Act. users last hour1
Registered user hits last week128
Registered user hits last month434
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, 408 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, 408 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, 408 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, 407 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, 407 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