ITPub博客

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...

DROP TABLESPACE ADAPTER_DATA INCLUDING CONTENTS AND DATAFILES;删除表空间和表空间包含的文件

DELETE force ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-4';crosscheck archivelog alldelete expired archivelog all

ORA-31679: Table data object string has long columns, and longs can not be loaded/unloaded using a network linkCause: Table data objects that contain long columns can not be selected over a network link.Action: Export this table to a file and then import the same table from the file....

crosscheck backup;delete expired backup;list backup;

从2013年11月分开始使用网易的云笔记记录技术博客但是 现在网易的云笔记改了密码之后 忘记密码了，换了电话号码 以前帮定的电话号码 没用找回密码麻烦所以把文档 存到itpub 也让其它人能够看到。

http://aphyr.com/posts/292-call-me-maybe-nuodb面向云 2.0版本发布

查看数据库对象创建时间可以通过DBA_OBJECTS 的create time 看出来