ITPub博客

select * from t_viradsl2 as of timestamp to_Date('2011-01-19 15:28:00', 'yyyy-mm-dd hh24:mi:ss')

the Permission (java.io.FilePermission <<ALL FILES>> execute) has not been granted to ADAPTER. The PL/SQL to grant this is dbms_java.grant_permission( 'ADAPTER', 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'execute' ) Execute SYS.dbms_java.grant_permission( 'username', 'SYS:java.io...

Oracle中TO_DATE格式TO_DATE格式(以时间:2007-11-02 13:45:25为例)           Year:        yy two digits 两位年 显示值:07        yyy three digits 三位年 显示值:007        yyyy four digits ...

CREATE OR REPLACE FUNCTION C2B (b IN CLOB default empty_clob()) RETURN BLOBASres BLOB;b_len number := dbms_lob.getlength(b) ;dest_offset1 NUMBER := 1;src_offset1 NUMBER := 1;amount_c INTEGER := DBMS_LOB.lobmaxsize;blob_csid NUMBER := DBMS_LOB.default_csid;lang_ctx I...

CREATE OR REPLACE FUNCTION blob_to_clob (blob_in IN BLOB) RETURN CLOB   AS    v_clob CLOB;    v_varchar VARCHAR2(32767);    v_start PLS_INTEGER := 1;    v_buffer PLS_INTEGER := 32767;    tmp_num number;  &...

RMAN> run{2> allocate channel d1 type disk;3> backup as compressed backupset4> incremental level 05> format '/u01/backup/inc0_%t_%T'6> tag='inc0'7> database include current controlfile;8> sql 'alter system archive log current';9> backup archivelog all format '/u01/b...

V$rman_Backup_Job_DetailsSELECT j.session_key,       TO_CHAR (J.START_TIME, 'yyyy-mm-dd hh24:mi:ss') start_time,       TO_CHAR (j.end_time, 'yyyy-mm-dd hh24:mi:ss') end_time,       J.TIME_TAKEN_DISPLAY,  &nbsp...

Oracle审计表AUD$数据过大问题1)Only appropriate privileged user can do delete operation on SYS.AUD$ table. The user must have either of the following privileges.-SYS user.-DELETE ANY TABLE system privilege. (If O7_DICTIONARY_ACCESSIBILITY=TRUE)-A user to whom SYS has granted the o...

1、DML could fail because there is not enough space to accommodate undo fornew transactions.2、Long-running queries could fail with a snapshot too old error, which meansthat there was insufficient undo data for read consistency

@echo offfor %%i in (D:\temp\*.txt) do (for /f "delims=" %%j in ('type %%i') do echo %%j>>D:\temp\huzhicheng.txt)echo 操作完成pause

SELECT a.tablespace_name,         ROUND (a.total_size) "total_size(MB)",         ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",         ROUND (b.free_size, 3) "free_size(MB)",    &n...

select a.sid||'.'||a.SERIAL#, a.username, a.TERMINAL, a.program, s.sql_text      from v$session a, v$sqlarea s      where a.sql_address = s.address(+)      and a.sql_hash_value = s.hash_value(+)      order by a.username, a...

select * from v$flash_recovery_area_usage;-----快速恢复区 区别于下面的su - gridasmcmd>ascmd>lsdg

  SELECT TRUNC (completion_time),         TRUNC(SUM (blocks * block_size) / 1024 / 1024 / 1024)||'G'    FROM gv$archived_logGROUP BY TRUNC (completion_time);

SELECT sql_text    FROM v$sqltext t, v$sql_plan p   WHERE t.hash_value = p.hash_value     AND p.operation = 'TABLE ACCESS'     AND p.options = 'FULL'ORDER BY p.hash_value, t.piece;

1、创建图片目录create or replace directory "images" as 'e:\pic\';2、创建存储过程CREATE OR REPLACE PROCEDURE img_insert ( filename VARCHAR2)ASf_lob BFILE;b_lob BLOB;BEGININSERT INTO image (image)VALUES (EMPTY_BLOB () )return image into b_lob;f_lob:=bfilename('ima...

SELECT 'alter index ' || owner || '.' || index_name || ' monitoring usage;'          AS "Monitor Indices Script"  FROM dba_indexes WHERE owner IN ('HZWSJ') AND table_name = 'EHR_HEALTHRECORD'########################################################...

启用或者禁用约束Disabling Enabled ConstraintsALTER TABLE dept    DISABLE CONSTRAINT dname_ukey;ALTER TABLE dept    DISABLE PRIMARY KEY KEEP INDEX,    DISABLE UNIQUE (dname, loc) KEEP INDEX;

强制日志切换和归档当前的重做日志的命令的区别alter system switch logfile和alter system archive log current的区别我的理解：1、alter system switch logfile 是强制日志切换，不一定就归档当前的重做日志文件（若自动归档打开，就归档当前的重做日志，若自动归档没有打开，就不归档当前重做日志。）...

4. 日志传输状态的监控第一步：在主库执行如下语句获得最新归档序列号：SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;第二步：在主库执行如下语句确认最新归档的日志是否已经传输至备库：SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# FROM V$ARCHIV...