Google Syntax Highlighter for WordPress
Posted by TQ on 八月 23rd, 2009winks@CCDB> select name,ceil(bytes/1024/1024) MB,status from v$datafile; NAME MB STATUS ---------------------------------------------------------------------- ---------- -------------- /home/oracle/app/oracle/oradata/ccdb/system01.dbf 730 SYSTEM /home/oracle/app/oracle/oradata/ccdb/sysaux01.dbf 1037 ONLINE /home/oracle/app/oracle/oradata/ccdb/undotbs01.dbf 440 ONLINE /home/oracle/app/oracle/oradata/ccdb/users01.dbf 5 ONLINE /home/oracle/app/oracle/oradata/ccdb/example01.dbf 100 ONLINE /home/oracle/app/oracle/product/11.1.0/db_1/dbs/USER_DATA_01.DBF 5 ONLINE /home/oracle/app/oracle/product/11.1.0/db_1/dbs/WINKS_DATA_01.DBF 62 ONLINE /home/oracle/app/oracle/oradata/ccdb/WINKS_DATA_EN_01.DBF 37 ONLINE 已选择8行。
escaped="true"
winks@CCDB> set autotrace traceonly explain winks@CCDB> select * from member; 执行计划 ---------------------------------------------------------- Plan hash value: 3441279308 ---------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1358 | 224K| 13 (0)| 00:00:01 | | 1 | TABLE ACCESS FULL| MEMBER | 1358 | 224K| 13 (0)| 00:00:01 | ----------------------------------------------------------------------------
winks@CCDB> set autotrace traceonly statistics winks@CCDB> select * from member_client; 已选择1363行。 统计信息 ---------------------------------------------------------- 1 recursive calls 0 db block gets 149 consistent gets 0 physical reads 0 redo size 380811 bytes sent via SQL*Net to client 1354 bytes received via SQL*Net from client 92 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1363 rows processed
Recent Comments