Library cache lock等待的故障分析.pdf

311

2页

1次

2021-02-22

40墨值下载

Library cache lock󰑒



󰏰󰓍

1.1 10:0610:34󰑟󰂈󰈱󰀪2285.4737󰈰session󰐦

library cache lock󰈰P3100506529759235(0x5B69 0001 0003)0003

󰃕󰈱󰁞󰃘library cache lock5B69object_id, 󰈰object_id

objectEPAY.B2C_PAY_TRANFLOW

1.2 SEQ#󰃕󰈰

SQL> select owner,object_name, object_type from dba_objects where

object_id=23401;

OWNER OBJECT_NAME OBJECT_TYPE

----------- -------------------- -----------------

EPAY B2C_PAY_TRANFLOW TABLE

1.3 󰀉SQL󰑟󰂈procedure

SQL> select sql_text from v$sql where sql_id='b6usrg82hwsa3';

SQL_TEXT

--------------------------------------------------------------------------------

call dbms_stats.gather_database_stats_job_proc ( )

...

1.4 󰐦󰈱2285.4737󰀉B2C_PAY_TRANFLOWsql tuning adviser

1.5 󰈰󰏰󰓍SQL tuning AdviserEPAY.B2C_PAY_TRANFLOWlibrary

cache lock󰈱󰀉󰂳󰀉SQL󰃎󰑟󰂈󰈱󰑲󰁞󰈰

󰎂row cache

󰂔

󰏯sql tuning advisor:

SQL> EXEC DBMS_AUTO_TASK_ADMIN.DISABLE('SQL TUNING ADVISOR',NULL,NULL);

sql tuning advisor:

SQL> EXEC DBMS_AUTO_TASK_ADMIN.ENABLE('SQL TUNING ADVISOR',NULL,NULL);



SQL> select client_name,status from DBA_AUTOTASK_CLIENT where CLIENT_NAME='sql

tuning advisor';

of 2

40墨值下载

关注