都是大欄位clob設計不合理惹的禍

會話已更改。
經過時間:  00: 00: 00.01
SQL> select * from cfms_questions;
已選擇4587行。

執行計畫
----------------------------------------------------------
Plan hash value: 3912515109
------------------------------------------------------------------------------------
| Id  | Operation         | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                |  3804 |  1329K|    68   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| CFMS_QUESTIONS |  3804 |  1329K|    68   (0)| 00:00:01 |
------------------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
          1  recursive calls
          1  db block gets
       4637  consistent gets
          4  physical reads
          0  redo size
    4300934  bytes sent via SQL*Net to client
    2387052  bytes received via SQL*Net from client
      13798  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       4587  rows processed
SQL> alter session set events '10046 trace name context off' ;

from
 cfms_questions
call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch     4588      0.28       0.37          0       4633          1        4587
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     4590      0.28       0.38          0       4633          1        4587
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 96  
Rows     Row Source Operation
-------  ---------------------------------------------------
   4587  TABLE ACCESS FULL CFMS_QUESTIONS (cr=4633 pr=0 pw=0 time=111289 us cost=68 size=1361832 card=3804)
Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                    4589        0.00          0.02
  SQL*Net message from client                  4589        0.00          3.18
  SQL*Net more data to client                    11        0.00          0.00
  SQL*Net more data from client                   8        0.00          0.00
********************************************************************************

select * from cfms_questions
END OF STMT
PARSE #707451568:c=0,e=10817,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=3912515109,tim=53142591819
EXEC #707451568:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3912515109,tim=53142592040
..............................................................

WAIT #0: nam='SQL*Net message from client' ela= 656 driver id=1413697536 #bytes=1 p3=0 obj#=132667 tim=53142594989
WAIT #0: nam='SQL*Net message to client' ela= 4 driver id=1413697536 #bytes=1 p3=0 obj#=132667 tim=53142595099
LOBREAD: c=0,e=68,p=0,cr=0,cu=0,tim=53142595131

  2         VERSION_ID,
  3         MODULE_ID,
  4         STATE,
  5         CATA,
  6         CREATOR_ID,
  7         DISCOVER_TIME,
  8         PS_ONLINE_VERSION,
  9         PS_SOLVE_TIME,
 10         CREATOR,
 11         RESULT,
 12         CONTACT_WAY,
 13         RESOLVE_TIME,
 14         DEPARTMENT_ID,
 15         SERVICE_ID,
 16         SYSTEM_ID
 17    from CFMS_QUESTIONS;
已選擇4587行。

執行計畫
----------------------------------------------------------
Plan hash value: 3912515109
-----------------------------------------------------------------------------------
| Id  | Operation         | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                |  3804 |   631K|    68   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| CFMS_QUESTIONS |  3804 |   631K|    68   (0)| 00:00:01 |
------------------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
          0  recursive calls
          1  db block gets
        550  consistent gets
          0  physical reads
          0  redo size
     168413  bytes sent via SQL*Net to client
       3693  bytes received via SQL*Net from client
        307  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       4587  rows processed


SQL> select ID,
  2         VERSION_ID,
  3         MODULE_ID,
  4         STATE,
  5         CATA,
  6         CREATOR_ID,
  7         DISCOVER_TIME,
  8         PS_ONLINE_VERSION,
  9         PS_SOLVE_TIME,

 11         CREATOR,
 12         RESULT,
 13         CONTACT_WAY,
 14         RESOLVE_TIME,
 15         DEPARTMENT_ID,
 16         SERVICE_ID,
 17         SYSTEM_ID
 18    from CFMS_QUESTIONS;
已選擇4587行。

執行計畫
----------------------------------------------------------
Plan hash value: 3912515109
------------------------------------------------------------------------------------
| Id  | Operation         | Name           | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                |  3804 |  1329K|    68   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| CFMS_QUESTIONS |  3804 |  1329K|    68   (0)| 00:00:01 |
------------------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
          1  recursive calls
          1  db block gets
       4637  consistent gets
          4  physical reads
          0  redo size
    4300934  bytes sent via SQL*Net to client
    2387052  bytes received via SQL*Net from client
      13798  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       4587  rows processed