- 博客(80)
- 资源 (3)
- 收藏
- 关注
原创 表空间优化
SQL> select file_name, bytes/1024/1024/1024 gb , tablespace_name ,AUTOEXTENSIBLE from dba_data_files;FILE_NAME GB TABLESPACE_NAME AUT---------------------------------------------
2015-12-29 16:15:55 431
原创 数据泵按用户迁移
一. 导出数据(源环境)1. 创建目录:# mkdir -p /u01/datadump# chown oracle:dba /u01/datadump# su – oracle$ sqlplus "/as sysdba"SQL> create directory datapump as '/u01/datadump'; 2. 导出文件:$
2015-12-28 10:14:30 775
原创 dbms_metadata.get_ddl
SQL> set long 1000SQL> select dbms_metadata.get_ddl('TABLESPACE','PMMS_DATA') from dual; DBMS_METADATA.GET_DDL('TABLESP----------------------------------------------------------------------------
2015-12-26 11:34:34 363
原创 获取表空间定义
SELECT CASE WHEN (SELECT MIN(1) FROM sys.dba_data_files WHERE tablespace_name = ddf.tablespace_name AND file_id < ddf.file_id) = 1 THEN
2015-12-26 10:27:03 669
原创 ipcs
[root@node1 oracle]# ipcs------ Shared Memory Segments --------key shmid owner perms bytes nattch status 0x74030385 1835008 root 600 4 0
2015-12-23 14:12:11 529
原创 Inventory
Inventory 是Oracle 安装工具OUI用来管理Oracle 安装目录的。Inventory里注册了某个ORACLE_HOME 下安装的数据库的组件及其版本。Oracle 数据库软件的升级、增删组件,都需要使用Inventory。。在一台服务器上,Oracle OUI 会创建一个全局的Inventory,全局Inventory 的目录在oraInst.loc 文件中指定。oraIns
2015-12-23 13:05:49 610
原创 V$STATISTICS_LEVEL
V$STATISTICS_LEVELV$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.ColumnDatatypeDescriptionSTATISTICS_NAMEVAR
2015-12-22 21:59:32 534
原创 atch: shared pool 优化探索
首先来看赤裸裸的问题直击:Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Classlatch: shared pool1,59220.
2015-12-22 16:55:27 820
原创 dstat
如果系统没有些工具 yum -y install dstat安装下即可常用参数:-c cpu,显示CPU系统占用,用户占用,空闲,等待,中断,软件中断等信息-C 当有多个CPU时候,此参数可按需分别显示cpu状态e.g -C 0,1 显示cpu0和cpu1的信息-d disk,显示磁盘读写数据大小-D hda and total-n net 显示网络状态-N net
2015-12-22 16:03:26 659
原创 v$session_wait
SQL> select sid,event,p1,p1raw from v$session_wait where event not like 'SQL*Net%'; SID EVENT P1 P1RAW---------- ---------------------------------------------------------------- --
2015-12-22 15:28:57 1075
原创 v$sqlarea
SQL> desc v$sqlarea; Name Null? Type ----------------------------------------- -------- ---------------------------- SQL_TEXT VARCHAR2(1000) SQL_FULLTEXT CLOB SQL_ID
2015-12-22 14:34:09 617
原创 V$LATCH
SQL> set linesize 80SQL> desc v$latch Name Null? Type ----------------------------------------- -------- ---------------------------- ADDR RAW(8) LATCH# NUMBER LEVEL#
2015-12-22 12:50:43 451
原创 awr ash 等报告收集总结
@?/rdbms/admin/awrgrpt.sql Rac 收集@?/rdbms/admin/awrrpt.sql 2个时间段对比@?/rdbms/admin/awrddrpt.sqlSQL> @?/rdbms/admin/ashrpt.sql Defaults to -15 minsEnter value for begin_time: 12/21/15
2015-12-22 12:43:39 833
原创 Exadata 的诊断工具之 sundiag.sh
每个Exadata的数据库服务器和存储服务器节点都安装了sundiag.sh脚本(MOS:761868.1)我们执行下:[root@erpdb01 oracle.SupportTools]# sh sundiag.shOracle Exadata Database Machine - Diagnostics Collection ToolGathering Linux inform
2015-12-21 16:18:12 3767
原创 ORA-12012: error on auto execute of job;PLS-00306: wrong number or types ofarguments in call to
alert日志报错信息如下:报错信息比较密集 这里就看这一个Tue Dec 15 03:00:02 2015Errors in file /u01/PROD/oracle/diag/rdbms/prod/PROD1/trace/PROD1_j002_54544.trc:ORA-12012: error on auto execute of job 546ORA-06550: lin
2015-12-21 14:23:12 2747
原创 'library cache lock' Waits: Causes and Solutions
好吧 再去细细读读官档 'library cache lock' Waits: Causes and Solutions (文档 ID 1952395.1)转到底部
2015-12-21 12:35:50 734
原创 ORA-16957: SQL Analyze time limit interrupt
巡查alert发现如下报错:Wed Dec 09 22:16:37 2015Errors in file /u01/PROD/oracle/diag/rdbms/prod/PROD1/trace/PROD1_j000_75313.trc:ORA-16957: SQL Analyze time limit interruptWed Dec 09 23:00:08 2015End
2015-12-21 11:09:49 4901
原创 Node Eviction due to OLOGGERD High CPU
1、从网上下载了iopp.c,编译 gcc -o iopp iopp.c,运行该命令iopp -c -i -k -u 2发现ologgerd进行磁盘IO很高,该进程是CHM(Cluster Health Monitor)导致的,CHM是Oracle11g的新特性,主要用来收集节点上的负载信息,网上说是bug,再没有更好的处理方式下先关闭。2、关闭CHMNode Eviction d
2015-12-21 09:02:27 850
原创 位图索引 Bitmap index
1) 原理一个键值对应很多行(rowid), 格式:键值start_rowid end_rowid 位图2) 适用场合列的基数很少,可枚举,重复值很多,数据不会被经常更新3) 优点OLAP 例如报表类数据库重复率高的数据特定类型的查询例如count、or、and 等逻辑操作因为只需要进行位运算即可得到我们需要的结果4) 缺点不适合重复率低的字段,还有经常DML 操作
2015-12-20 11:01:15 1070
原创 临时表空间优化
查看当前临时表空间:SQL> select PROPERTY_VALUE from database_properties where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';PROPERTY_VALUE----------------------------------------------------------------------
2015-12-18 17:16:27 534
原创 ORA-27603: Cell storage I/O error, I/O failed on disk ORA-27626: Exadata error:
Thu Nov 05 09:30:41 2015Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD2/trace/PROD2_lmon_68224.trc:ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168
2015-12-18 13:04:41 4930
原创 ORA-959 signalled during: drop tablespace
Mon Nov 09 12:09:18 2015drop tablespace PROD1_IAS_IAU including contents and datafilesORA-959 signalled during: drop tablespace PROD1_IAS_IAU including contents and datafiles...Mon Nov 09 12:0
2015-12-18 13:01:49 1836
原创 ORA-27603: 单元存储 I/O 错误, I/O 在磁盘 o/192.168.10.5/DATA_ERP_CD_04_erpcel03 上失败, 偏移量 39441686528 (数据长度 81
Thu Nov 05 08:30:01 2015Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD2/trace/PROD2_ora_124662.trc:ORA-27603: 单元存储 I/O 错误, I/O 在磁盘 o/192.168.10.5/DATA_ERP_CD_04_e
2015-12-18 12:57:06 1938
原创 on critical error ORA-48113 caught whilewriting to trace metadata file
Non critical error ORA-48113 caught whilewriting to trace metadata file (.trm)Trace file name:"/u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD1/trace/PROD1_ora_68773.trc"Error message:Writing to trace metadata is disabled fornow on...
2015-12-18 10:25:40 5063
原创 Exadata HealthCheck
HealthCheck是Oracle开发的用于对Exadata配置进行验证的一套脚本。可参考文档ID 1070954.1oracle推荐定期运行HealthCheck脚本并与oracle公司公布的参数进行对比,以保证一体机的最佳性能和可管理性。健康检查是不会影响业务的除了脚本CheckHWnFWProfile外都可以在业务运行时进行。脚本CheckHWnFWProfile平时也不需
2015-12-17 17:21:51 1086
原创 Exadata 的网络概述
Exadata中网络类型主要分为管理网络, 访问网络public,私有网络管理网络Exadata中提供管理访问的新网络即管理网络,这样就能把管理访问和数据库访问分离起来当然你可以直接由root用户ssh的管理端口[root@erpdb01 ~]# ssh root@10.19.3.131Last login: Wed Aug 12 21:04:29 2015 frome
2015-12-17 09:59:13 1283
原创 Exadata X3-2 存储服务器BBU 更换
实施方案:1.检查ASM状态 SQL> select dg.name,a.value from v$asm_diskgroup dg, v$asm_attribute a where dg.group_number=a.group_number and a.name='disk_repair_time';确认header_status都是MEMBER,mount_status 都是 C
2015-12-17 09:29:41 2769
原创 扩大online redo增加日志组
现在的大小为50M,改为300M切换也比较频繁添加比较简单:alter database add logfile group 4 '/u01/oracle/oradata/appserv/redo04.log' size 300malter database add logfile group 5 '/u01/oracle/oradata/appserv/redo0
2015-12-16 09:07:31 694
原创 oracle 失效对象
SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*)----------19SQL>SQL> col owner for a10SQL> select owner, object_name, object_type from dba_objects where status='
2015-12-14 14:26:34 5704
原创 CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2015-12-14 11:17:31 8934
原创 62 You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a
62You have enabled backup optimization in RMAN. You issue the following RMAN command to configure aredundancy-based retention policy:CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Which statement
2015-12-13 14:01:59 644
原创 49 You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DAT
49You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATA
2015-12-11 17:19:49 721
原创 44 You want to enable resumable space allocation at the instance level. Which two actions would enab
44You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? (Choose two.)A. issuing the ALTER SYSTEM EN
2015-12-11 17:10:45 906
原创 41 Which statements are true regarding table compression? (Choose all that apply.) A. It saves disk
41Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It
2015-12-11 16:18:33 914
原创 40 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
40For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed
2015-12-11 16:16:07 669
原创 37 In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply
37In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)A. partitioning recommendationsB. statistics collection recommendationsC. index creation re
2015-12-11 15:59:59 493
原创 34 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A.
34Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database files are co
2015-12-11 12:42:38 732
原创 31 Which of the following is a benefit of ASM fast disk resync? A. Failed disks are taken offline im
31Which of the following is a benefit of ASM fast disk resync?A. Failed disks are taken offline immediately but are not dropped.B. Disk data is never lost.C. By default, the failed disk is not
2015-12-11 10:55:00 1385
Oracle 9i_10g编程艺术:深入数据库体系结构
2016-01-05
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人