ITPub博客

---查询oracle用户的用户组[root@rhel5 ~]# id oracleuid=502(oracle) gid=102(oinstall) groups=102(oinstall),103(dba)---给新建的卷组vg2授权[root@rhel5 ~]# chown -Rf oracle:oinstall /dev/vg2[root@rhel5 ~]...

----oracle后台进程-bash-3.2$ ps -ef|grep ora_oracle    4079     1  0 04:30 ?        00:00:05 ora_pmon_zxyoracle  &n...

---正常关库SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> --正常关库的alert logFri Jun 21 04:26:47 2013Shutting down instance (immediate) --正常关闭Stopping...

---128457为操作系统的块个数;os block size为512byte[root@rhel5 ~]# blockdev --getsize /dev/sdd1128457 ---上述分区的大小[root@rhel5 ~]# fdisk -l /dev/sdd1Disk /dev/sdd1: 65 MB, 65769984 bytes25...

---library cache:mutex x--library cache:mutex x产生的原因What causes 'library cache: mutex X' wait?1,Frequent Hard Parses - If the frequency of Hard Parsing is extremely high, then contention can oc...

http://space.itpub.net/9240380/viewspace-755752

----测试参数与parse_calls及executions的关系----修改此参数要重启数据库SQL> show parameter session_cachedNAME               &n...

http://www.vsyo.com/a/t/564315e804771418

---查询cursor_sharing目前值及可选值SQL> select name,value,isdefault from v$parameter_valid_values where name like '%cursor_sharing%'NAME          &nb...

--必须以创建job用户删除job，不然报ora-23421,任务不在任务列表中sqlplus wisdomone/systemspool /oracle/deletejob.sql--生成批量删除job脚本select 'exec dbms_job.remove('||job||');' from dba_jobs where sc...

--测试version_count相关原因--业务会话SQL> conn scott/systemConnected.SQL> create table t_version(a int);Table created.SQL> select count(1) from t_version;  COUNT(1)----------  &nbsp...

http://www.eygle.com/archives/2010/01/rman_validate_backup.html

http://hpux.connect.org.uk/hppd/hpux/Sysadmin/tusc-8.1/

http://blog.chinaunix.net/uid-8504518-id-3491104.html

http://www.linuxidc.com/Linux/2012-07/66514.htm

http://wenku.baidu.com/view/672fac2fb4daa58da0114a08.html

1,新增存储或虚拟硬盘2,fdisk 新盘3,以root对新盘配置权限     chown oracle:oinstall /dev/sdc1 --/dev/sdc1为新盘分区后的设备文件名     chmod 777 /dev/sdc14,su ...

http://blog.csdn.net/tianlesoftware/article/details/5467273

http://junfengwang060905.blog.163.com/blog/static/94223330201161412546791/

----备份数据文件5-bash-3.2$ rman target sys/systembackup datafile 5 format '/oracle/rmanbackup/backupwisdomone.dbf';----恢复数据文件5到新的位置-bash-3.2$ rman target sys/systemRecovery Manager: Rele...