Oracle
icbm
这个作者很懒,什么都没留下…
展开
-
SCN在数据库恢复中的应用
获得当前scn号select dbms_flashback.get_system_change_number from dual;system checkpoint scn:select checkpoint_change# from v$database;datafile checkpoint scn:select checkpoint_change# from v$data原创 2012-01-30 16:06:19 · 487 阅读 · 0 评论 -
Password File Authentication & Listener Configuration
http://docs.oracle.com/cd/B19306_01/server.102/b14231/dba.htm#i1006740Using Password File Authenticationorapwd file= password= entries=sqlplus sys/sys_password as sysdbagrant sysdba to oe;co原创 2012-02-28 17:00:26 · 691 阅读 · 0 评论 -
有用的Goldengate命令-SHELL, OBEY, HELP, HISTORY,VERSIONS
http://hi.baidu.com/myitil/blog/item/e5bff986a41db92467096ef8.html2011-08-04 21:00There are a number of other useful GoldenGate commands which we can run from the GGSCI interface.The G转载 2012-03-06 20:35:25 · 971 阅读 · 0 评论 -
parent cursor, child cursor以及v$sqlarea, v$sql
白鳝的洞穴http://www.oraclefans.cn/blog/myblog.jsp?userName=1&blogUserDir=12074437504882554663关于 shared cursor,parent cursor,child cursorhttp://space.itpub.net/50897/viewspace-584304http://blog.csd原创 2012-04-27 22:23:17 · 694 阅读 · 0 评论 -
关于PL/SQL代码中的内嵌SQL与V$SQL的关系
PL/SQL代码,匿名块、存储过程、函数、包、解发器中的内嵌SQL,会在删除注释(提示HINT不会删除)后,合并空白字符(TAB、回车、多个空格替换为一个空格)并转为大写后,保存在V$SQL视图中。原创 2012-04-26 15:22:35 · 520 阅读 · 0 评论 -
oracle中启用、禁用表空间、表压缩
alter table t compress;alter table t nocompress;select owner,table_name,compression from dba_tables where owner='SCOTT';alter tablespace users default compress;alter tablespace users d原创 2012-05-02 13:57:00 · 1734 阅读 · 0 评论 -
用dbms_stats的备份表,备份统计信息
-- 创建统计备分表exec dbms_stats.create_stat_table(user,'mystat');-- 创建测试表create table t (id number, name varchar2(30));begin for i in 1 .. 10 loop insert into t (id, name) values(i, 'Steve原创 2012-05-28 15:01:56 · 578 阅读 · 0 评论