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

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, 327 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, 322 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, 322 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