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

AWR report from or not from PDB
Next thread: Oracle upgrade
Prev thread: RMAN backups

Message Score Author Date
Hi, What is the difference if for a give PDB we...... Lauri Aug 19, 2019, 08:20
Hello Lauri, anyway the AWR stuff is gathered a...... Bruno Vroman Aug 19, 2019, 11:39
Hi Bruno, Yes, I understand, and I agree with y...... Lauri Aug 19, 2019, 12:51
Hi, there is some "complexity" involved with aw...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 19, 2019, 14:11
Hi, <i>> AWR repository is stored in CDB$ROOT o...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 19, 2019, 14:38
Hi Ales, Thanks for the links. Now, I am sure ...... Lauri Aug 19, 2019, 17:51
Hi, in typical situations when DBA (or DBA team...... Ales Kavsek Aug 20, 2019, 09:36
Hi, Yes, these are indeed relevant arguments. T...... Lauri Aug 20, 2019, 16:50

Follow up by mail Click here


Subject: AWR report from or not from PDB
Author: Lauri, Netherlands
Date: Aug 19, 2019, 08:20, 92 days ago
Os info: all
Oracle info: 12.2
Error info: n/a.
Message: Hi,

What is the difference if for a give PDB we take an AWR report from the root container, that shows all information for all PDSs, and take such an AWR report from that given PDB?

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

Subject: Re: AWR report from or not from PDB
Author: Bruno Vroman, Belgium
Date: Aug 19, 2019, 11:39, 92 days ago
Message: Hello Lauri,

anyway the AWR stuff is gathered at the database level, and in a CDB-PDB architecture, the word "database" in "Pluggable DataBase" is only a word... There is only ONE actual database: the CDB (and for example the retention of AWR data or the frequency of gathering is defined only at database level, you cannot have various values for various PDBs)

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-AWR report from or not from PDB
Author: Lauri, Netherlands
Date: Aug 19, 2019, 12:51, 92 days ago
Message: Hi Bruno,

Yes, I understand, and I agree with you, in a CDB-architecture: tne CDB database, and "plugged databases" on it.
So, I do giess AWR snaphot IDs are for the whole.
But, when I query awr_pdb_snapshot, inside a particular PDB, I get different snapshot IDs... hence my confusion.
The snapshots to be seen in dba_hist_snapshot are not to be found in awr_pdb_snapshot. what's the difference?
I cannot use the snapshots from dba_hist_snapshot to create an AWR report from the PDB. I get then ar error.

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-AWR report from or not from PDB
Author: Ales Kavsek, Slovenia
Date: Aug 19, 2019, 14:11, 92 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

there is some "complexity" involved with awr views (as you know AWR repository is stored in CDB$ROOT only and at some point switch to CDB$ROOT is done via so-called object link).
Personally, I don't really care about all the internals Oracle used , if you wish brief introduction you can read Franck Pachot blog post:

https://blog.dbi-services.com/12c-multitenant-internals-awr-tables-and-views/

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: Re-AWR report from or not from PDB
Author: Ales Kavsek, Slovenia
Date: Aug 19, 2019, 14:38, 92 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

> AWR repository is stored in CDB$ROOT only
a correction of my post above, from 12.2 you can indeed turn on AWR snapshots for PDBS (by default automatism is off) in which case statistics of PDB are stored in PDB SYSAUX.

Some example:
http://tanwanichandan.blogspot.com/2017/10/awr-in-multitenant-environment-oracle.html

So yes, snapshot ID's of PDB can differ from snapshot ID's of CDB.
Most DBA's handling multitenant databases probably use AWR at CDB level only,...(or am I wrong?)...

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-AWR report from or not from PDB
Author: Lauri, Netherlands
Date: Aug 19, 2019, 17:51, 92 days ago
Message: Hi Ales,

Thanks for the links.
Now, I am sure there were 2 kinds of snapshot ID involved: one at CDB$ROOT level and the other one at PDb level.
I like more runing AWR at CDB level at it will contain also information about all other PDBs.
But what is the advantage of running AWR on PDB? What is the advantage of this 12.2 feature?

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-AWR report from or not from PDB
Author: Ales Kavsek, Slovenia
Date: Aug 20, 2019, 09:36, 91 days ago
Message: Hi,

in typical situations when DBA (or DBA team) takes care for all PDBS's in a container database, I don't see any advantage. One that I can think of is if I would have some "special" PDB on which I would prefer to have a different automatic snapshot interval from the rest of PDB's.

But in the situation when DBA (or a team) "gives away" individual PDB as as service to several customers and each customer has someone responsible for administration of PDB, then local AWR is imho a good think (divide and conquer). AWR at CDB can contain some sensitive information that should not be shared with customer that is allowed to use one particular PDB.

Other than that, I believe having a complete overview at CDB level is better approach.

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-AWR report from or not from PDB
Author: Lauri, Netherlands
Date: Aug 20, 2019, 16:50, 91 days ago
Message: Hi,

Yes, these are indeed relevant arguments. Thanks!

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