ITPub博客

一、DBA_TABLESPACE_USAGE_METRICSDBA_TABLESPACE_USAGE_METRICS describes tablespace usage metrics for all types oftablespaces, including permanent, temporary, and undo tablespaces.通过这个视图可以直接查出表空间的使用率。二、V$ASM_DISKGROUP_STATV$ASM_DISKGROUP_STAT displays performance stati...

Tue Feb 28 15:30:06 2017Errors in file /u01/app/oracle/diag/rdbms/cwgkavpd/cwgkavpd1/trace/cwgkavpd1_ora_165303.trc:ORA-00604: error occurred at recursive SQL level 1ORA-01438: value larger than specified precision allowed for this columnORA-06512: at line 2参见MOS文档：1275094.1由于登...

vi /etc/sysconfig/oracleasmoracleasm_scanorder="emc"或oracleasm_scanorder="sdllm"ps -ef | grep LOCAL=NO|grep -v grep|awk '{print $2}'|xargs kill -9srvctl stop instance -d CWGKVPD -i CWGKVPD2srvctl stop instance -d SGHRDB -i SGHRDB2crsctl stop crs /etc/init.d/oracleasm startv...

ASM接触了很长时间，从磁盘组中删除磁盘的操作还是第一次。  没想到这么简单的操作，由于不熟悉还碰到了两个小问题。[oracle@dbserver1 ~]$ sqlplus / as sysdbaSQL*Plus: Release ...

参见官方文档Performance Tuning Guide搜索block关键字

错误如下：[grid@ora1 ~]$ srvctl start database -d testPRCR-1079 : Failed to start resource ora.test.dbCRS-5017: The resource action "ora.test.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENERORA-00132: syntax error or unresolve...

今天有个10g库检修，由于关闭crs速度太慢，杀掉了cssd进程，导致一个节点重启，重启后发现crs未自启动，之后查看OCR报如下错误OCR initialization failed accessing OCR device: PROC-26: Error while accessing the physical storage 由于是AIX系统，后经分析是hacmp未启动所致，启动hacmpsmit hacmp启...

错误日志：ORA-20115: datapump export encountered error: ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP('AW$EXPRESS','SYS',1,2,0,'SYS',1,'11.02.00.04.00',newblock) ORA-04063: package body "SYS.DBMS_CUBE_EXP" ha s errors...

concepts:Oracle Database enables you to transport AWR data between systems. This is useful in cases where you want to use a separate system to perform analysis of the AWR data. To transport AWR data, you must first extract the AWR snapshot data from the database on the source system, then load...

操作系统：AIX5.3数据库版本：10.2.0.4.12一、11月27日 11：40到11月28日 6：00做undo数据文件转储，命令如下：run {allocate channel c1 type 'sbt_tape';allocate channel c2 type 'sbt_tape';allocate channel c3 type 'sbt_tape';allocate channel c4 type 'sbt_tape';set newname for datafile 714 to '+YYJC...

在使用nohup进行循环插入的过程中，如果发现在即插入的数据不对想要重新执行的时候，仅仅kill掉nohup进程是不行的，还需要通过v$session,v$process,v$sql查询到其发出的SQL命令，查出spid，并kill掉这个进程才可以，否则这个sqlplus的循环会一直跑下去，如果这时再起一个nohup的循环插入进程脚本的话，就会出现重复数据，...

oraInventory没有写权限chmod -R 774 ./oraInventory

将数据库启动到mount状态，将现有的控制文件trace出来，修改之后在sqlplus中运行此SQL即可

Health Monitor provides two ways to run health checks manually:By using the DBMS_HM PL/SQL packageBy using the Enterprise Manager interface, found on the Checkers subpage of the Advisor Central pageRunning Health Checks Using the DBMS_HM PL/SQL PackageThe DBMS_HM procedure for running a...

错误原因：由于操作系统没有开启默认共享，导致Oracle无法检查环境可用性解决方法：1、在运行中（或键盘按 Win+R）输入regedit打开注册表，找到HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesLanmanServerParameters 选中Parameters，在右边名称中找到AutoShareWks 项，在其右键菜单中 ，点击修改，将其“数值数...

database buffer cache 通过db_cache_size和SGA_target来控制。默认值：If SGA_TARGET is set: If the parameter is not specified, then the defaultis 0 (internally determined by the Oracle Database). If the parameter isspecified, then the user-specified value indicates a minimum value forthe memory ...

You can use the information in the CHAINED_ROWS table to reduce or eliminate migratedand chained rows in an existing table. Use the following procedure.1. Use the ANALYZE statement to collect information about migrated and chainedrows. ANALYZE TABLE order_hist LIST CHAINED ROWS;2. Quer...

 建立计划任务，实现自动备份 1. 开启块跟踪 [oracle@aix213 ~]$sqlplus / as sysdba  SQL*Plus:  Release  10.2.0.1.0  -  Production  on  Tue  Jun  17 14:24:48 2014  Copyright (c) 1982, 2005, Oracle.  All rights ...

Running the rootcrs.pl command flags -deconfig -force enables you todeconfigure Oracle Clusterware on one or more nodes without removing installedbinaries. This feature is useful if you encounter an error on one or more cluster nodesduring installation when running the root.sh command, such as...

1、网站oracle数据（192.168.4.17）（月中需要清理） 1）数据内容：    中国标准服务网网站数据库，包括开发的网站用户及订单系统数据、网站信息发布系统trswcm的数据及专家系统数据。 2）存放位置192.168.4.17：/disk/backup/oracle_backup/10.3.1.1：/oracle/expdata/new_expdata/下对应的月份...