wanglixue2012的专栏

http://www.oracledatabase12g.com/archives/11g%e6%96%b0%e7%89%b9%e6%80%a7xdbgalertext%e4%b8%80%e4%b8%aa%e5%be%88%e9%85%b7%e7%9a%84%e5%86%85%e9%83%a8%e8%a7%86%e5%9b%be.html

select * from v$system_wait_class order by time_waitedWAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS                                                       TOTAL_WAITS TIME_WAITED TOTAL_WAITS_FG TIME_WAITED_

将SGA锁入内存，减少因为换页引发的性能瓶颈 SQL> show parameter lock_sga;NAME                                 TYPE------------------------------------ --------------------------------VALUE-----------------------

SQL> select sid,serial#,username from v$session;       SID    SERIAL# USERNAME---------- ---------- ------------------------------        13      15682 DLSCDB        18      24454 DLSCDB

解决方案一、alter system flush shared_pool解决方案二、1、首先看shared_pool的两个参数设置SQL> show parameter shared_pool;NAME                                 TYPE        VALUE------------------------------------ --

点击打开链接

select what,height,lf_blks,br_blks,btree_space,opt_cmpr_count,opt_cmpr_pctsave from idx_stat;

move table 比 exp/imp 和 create table xxx as select * from x;1、Privileges and constraints to be kept2、The table strcture to be changed3、Movement to another tablespace4、The command to be parallel

alter session set query_rewrite_enabled = true;alter session set query_rewrite_integrity = enforced;createcreate materialized view my_all_objects_aggsbuild immediaterefresh on commitenable

http://www.eygle.com/archives/2008/06/oracle_lms_process.html

[root@rac1 ~]# ip ad sh1: lo: mtu 16436 qdisc noqueue     link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00    inet 127.0.0.1/8 scope host lo    inet6 ::1/128 scope host        valid_lf

http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html

olsnodes -p -i 命令不好用

SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';Session altered.SQL> /Session altered.SQL> select sid,username,sql_exec_start,sql_exec_id from v$session where sql_exec_id is n

alter user scott account unlock;

select event,wait_time_milli,wait_count from v$event_histogramwhere event = 'latch: shared pool'; SQL> /EVENT                     WAIT_TIME_MILLI WAIT_COUNT------------------------- --------

两种方法监控SQL执行情况1、v$session_longops记录某个操作执行时间超过6秒2、v$SQL_MONITOR或者package DBMS_MONITOR来主动对SQL执行监控部署  该功能具备三个条件即可A) SQL> show parameter statistics_levelNAME

http://www.rampant-books.com/t_hunter_using_oracle_acfs_on_linux_part1.htm

http://www.oracle-base.com/articles/11g/OracleDB11gR2RACInstallationOnOEL5UsingVMwareServer2.php

http://www.oracle-base.com/articles/11g/OracleDB11gR2RACInstallationOnOEL5UsingVirtualBox.php

root@SHYQ-PS-MV-SV03-CDMPDB1:/#oifcfg getif -globalen0  172.16.14.0  global  publicen3  1.1.14.0  global  cluster_interconnectroot@SHYQ-PS-MV-SV03-CDMPDB1:/# 这个命令在11g中似乎变样了root@SHYQ-PS-M

在创建磁盘完毕后，修改VMWARE配置文件，添加如下两行数据，来修改磁盘属性disk.locking="FALSE"scsi1:1.shared = "TRUE"config.version = "8"virtualHW.version = "4"disk.locking="FALSE"scsi0.present = "TRUE"scsi0.virtua

http://www.oraclefans.cn/blog/showblog.jsp?rootid=38451