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_waited WAIT_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 kept 2、The table strcture to be changed 3、Movement to another tablespace 4、The command to be parallel

alter session set query_rewrite_enabled = true; alter session set query_rewrite_integrity = enforced; create create materialized view my_all_objects_aggs build immediate refresh on commit enable

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

[root@rac1 ~]# ip ad sh 1: 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_histogram where 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_level NAME

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 -global en0  172.16.14.0  global  public en3  1.1.14.0  global  cluster_interconnect root@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