Thanks for the question, Trang.
Asked: November 20, 2017 - 9:57 am UTC
Last updated: November 21, 2017 - 1:02 pm UTC
Version: 11.2.0.4
Viewed 1000+ times
SQL> create table t as select d.* from dba_objects d, ( select 1 from dual connect by level <= 50 ) ; Table created. SQL> select max(owner)from t; MAX(OWNER) ------------------------------------------------------------------------- XDB 1 row selected. SQL> @mystat Enter value for statname: direct NAME VALUE ------------------------------------------------------------ ---------- db block gets direct 0 consistent gets direct 76350 physical reads direct 76350
SQL> select max(x) 2 from ( select row_number() over ( order by OWNER,OBJECT_NAME,SUBOBJECT_NAME,OBJECT_ID ) as x from t ); MAX(X) ---------- 3937800 1 row selected. SQL> @mystat Enter value for statname: direct NAME VALUE ------------------------------------------------------------ ---------- db block gets direct 0 consistent gets direct 76350 physical reads direct 102953
Trang Le, November 21, 2017 - 2:35 pm UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database