ORACLE数据库体系框架介绍及SQL语句性能探讨

Oracle数据库体系框架介绍及SQL语句性能探讨 ------------------------------------------------------------------------

Oracle数据库体系框架介绍及SQL语句性能探讨 --------------------------------------------------------------------

拔颐枪局饕囊滴袷侨砑⒑拖低臣桑饬礁龇矫娑蓟嵘婕暗绞菘馊砑敬蠖嗍牟泛凸ぷ鞫己蚈RACLE数据库有关；因此，可以说我们宏智科技在ORACLE数据库应用方面是高手云集、藏龙卧虎

1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba

14、回滚段查看 select rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extents Exte

1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba_table

14、回滚段查看 select rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extents Extents, v

1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr

1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Cur