-
编辑 删除
index
normal index---------------------SQL> create table t2 (a number,b varchar2(10 char));Table created.SQL> SQL> SQL> SQL> begin 2 for i in 1..100 loop 3 insert into t2 val...
-
编辑 删除
单实例异地恢复
1、主库备份主库controlfile autobackupbackup database;记录dbid将备份出来得文件传送到备库上。2、异地恢复[oracle@rac1 oracle]$ export ORACLE_SID=oradb1[oracle@rac1 oracle]$ rman target /Recovery ...
-
编辑 删除
catalog
1、oradb1创建应用create tablespace test_data datafile '/home/oracle/oradata/oradb1/test_data01.dbf' size 500m autoextend off;create user magy identified by magy default tablespace test_data te...
-
编辑 删除
asm
[oracle@rac1 oracle]$ export ORACLE_SID=+ASM1[oracle@rac1 oracle]$ asmcmdASMCMD> help asmcmd [-p] [command] ...
-
编辑 删除
消除行连接
[oracle@rac1 oracle]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 22 11:12:11 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Da...
-
编辑 删除
oracle死锁
session 1 执行如下脚本：SQL> begin 2 update t1 set a=10 where a=1; 3 dbms_lock.sleep(5); 4 update t2 set a=11 where a=2; 5 dbms_lock.sleep(5);&n...
-
编辑 删除
oracle取随机数
select * from (select * from (select * from t1 where rownum <= 100 ) order by dbms_random.value) where rownum <=1;
-
编辑 删除
查看redo使用
select b.name,a.value/1024 from v$mystat a,v$statname bwhere a.statistic# = b.statistic#and b.name='redo size';begininsert /*+append nologging*/ into t1 select * from t1 where rownum <=10000;e...
-
编辑 删除
表空间传输
--表空间置位只读alter tablespace data1 read only;--导出表空间元数据expdp system/password directory=dumpdir1 dumpfile=ts_trans_data1.dmp transport_tablespaces=data1 tablespace_full_check=Y--传...
-
编辑 删除
trigger
--dml trigger-------------------------------------------------------------------------SQL> create or replace trigger tr_magy01 2 before 3 insert on t1 4 be...
-
编辑 删除
rac恢复数据文件(非共存储享归档)
--asm存储，删除一个数据文件[oracle@rac1 oracle]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 15 13:19:32 2013Copyright (c) 1982, 2005, Oracle. All rights rese...
-
编辑 删除
pv vg lv
vgscanpvscanlvscanvgcreate vg00 /dev/sde1 /dev/sdf1 /dev/sdg1 lvcreate -n ... -i 8 -I 32 -L 4096 /dev/vgdata1lvcreate -n lvstrp01 -i 8 -I 8 -L 100 vg00pvcreate /dev/sdd1vgextend vg00 /dev/sdd1...
-
编辑 删除
hit ratio
-- 数据缓冲区高速缓存SELECT physical_reads, db_block_gets, consistent_gets, NAME, 100 * ( 1 - ( physical_reads / (consistent_gets + db_block_gets - physical_reads))) "Data Bu...
-
编辑 删除
dbms_stats
exec dbms_stats.gather_table_stats('SCOTT','T1');exec dbms_stats.gather_table_stats('SCOTT','T1',stattab=>'STATIC_TABLE');exec dbms_stats.gather_index_stats('SCOTT','IDX_T1');exec dbms_stats.g...
-
编辑 删除
dbms_redefinition
exec dbms_redefinition.can_redef_table('scott','t1',dbms_redefinition.CONS_USE_ROWID);exec dbms_redefinition.can_redef_table('scott','t1',dbms_redefinition.CONS_USE_PK);CREATE TABLE scott.t1_p...
-
编辑 删除
dbms_file_transfer
BEGINDBMS_FILE_TRANSFER.COPY_FILE(source_directory_object => 'DUMPDIR1',source_file_name => 'tbs_tran01.dmp',destination_directory_object => 'END_DIR',destination_file_name => 'tbs_tran01_des....
-
编辑 删除
dbms_job
DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what &...
-
编辑 删除
utl_file
create directory utl_path as '/home/oracle/';grant read,write on directory utl_path to scott;grant execute on utl_file to scott;conn scott/tigerdeclarev_hand_file utl_file.file_type;cursor cur...
-
编辑 删除
DBMS_ERRLOG
CREATE TABLE T1 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=10;CREATE TABLE T2 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=20;ALTER TABLE T1 ADD CONSTRAIN...
-
编辑 删除
rac启停方法
-------------------------汇总--------------------------crs_stat -tcrs_start -allcrs_stop -allsrvctl start database -d oradbsrvctl stop database -d oradbsrvctl start instance -d oradb -i oradb1srvctl ...
