-
编辑 删除
Data Guard 和DGMGRL
db_unique_name_DGB.db_domain:service name db_unique_name_DGMGRL.db_domain: 在每个配置了broker的数据库上面都存在一个服务器进程进行 broker的管理操作，这个服务器进程就是Data Guard broker monitor（DMON），而这个DMON所用到的所有配置信息都会保留在一个配置文件中。这个DMON进程和...
-
编辑 删除
sql执行计划是否改变
select SQL_ID,SQL_PLAN_HASH_VALUE,SQL_EXEC_START from V$ACTIVE_SESSION_HISTORY;select PLAN_HASH_VALUE,FIRST_LOAD_TIME from v$sql where sql_id='bksyj647thx15'select distinct SQL_ID,PLAN_HASH_VALUE,to_char(TIMESTAMP,'yyyymmdd hh24:mi:ss') TIMESTAMPfrom dba_hist_sql_plan where SQL_ID=...
-
编辑 删除
记录数据库所有ddl操作
NAME TYPE VALUE------------------------------------ ----------- ------------------------------enable_ddl_logging boolean FALSE通过ash查询历史执行sql：V$ACTIVE_SESSION_HISTORYDBA_HIST_SQLTEXTselect s.*,b.SQL_TEXT from (select a.SAMPLE_TIME,a.sql_id &nb...
-
编辑 删除
ora 脚本
#!/bin/bashif [ "$LOGNAME" = "oracle" ]; then SQLPLUS_CMD="/ as sysdba";else SQLPLUS_CMD="/ as sysdba";ficase $1 in si) if [ "$LOGNAME" = "oracle" ]; then sqlplus "/ as sysdba" ...
-
编辑 删除
ora 脚本
#!/bin/bashif [ "$LOGNAME" = "oracle" ]; then SQLPLUS_CMD="/ as sysdba";else SQLPLUS_CMD="/ as sysdba";ficase $1 in si) if [ "$LOGNAME" = "oracle" ]; then sqlplus "/ as sysdba" ...
-
编辑 删除
How to Resize a Datafile (文档 ID 1029252.6)
In this DocumentPurposeScopeDetails =============================1. Increase Datafile Size============================= ...
-
编辑 删除
How to Resolve ORA-03297
APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.5.0 and laterInformation in this document applies to any platform.GOALIn a number of cases it is desired to shrink an oversized datafile. The challenge is then up to find to which size the datafile can be shrunk? Using the ...
-
编辑 删除
段调优顾问回收大表的分配空间和高水位线(转载)
--通过段调优顾问回收大表的分配空间和高水位线 --创建用户 SQL> create tablespace hzqtbs datafile '/u01/app/oracle/oradata/prod/hzqtbs.dbf' size 30m;Tablespace created.SQL> create user hzq identified by hzq default tablespace hzqtbs quota unlimited on hzqtbs account unlock; User created.SQL> gran...
-
编辑 删除
Buffer Cache Hit Ratio
rem rem This script uses PL/SQL. rem le hit ratio rem col global_name for A20 variable d number variable c number variable r number begin select value into :c from v$sysstat ...
-
编辑 删除
Why is no space released after an ALTER TABLE ... SHRINK?
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.SYMPTOMSAn ALTER TABLE ... SHRINK has been done and no space seems to have been releasedCAUSEMisunderstanding of how Oracle Storage worksSO...
-
编辑 删除
Running the Segment Advisor Manually
--回收表空间alter table test enable row movement; --开启行迁移功能。alter table test shrink space compact;--(可以在压缩期间进行DML操作和查询) ,收缩表，不会降低hwmalter table test shrink space; --( 调整HWM时将阻塞DML操作),收缩表，并且降低hwmalter table test_idx shrink space cascade;--收缩表并降低...
-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
-
编辑 删除
PARALLEL_DEGREE_POLIC
The initialization parameter PARALLEL_DEGREE_POLICY controls whether automatic degree of parallelism (DOP), parallel statement queuing, and in-memory parallel execution are enabled. This parameter has three possible values:MANUAL - Disables automatic DOP, statement queuin...
-
编辑 删除
Waiting for clusterware split-brain resolution
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]Information in this document applies to any platform.PURPOSEThe purpose of this document is to explain when a "Waiting for clusterware split-brain resolution" alert log message ...
-
编辑 删除
Master Note for Tablespace Issues
Master Note for Tablespace Issues (文档 ID 1270839.1)转到底部APPLIES TO:...
-
编辑 删除
How to Perform a Health Check on the Database
How to Perform a Health Check on the Database (文档 ID 122669.1)1. Parameter file2. Controlfiles3. Redolog files4. Archiving5. Datafiles 5.1 Autoextend 5.2 Location6. Tablespaces 6.1 SYSTEM Tablespace 6.2 SYSAUX Tablespace (10g Release and above) 6.3 Loc...
-
编辑 删除
不完全恢复，选择性。
==================================list backup of database summary;list backup of database;==============选择时间段恢复：1，restore database from tag='q107' validate ;2，run{set until time "to_date('2016-12-22 08:00:00','yyyy-mm-dd hh24:mi:ss')";restore database;}List of Backups=====...
-
编辑 删除
单机升级rac
1，修改spfile：*.audit_file_dest='/u01/app/oracle/admin/hrbvsdb/adump'*.audit_trail='DB'*.cluster_database_instances=3*.cluster_database=true*.compatible='11.2.0.4.0'*.control_files='+DATA/control01.ctl','+DATA/control02.ctl'*.db_block_size=8192*.db_name='apex'*.db_recovery_file_dest_size...
-
编辑 删除
数据库不完全恢复。
RMAN> startup mountOracle instance starteddatabase mountedTotal System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 666895240 bytesDatabase Buffers 394264576 bytesRedo Buffers 5517312 bytesRMAN> list backup of database;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time-------
-
编辑 删除
"scnhealthcheck.sql" script (文档 ID 1393363.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]Information in this document applies to any platform.PURPOSEThis document describes the "scnhealth...
