Re: DML for PDB

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_at_gmail.com> wrote:

>
> 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_at_freelists.org> 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.
>>
>>
>>
>>
>>
> --
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill

--
http://www.freelists.org/webpage/oracle-l