數(shù)據(jù)庫開發(fā)規(guī)范-資料下載頁
2025-07-26 11:19本頁面
【正文】 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (FULL) OF 39。WCATTORI39。統(tǒng)計 0 recursive calls 12 db block gets 4 consistent gets 0 physical reads 0 redo size 4779 bytes sent via SQL*Net to client 314 bytes received via SQL*Net from client 1 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 0 rows processed SQL TKPROF 初始化@afe57gc2/oracle/product/ 40 sqlplus /SQL ALTER SESSION SET TIMED_STATISTICS = true。SQL ALTER SESSION SET MAX_DUMP_FILE_SIZE = 500。 SQL Trace開始SQL ALTER SESSION SET SQL_TRACE = true。 實例SQL SELECT * FROM WCATTORI。 SQL Trace結(jié)束SQL ALTER SESSION SET SQL_TRACE = false。SQL exit 內(nèi)容變換@afe57gc2/users/home/ino 44 suPassword: chmod 777 /oracle/product/ exit@afe57gc2/users/home/ino 46 tkprof $ORACLE_HOME/rdbms/log/ TKPROF: Release Production on 木 Apr 18 15:55:17 2002(c) Copyright 2000 Oracle Corporation. All rights reserved.備考：ログファイルの出力先SQL column name format A20SQL column value format A30SQL select name, value from v$parameter where name like 39。%dump_dest39。NAME VALUE background_dump_dest ?/rdbms/loguser_dump_dest ?/rdbms/logcore_dump_dest ?/dbsSQL 內(nèi)容確認(rèn)@afe57gc2/users/home/ino 47 cat (一部抜粋)SELECT *FROM WCATTORIcall count cpu elapsed disk query current rows Parse 1 0 0 0 0Execute 1 0 0 0 0Fetch 1 0 4 12 0 total 3 0 4 12 0Misses in library cache during parse: 0Optimizer goal: CHOOSEParsing user id: 34Rows Row Source Operation 0 TABLE ACCESS FULL WCATTORI15
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1