winks@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



原创文章，转载请注明： 转载自TQ 试用 WP
本文链接地址: Google Syntax Highlighter for WordPress
Post Footer automatically generated by wp-posturl plugin for wordpress.
Most Commented Posts