shared pool KGLH0 19496600 shared pool row cache 7593704 shared pool PLMCD 6275624 18:08:07 sys@felix SQL> 1.4.3 SGA 与共享内存 SGA的设置在Linux/Unix上和一个操作系统内核參数有关,这个參数是:shmmax。不同操作系统,该參数设置的位置不同,在Solaris 上,该參数由/etc/system 文件里shmsys:shminfo_s...
shared pool KGLH0 19496600 shared pool row cache 7593704 shared pool PLMCD 6275624 18:08:07 sys@felix SQL> 1.4.3 SGA 与共享内存 SGA的设置在Linux/Unix上和一个操作系统内核參数有关,这个參数是:shmmax。不同操作系统,该參数设置的位置不同,在Solaris 上,该參数由/etc/system 文件里shmsys:shminfo_s...
shared pool kwqicaqe2kc1 17616 3 shared pool PRTDS 12144 3 shared pool parameter table block 31832 3 shared pool KGLH0 5049432 3 shared pool KGLNA 136 3 shared pool call 15320 3 shared pool free memory 54148480 0 shared pool KCB tablespace encryption 1440 3 shared pool SQLP 333544 3 sha...
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^b4ca6859","kglHeapInitialize:temp") ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","FACILITY","KGLH0^e3a2d601",...
Some paramters need to be adjusted but nothing that would explain why all of a sudden KGLH0 would use up to 1 GB of memory ... We checked the size of the shared pool area as descibed here : 690241 - The Shared SQL Area in the Shared Pool and large SQL Stmnts It is not...
但无论是从SQL历史记录视图(Workload Repository)还是v$SQL中都无法找到该条语句,可以判断该问题进程最后也没能成功完成对该'bp7y9fvtqra1h'语句的解析!因为没有该SQL的记录,所以也无法了解该SQL的执行计划和workarea工作区的使用状况,线索再次断裂! SQL> select * from dba_hist_sqltext where sql_id='bp7y...
Free Buffer Waits: 等待空闲缓冲的次数, 可以看做该buffer pool 发生free buffer waits 等待的次数 Write Comp Wait: 等待DBWR写入脏buffer到磁盘的次数, 可以看做该buffer pool发生write complete waits等待的次数 Buffer Busy Waits: 该缓冲池发生buffer busy wait 等待的次数 ...
SQL> create index ind_XIFENFEI_LOG_null on XIFENFEI_LOG (CLEAR_TIME,0) online; Index created. 再次查看执行计划 SQL> WITH AL AS (SELECT * FROM XIFENFEI_LOG WHERE CLEAR_TIME IS NULL) 2 SELECT SWP.ID SWP_ID, AL.* FROM AL FULL OUTER JOIN XIFENFEI_LOG_SWAP SWP ON SWP.ID = AL.ID...
Write Comp Wait: 等待DBWR写入脏buffer到磁盘的次数, 可以看做该buffer pool发生write complete waits等待的次数 Buffer Busy Waits: 该缓冲池发生buffer busy wait 等待的次数 7-1 Checkpoint Activity 检查点与 Instance Recovery Stats 实例恢复 CheckpointActivitySnaps:70719-70723->TotalPhysicalWrites:590,563Other...
Parse CPU to Parse Elapsd % : 该指标反映了快照内解析 CPU 时间和总的解析时间的比值 (Parse CPU Time/ Parse Elapsed Time) ; 若该指标水平很低,那么说明在整个解析过程中 实际在 CPU 上运算的时间是很短的,而主要的解析时间都耗费在各种其他非空闲的等待事件上了 ( 如 latch:shared pool,row cache loc...