oracle分页

？？？？处为一个sql查询。

 

 

 

-- oracle分页
select tt.*
  from (select t.*, rownum num
          from (
                
                ？？？？？

                
                ) t) tt
 where  start <num and num <= end;

 

 

 

select count(1) from v$process;--获取数据库的连接数
select open_mode from v$database;--查询DB状态
select (free_mb - requested_mirror_free_mb) from v$ask_diskgroup;--查询DiskGroup剩余空间
select count(1) from v$asm_diskgroup_stat where state <> 'DISCONNECT';--查询DiskGroup个数
select round(sum(bytes) / 1048576) FreeSpace from dba_free_space;--查询剩余表空间
select count(1) from v$active_instances;--活动实例