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 hour0
Registered user hits last week128
Registered user hits last month434
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, 407 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, 402 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, 402 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