-
编辑 删除
DBA常用脚本
1.查询有enqueue等待的事件SELECT b.SID, b.serial#, b.username, machine, event, wait_time,CHR (BITAND (p1, -16777216) / 16777215)|| CHR (BITAND (p1, 16711680) / 65535) "Enqueue Type"FROM v$session_wait a, v$session bWHERE a.event NOT LIKE 'SQL*N%'AND a.event NOT LIKE 'rdbms%'AND a.SID = b.SIDAND b.SID > 8AND a.event = 'enqueue'ORDER BY username;2如何确定哪个表空间读写频繁?select name,phyrds,phywrts,readtim,writetimfrom v$filestat a,v$dbfile bwhere a.file# = b.file#order by readtim des
-
编辑 删除
在timesten中的字符集问题 5107
在timesten中的字符集问题 5107Command> create readonly cache group read_tt autorefresh interval 5 seconds from tt(a int primary key); 5107: Oracle(OCI) error in OCIStmtExecute(): ORA-06552: PL/SQL: Compilation unit analysis terminatedORA-06553: PLS-553: character set name is not recognized rc = -1The command failed.解决方法：首先检查oracle中的字符集：SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';PARAMETER--------------------------------------------------------------
