Re: reads by KTSJ
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Wed, 13 May 2020 14:23:16 -0400
Message-ID: <CAMHX9J+pX7+7Ss--jhuoGbbVuV9zOzvtq_O0ngc-Cn4Tw2vKew_at_mail.gmail.com>
Date: Wed, 13 May 2020 14:23:16 -0400
Message-ID: <CAMHX9J+pX7+7Ss--jhuoGbbVuV9zOzvtq_O0ngc-Cn4Tw2vKew_at_mail.gmail.com>
Could be related to these operations:
SQL> _at_proc dbms%pa fix
OWNER OBJECT_NAME PROCEDURE_NAME ------------------------- ------------------------------ ------------------------------ SYS DBMS_SPACE_ADMIN TABLESPACE_FIX_AFFINITY SYS DBMS_SPACE_ADMIN TABLESPACE_FIX_BITMAPS SYS DBMS_SPACE_ADMIN TABLESPACE_FIX_SEGMENT_EXTBLKS SYS DBMS_SPACE_ADMIN TABLESPACE_FIX_SEGMENT_STATES SYS DBMS_REPAIR FIX_CORRUPT_BLOCKS SYS DBMS_REPAIR SEGMENT_FIX_STATUS
-- Tanel https://tanelpoder.com On Wed, May 13, 2020 at 2:17 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:Received on Wed May 13 2020 - 20:23:16 CEST
> You mentioned that there were some *buffer busy waits* showing up too?
>
> Instead of relying on the block address & DBA_EXTENTS query (maybe this
> block has been reused by something else by now?), you can use ashtop to see
> which *block class* the buffer busy waits were against. A random example
> from my lab:
>
> SQL> _at_ash/dashtop event*2 *"event='buffer busy waits'" sysdate-90 sysdate
>
> Total
> Seconds AAS %This EVENT2
> --------- ------- ------- ---------------------------------------------
> 38360 .0 88% buffer busy waits [*data block*]
> 4680 .0 11% buffer busy waits [*undo data*]
> 540 .0 1% buffer busy waits [*undo header*]
> 130 .0 0% buffer busy waits [*file header block*]
>
>
>
> Also the *[ktspsc_segmon] submitted segfix task* messages in your
> tracefiles are interesting.
>
> SQL> SELECT description FROM x$ktsjtaskclass ORDER BY 1;
>
> DESCRIPTION
> ----------------------------------------------------------------
> AIM scheduler
> Affinitize segment for IM Hash Index
> CLISLAVE
> DROPTEMP
> ...
> SEG DICT UPDATE
> SYSAUX FILE OFFLINE CHECK
> SYSAUX FILE ONLINE CHECK
> *Segment Fixstate*
> Segment Monitor
> ...
>
> Indeed there's a KTSJ task class called "Segment Fixstate", so maybe
> Oracle's autonomously fixing something under the hood :)
>
> --
> Tanel
> https://tanelpoder.com
>
>
-- http://www.freelists.org/webpage/oracle-l