[it認(rèn)證]oracle診斷案例-sql_trace-在線瀏覽
2024-10-01 13:41本頁(yè)面
【正文】 問(wèn)在前臺(tái)點(diǎn)擊相關(guān)頁(yè)面,同時(shí)進(jìn)行進(jìn)程跟蹤查詢(xún)v$session視圖,獲取進(jìn)程信息sql select sid,serial,username from v$session。sql exec (7,284,true)pl/sql procedure successfully exec (11,214,true)pl/sql procedure successfully exec (16,1042,true)pl/sql procedure successfully select sid,serial,username from v$session。sql exec (7,284,false)pl/sql procedure successfully exec (11,214,false)pl/sql procedure successfully exec (16,1042,false)pl/sql procedure successfully pleted. 檢查發(fā)現(xiàn)以下語(yǔ)句是可疑的,檢查相應(yīng)表結(jié)構(gòu)index_name table_name column_name idx_articleid categoryarticleassign articleidind_articleid_categ categoryarticleassign articleid ind_articleid_categ categoryarticleassign categoryid idx_sortid categoryarticleassign sortid pk_categoryarticleassign categoryarticleassign articleid pk_categoryarticleassign categoryarticleassign categoryid pk_categoryarticleassign categoryarticleassign assigntype idx_cat_article categoryarticleassign auditstatus idx_cat_article categoryarticleassign articleid idx_cat_article categoryarticleassign categoryid idx_cat_article categoryarticleassign assigntype 11 rows selected. 我們注意到,idx_articleid索引在以上查詢(xún)中都沒(méi)有被用到.檢查表結(jié)構(gòu):sql select auditstatus,categoryid 2 from 3 categoryarticleassign where articleid=20030700400132。********************************************************************************select unpass from categoryarticleassign where articleid=20030320000682 and categoryid=113 call count cpu elapsed disk query current rows parse 1 0 0 0 0execute 1 0 0 0 0fetch 1 0 2 0 0 total 3 0 2 0 0misses i
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1