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

Snapshots for PDB
Next thread: RMAN backups
Prev thread: CPU time unit

Message Score Author Date
Hi, Does someone know with which view can we se...... Lauri Aug 15, 2019, 11:06
Hi, for >=12.2 try AWR_PDB_SNAPSHOT. More on th...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Aug 20, 2019, 09:25
Hi, Thanks, I just discovered it. Interesting ...... Lauri Aug 20, 2019, 16:53

Follow up by mail Click here


Subject: Snapshots for PDB
Author: Lauri, Netherlands
Date: Aug 15, 2019, 11:06, 96 days ago
Os info: all
Oracle info: 12c and higher
Error info: n/a
Message: Hi,

Does someone know with which view can we see information for the snap_id for a given PDB?
If I get a look at dba_hist_snapshot, I get the same result either from the root container or from the PDB.

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

Subject: Re: Snapshots for PDB
Author: Ales Kavsek, Slovenia
Date: Aug 20, 2019, 09:25, 91 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

for >=12.2 try AWR_PDB_SNAPSHOT. More on this...

https://blog.dbi-services.com/oracle-12cr2-awr-views-in-multitenant/

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-Snapshots for PDB
Author: Lauri, Netherlands
Date: Aug 20, 2019, 16:53, 91 days ago
Message: Hi,

Thanks, I just discovered it.
Interesting link by the way.
Yet, unless strictly necessary, I will stick the CDB$ROOT snapshots.

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