-
编辑 删除
view about redo&undo
关于redo&undo的几个动态性能视图...... select a.value from v$mystat a, v$statname b where a.statistic# = b.statistic# and b.name = 'redo size';V$ROLLSTATUSN: Rollback segment number RSSIZE: Current...
-
编辑 删除
Buffer pool and alter table cache
我们都知道：oracle有3中buffer pool1. default pool2. keep pool3. recycle pool对于这三种pool,是基于block的热度来进行管理的,系统默认使用的,就用default pool了,还有一些热块,居于其次的,就放到keep pool,...
-
编辑 删除
dbms_profiler
从oracle8i开始oracle提供dbms_profiler包来收集pl/sql块执行情况,通过分析收集的数据进而找到pl/sql的瓶颈......dbms_profiler安装: 1. @%oracle_home%rdbmsadminprofload as sys 2. @%oracle_home%rdb...
-
编辑 删除
在oracle系统中普遍存在的十大错误
Top Ten Mistakes Found in Oracle SystemsThis section lists the most common mistakes found in Oracle systems. By following Oracle's performance improvement methodology, you should be able to avoid thes...
