oracle是什么sql,Oracle最轻量的SQL是什么?

SYS@ncdb>select * from x$dual;

ADDR                         INDX          INST_ID D

---------------- ---------------- ---------------- -

0000000110174098                0                1 X

Elapsed: 00:00:00.03

SYS@ncdb>select * from x$dual;

Elapsed: 00:00:00.01

Execution Plan

----------------------------------------------------------

Plan hash value: 3957808902

---------------------------------------------------------------------------

| Id  | Operation        | Name   | Rows  | Bytes | Cost (%CPU)| Time     |

---------------------------------------------------------------------------

|   0 | SELECT STATEMENT |        |     1 |    16 |     0   (0)| 00:00:01 |

|   1 |  FIXED TABLE FULL| X$DUAL |     1 |    16 |     0   (0)| 00:00:01 |

---------------------------------------------------------------------------

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

0  consistent gets

0  physical reads

0  redo size

301  bytes sent via SQL*Net to client

247  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SYS@ncdb>select * from dual;

Elapsed: 00:00:00.03

Execution Plan

----------------------------------------------------------

Plan hash value: 3543395131

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |     2 |     2   (0)| 00:00:01 |

|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |

--------------------------------------------------------------------------

Statistics

----------------------------------------------------------

24  recursive calls

0  db block gets

7  consistent gets

4  physical reads

0  redo size

221  bytes sent via SQL*Net to client

247  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SYS@ncdb>select * from dual;

Elapsed: 00:00:00.01

Execution Plan

----------------------------------------------------------

Plan hash value: 3543395131

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |     2 |     2   (0)| 00:00:01 |

|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |

--------------------------------------------------------------------------

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

3  consistent gets

0  physical reads

0  redo size

221  bytes sent via SQL*Net to client

247  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

1  rows processed

SYS@ncdb>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值