- 浏览: 25818 次
- 性别:
- 来自: 北京
最新评论
1.set autot on stat
2.unsing v$statname,v$mystat
set echo off
set verify off
column value new_val V
define S="&1"
set autotrace off
select a.name, b.value
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
DML operations
set echo off
set verify off
column diff format a18
select a.name, b.value V, to_char(b.value-&V,'999,999,999,999') diff
from v$statname a, v$mystat b
where a.statistic# = b.statistic#
and lower(a.name) like '%' || lower('&S')||'%'
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 849declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6761.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7491.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 841thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7061.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 760Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6501.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7101.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11161.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5321.heap table IOT PARTI ... -
What do rollback and commit
2011-12-21 11:21 701When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 556A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6511.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4101.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7551.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5361. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6541.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8671.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 623ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6071.utl_file_dir: indicate the di ...
相关推荐
ORACLE 修改redo日志文件 大小的方法 供大家参考
redo 维护redo 维护redo 维护redo 维护redo 维护redo 维护
探索oracle redolog内部结构
cpp文件 undo redo 原型设计 部分代码 class Command { public: virtual BOOL UnDo() = 0; virtual BOOL ReDo() = 0; };
Oracle DG下修改redo log和standby redo log日志大小.txt
Oracle_Undo与Redo的通俗
这个是做实验时,简单基本的Undo、Redo的操作、在一个winForm中实现,并且可以设置Undo的最大次数。包中除了项目外,还附有报告.
redo undo使用方法
42 redo log是直接一条一条写入文件的吗?非也,揭秘redo log block.pdf
丢失所有redo-数据文件-控制文件的恢复
43 直接强行把redo log写入磁盘?非也,揭秘redo log buffer.pdf
针对一个window窗体实现了undo/redo功能,包括textBox,checkBox, listBox, comboBox, radioButton以及按钮焦点变化的实现。可能有些小bug思路仅供参考。完整的工程文件,VS打开即可运行,欢迎评论~ 详细说明参见...
Delphi 中实现Redo Undo的一个简单实例,包含源码
实现多步Undo和Redo的方法,对于mfc绘图程序来说,这个很必要,而且很实用!
实现undo redo功能,多步,绘图。
Simple Undo/redo library for C#/.NET
oracle日志,Undo日志记录某数据被修改前的值,可以用来在事务失败时进行rollback;Redo日志记录某数据块被修改后的值,可以用来恢复未写入data file的已成功事务更新的数据。
Oracle 8 REDO文件block损坏的解决方法
Arcgis Engine Undo 和 Redo 功能实现
探索oracle redolog的又一好资源