易截截图软件、单文件、免安装、纯绿色、仅160KB

Oracle 10.1 Statistics

Oracle 10.1 Statistics:
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
 
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent gets from cache
db block gets direct
db block gets from cache
DB time
DBWR object drop buffers written
DBWR parallel query checkpoint buffers written
DBWR tablespace checkpoint buffers written
DBWR thread checkpoint buffers written
doubling up with imu segment
flashback log writes
frame signature mismatch
gc blocks corrupt
gc blocks lost
gc claim blocks lost
gc CPU used by this session
gc cr block build time
gc cr block flush time
gc cr block receive time
gc cr block send time
gc cr blocks received
gc cr blocks served
gc current block flush time
gc current block pin time
gc current block receive time
gc current block send time
gc current blocks received
gc current blocks served
global enqueue CPU used by this session
global enqueue get time
global enqueue gets async
global enqueue gets sync
global enqueue releases
heap block compress
IMU bind flushes
IMU commits
IMU contention
IMU CR rollbacks
IMU Flushes
IMU ktichg flush
IMU mbu flush
IMU pool not allocated
IMU recursive-transaction flush
IMU Redo allocation size
IMU undo allocation size
IMU undo retention flush
IMU- failed to get a private strand
IPC CPU used by this session
java call heap collected bytes
java call heap collected count
java call heap gc count
java call heap live object count
java call heap live object count max
java call heap live size
java call heap live size max
java call heap object count
java call heap object count max
java call heap total size
java call heap total size max
java call heap used size
java call heap used size max
java session heap collected bytes
java session heap collected count
java session heap gc count
java session heap


相关文档:

Oracle connection strings

Oracle ODBC connection strings
Open connection to Oracle database using ODBC
"Driver= {Microsoft ODBCforOracle};Server=Your_Oracle_Server.world;Uid=Your_Username;Pwd=Your_Password;"
Oracle OLE DB & OleDbConnection (.NET framework) connection strings
Open connection to Oracle database with s ......

oracle C# SQL 语句

在VS中写SQL语句的时候,千万万千要小心再小心,比如 说 数据类型的匹配, 单引号(这个能把人迷死)
 where 子句中可千万不能有空格(当查询条件为字符串的时候能把你弄疯,我弄这个的时候都疯了几次了,什么都对就是查不出来,调试了N遍才发现。)不行了,吃饭去,再不吃看见活人都想咬了。 ......

oracle 一条sql生成10W条测试数据

做数据库开发或管理的人经常要创建大量的测试数据,动不动就需要上万条,如果一条一条的录入,那会浪费大量的时间,本文介绍了Oracle中如何通过一条SQL快速生成大量的测试数据的方法。
产生测试数据的SQL如下:
SQL> select rownum as id,
  2          &nbs ......

在Linux系统上实现用Python远程访问Oracle数据库

1、下载oracle软件
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
oracle-instantclient-basic-10.2.0.4-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
oracle-instantclient-devel-10.2.0.4-1.i386.rpm
2、安装rpm包
rpm -ivh oracle-instantclient-basic-10.2.0.4 ......

Oracle查询中rownum与Order by查询的关系转

在开发应用的时候,把数据按照一定的规则排序后再取前几条数据这种操作是很平常的事情。我们在Oracle中常用的就是order by,然后取得rownum小于多少的数据这种方法。不过如果对Oracle不熟悉,也许就会发现你写的SQL语句检索出来的值不正确,这个是为什么呢。 因为Oracle在检索的时候,会首先把数据都检索出来,然后在排序段 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号