sustwct的专栏

数据库版本11.2.0.1用户反映修改密码后程序明显变慢:查看AWR发现:Top 5 Timed Foreground EventsEventWaitsTime(s)Avg wait (ms)% DB timeWait Classrow cache lock24,37846,231

查询 PGA 性能指标： select name,value,100*( value     /decode((select sum(value) from v$sysstat     where name like 'workarea executions%'),0,null,     (select sum(value) from v$sysstat

http://www.cnblogs.com/william-lee/archive/2010/12/08/1900176.html

sys通过授予select_catalog_role角色给用户，使用户有权限查询数据字典。引：深入解析Oracle：DBA入门、进阶与诊断案例

SQL> select dbms_flashback.get_system_change_number from dual;GET_SYSTEM_CHANGE_NUMBER------------------------                17076934

转储控制文件alter session set events 'immediate trace name controlf level 8';默认存放位置select * from v$diag_info;1 Default Trace File/u01/app/oracle/diag/rdbms/dbbox/dbbox1/trace/dbbox1_ora_2897

例：删除7天前的归档日志RMAN>delete archivelog until time 'sysdate-7' ;

http://blog.youkuaiyun.com/zhangtian0913/article/details/3876881http://blog.sina.com.cn/s/blog_48fbecd00100031u.html

http://hi.baidu.com/jacklin/item/528fdbc900de18165150587d

http://blog.youkuaiyun.com/tianlesoftware/article/details/8532090http://www.linuxidc.com/Linux/2013-01/78399.htmAlert log 出现如下错误：Errors in file /oracle/11.2.0.3/oracle/diag/rdbms/fssms

http://www.xifenfei.com/1760.html在Oracle 11g中如果采用AMM内存管理，那么当MEMORY_TARGET的值大于/dev/shm的时候，就会报ORA-00845: MEMORY_TARGET not supported on this system错误，解决办法增加/dev/shm大小，在redhat系列系统中，/dev/shm的默

http://www.cnblogs.com/huyong/archive/2011/05/04/2036377.html#!comments

http://blog.youkuaiyun.com/leshami/article/details/8904804

rowid 伪列AAAB6J                       AAF                       AAAAAF                       AAA段对象编号          相对文件编号          表示在哪个快上        这个块上的行相对文件编号在表空间里计数绝对文件编号在数据库中统计计数row

select * from dba_hist_wr_control;SNAP_INTERVAL 默认每隔1小时收集一次，retention保留7天exec dbms_workload_repository.modify_snapshot_settings(retention=>14400,interval=>30);

http://gaozhifei.blog.51cto.com/4108324/1144520查看session与process数select count(*) from v$session union select count(*) from v$process where pid

数据库系统中的表和视图select * FROM DICT 参数的有效取值SELECT * FROM V$PARAMETER_VALID_VALUES

RAC环境下undo_tablespace是不同的，修改时要注意。select sid,name,value from v$spparameter where name='undo_tablespace';dbbox1 undo_tablespaceUNDOTBS1dbbox2 undo_tablespaceUNDOTBS2

查看行争用的等待sessionselect * from gv$session_wait where wait_class select inst_id,sid,seconds_in_wait from gv$session_wait where wait_class 查看阻塞与被阻塞的sessionselect * from gv$session where (sid=1

检测坏块http://www.eygle.com/archives/2005/06/eoadbvirmanieei.html

五．如何查找坏块所含的数据表名称和数据的rowid5.1. 首先肯定知道那个数据文件坏了，查出该文件的file_id,relative_fno,tablespace_name   利用dba_data_files可以查询file_id(整个数据库唯一序号),RELATIVE_FNO(相对一个表空间内的序号) 5.2. 找到坏块的ID（可以运行dbverify实现），假设

http://www.eygle.com/archives/2006/09/undo_retention_need_change.html

总体安装上与其它linux上没有太大的区别1.在安装时根据提示运行的脚本/oracleDisk/Disk1/rootpre/rootpre.sh时报以下错误，可以先跳过，不影响安装（关于异步IO设置)Configuring Asynchronous I/O....Asynchronous I/O is not installed on this system.You w

http://blog.youkuaiyun.com/wyzxg/article/details/8473713

http://www.cnblogs.com/mchina/archive/2013/03/08/2934473.html

http://www.eygle.com/faq/How.To.Backup.and.Recreate.Controlfile.htmhttp://www.xifenfei.com/1472.html

检查表空间是否符合以表空间传递的方式导出exec dbms_tts.transport_set_check('TBS_NAME',TRUE);select * from transport_set_violations;

http://book.51cto.com/art/201108/281163.htm

MAX_UTILIZATION代表数据库自上次启动以来达到的最大值，LIMIT_VALUE代表设置的最大值select resource_name,MAX_UTILIZATION,LIMIT_VALUE from v$resource_limit where resource_name in ('processes','sessions');

实验过程做些参考http://tech.ddvip.com/2013-11/1384870190206202.html

http://www.2cto.com/database/201309/246856.html

create or replace procedure proc1asbegin          for i in 1..100000          loop          execute immediate            'insert into t values('||i||')';           commit;           en

http://www.eygle.com/archives/2011/11/oracle_block_header.html

11g下编译bbed报错，查找了下面的解决方法，目前没有10g环境，先mark下http://www.educity.cn/develop/553495.html

某日全天的日志生成统计：select trunc(completion_time),sum(Mb)/1024 day_gb from (select name,completion_time,blocks*block_size/1024/1024 Mb from v$archived_log wherecompletion_time between trunc(sysdate)-2 a

create index ind_1 on  test(id);select object_id from dba_objects where object_name='IND_1';11743将索引dump出来alter session set events  'immediate trace name treedump level 11743'

在oracle数据库中查看当前连接的session的idSQL> select  distinct sid from v$mystat;       SID----------       145通过session的id查出数据库进程地址SQL>  select paddr from v$session where sid=145;PAD

11gr2卸载1.清除操作系统环境变量d:\app\oracle\product\11.2.0\dbhome_1\bin2.清除注册表regedita.HKEY_LOCLAL_MACHINE\SOFTWARE\ORACLEb.HKEY_LOCLAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle*3.

按照以下链接的方法解决了，在此做个记录。http://www.luocs.com/archives/464.html