ab學(xué)習(xí)手冊(cè)word版(編輯修改稿)
2025-04-19 13:24 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 ILO_DATEFORM =39。yyyymmdd hh24:mi:ss39。 2$vi table t1{I1 integer。I2 date “YYYYMMDD HH:MI:SS”。 1I3 date。}DATEFORM YYYY/MM/DD HH:MI:SS 3優(yōu)先級(jí)別如上面的數(shù)值Create replication rep_nameWith remote_host,port remote_host,port remote_host,portFrom to ,From to ,……..From to 。Isqlalter replication rep_name startIsqlalter replication rep_name stopIsqldrop replication rep_name。Isqlalter replication rep_name add tableFrom to 。Isqlalter replication rep_name drop tableFrom to 。A．連接數(shù)據(jù)庫(kù)的回話信息SELECT ID, REPLACE2(REPLACE2(COMM_NAME, 39。SOCKET39。, NULL), 39。SERVER39。, NULL) CONN_INFO, DECODE(ACTIVE_FLAG, 1, 39。ACTIVE39。, 39。INACTIVE39。) ACTIVE, OPENED_STMT_COUNT OPEN_STMT, CURRENT_STMT_ID CURRENT_STMT, CLIENT_PID, DECODE(PROTOCOL_SESSION, 1397051990, 39。HANDSHAKE FOR SYSDBA DISPATCH39。, 1094995278, 39。HANDSHAKE FOR USERS DISPATCH39。, 1129270862, 39。CONNECT39。, 1145652046, 39。DISCONNECT39。, 1229870668, 39。INVALID39。, 1280460613, 39。TIMEOUT39。, 1163022162, 39。ERROR39。, 1347568976, 39。PREPARE39。, 1163412803, 39。EXECUTE39。, 1162103122, 39。EXECDIRECT39。, 1179927368, 39。FETCH39。, 1179796805, 39。FREE39。, 1229931858, 39。I/O ERROR39。, 1161905998, 39。EAGAIN ERROR39。, 1480672077, 39。XA COMMANDS39。, 1094929998, 39。ACKNOWLEDGE39。, 1195725908, 39。GET39。, 39。UNKNOWN39。) PROTOCOL, DECODE(AUTOCOMMIT_FLAG, 0, 39。Non AutoCommit39。, 39。AutoCommit39。) COMMIT_MODE FROM V$SESSION。B. 按照用戶統(tǒng)計(jì)會(huì)話 每個(gè)用戶的執(zhí)行語(yǔ)句數(shù)量和狀態(tài)select , , count(*) from v$statement a, v$session b where = group by , 。輸出字段注釋： STATE The statement status: 0: Initialization status where the statement is assigned 1: Statement is prepared 2: Statement is preparing to fetch 3: Statement is performing fetchC. 通過(guò)會(huì)話查詢產(chǎn)生鎖的應(yīng)用進(jìn)程信息每個(gè)session的加鎖語(yǔ)句數(shù)量select SESSION_ID, count(*) from V$LOCK_STATEMENT group by session_id。察看一個(gè)session 是由哪個(gè)進(jìn)程產(chǎn)生的select CLIENT_PID from v$session where id = 26131。通過(guò)進(jìn)程號(hào)察看進(jìn)程信息表ps ef|grep 258666D. 看哪個(gè)session在對(duì)指定表進(jìn)行操作select , , from v$statement a, v$session b where = and query like 39。%user_bill_plan%39。E. 會(huì)話的鎖信息SELECT || 39。(39。 || || 39。)39。 as SID, , , || 39。.39。 || as TABLENAME, || 39。(39。 || || 39。)39。 as LOCK_S, FROM V$SESSION A, V$LOCK_STATEMENT B, C WHERE = AND = 。SID : Session ID(連接 IP 等信息) CLIENT_PID : 客戶端進(jìn)程號(hào) TX_ID : Transaction ID TABLENAME: 被鎖的表名 LOCK_S: 鎖的類型 QUERY : 加鎖的語(yǔ)句F. 查看每張表上的加鎖語(yǔ)句數(shù)量select table_oid, count(*) from v$lock_statement group by table_oid。G. 查看表上的鎖信息select , , , , from a, v$lock b, c where = 。H. 用戶對(duì)象信息SELECT , , DECODE(, 39。T39。, 39。TABLE39。, 39。V39。, 39。VIEW39。, 39。S39。, 39。SEQUENCE39。) OBJECT_TYPE FROM X INNER JOIN Y ON = WHERE 1UNION ALLSELECT , , 39。PSM39。 FROM X INNER JOIN Y ON = WHERE 1UNION ALLSELECT , , 39。SYNONYM39。 FROM X INNER JOIN Y ON = WHERE 1。輸出字段注釋： USER_NAME : 用戶名 TABLE_NAME : 表名 OBJECT_TYPE : 對(duì)象類型I．獲取所有表的列信息SELECT USER_NAME, TABLE_NAME, COLUMN_NAME, DECODE(, 1, 39。CHAR39。, 4, 39。INTEGER39。, 5, 39。SMALLINT39。, 5, 39。BIGINT39。, 12, 39。VARCHAR39。, 2, 39。NUMERIC39。, 6, 39。FLOAT39。, 7, 39。REAL39。, 8, 39。DOUBLE39。, 9, 39。DATE39。, 30, 39。BLOB39。, 20002, 39。NIBBLE39。, 39。UNKNOWN39。) DATA_TYPE,
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1