Re: Exadata storage cell metrichistory for controlfile

From: Moustafa Ahmed <moustafa_dba_at_hotmail.com>
Date: Wed, 6 Apr 2022 22:04:42 +0000
Message-ID: <PH7PR22MB3637DFD5564961D859EA2D8BE1E79_at_PH7PR22MB3637.namprd22.prod.outlook.com>

There are 2 files (one in each diskgroup) each is duplexed.

select distinct indx from x$kcccf;

      INDX

---

         0
         1

 0 shows the file in 1st disk group and 1 shows the one in 2nd disk group.

But how about p1 = 4294967295 ?

And p1 = 2 for event control file parallel write? Both values are not present in x$kcccf.

Also Looks like this number 4294967295 is a placeholder maybe as it 2^32

Thank you so much!

On Apr 5, 2022, at 4:37 PM, Karl Arao <karlarao_at_gmail.com> wrote:



Hi Moustafa,

SELECT * FROM x$kcccf WHERE indx = <p1>;

-Karl

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 07 2022 - 00:04:42 CEST