神通数据库神州通用数据库导入导出及运维常用命令

#查看备份大小

osrimp -q file=该文件

查看数据库编码字符集

select *,sys_encoding_to_char (encoding) from v_sys_database;

查看当前会话

select * from v_sys_sessions;

--检查数据库 SQL 是否存在堵塞问题、排队、锁
SELECT C.SESSION_ID, C.BLOCKER_IS_VALID, C.WAIT_EVENT, C.BLOCKER_PID, C.BLOCKER_SESSION_ID, S.SQL_EXEC_START,
S.SQL_EXEC_START::TIMESTAMP-SYSDATE::TIMESTAMP "EXPEND TIME",
SUBSTR(S.CURRENT_SQL, 0, 60) CURRENT_SQL,
SUBSTR(S.PREV_SQL, 0, 60) PREV_SQL
FROM V$SESSION S, V$WAIT_CHAINS C WHERE C.SESSION_ID = S.SID ORDER BY BLOCKER_IS_VALID;

--通过下述视图查看等待源和等待者正在执行的 sql 语句
SELECT
PATH,SESSION_ID,BLOCKER_SESSION_ID,WAIT_ID,WAIT_EVENT,P1,P1_TEXT,P2,P2_TEXT,P3,P3_TEXT,P4,P4_TEXT,NUM_WAITERS FROM (
SELECT LEVEL, SYS_CONNECT_BY_PATH (SESSION_ID,'>') AS PATH, * FROM
V$WAIT_CHAINS
START WITH BLOCKER_SESSION_ID IS NULL
CONNECT BY PRIOR SESSION_ID = BLOCKER_SESSION_ID)
ORDER BY "LEVEL", PATH;

查看数据库详细版本 

select versiondetail;