Keeping in mind however, That AWR on PDBs does not work properly in 12.2.
There are several metrics missing. Most distressingly, read and write
metrics.
I had an SR open for that, and the response was that it might be fixed in
19c.
When I last checked, 19.3 I think, the aforementioned metrics were still
missing.
I have not checked in later 19c versions.
There is also now a parameter to enable AWR for PDBs.
The effects of that on system resources are unknown to me at this time.
Jared
On Sun, Mar 7, 2021 at 19:36 Hemant K Chitale <hemantkchitale@xxxxxxxxx>
wrote:
Jared Still
If you have the licence for the Packs, you can generate an AWR report for
each target PDB (available since 12.2)
Hemant K Chitale
On Fri, Mar 5, 2021 at 8:18 PM Terrian, Thomas J CTR DLA INFO OPERATIONS <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
We have 4 PDBs. I want to determine for the past day how much DML each--
one has done.
Is there any way to calculate the amount of DML a PDB? ….or any way to
determine how much of an archivedlog can be attributed to each PDB.
