Oracle 10g 之HIGH Water MARK 数据统计
dba_high_water_mark_statistics
这个视图用于记录数据库的一些HWM信息:
SQL> desc dba_high_water_mark_statistics
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(64)
VERSION NOT NULL VARCHAR2(17)
HIGHWATER NUMBER
LAST_VALUE NUMBER
DESCRIPTION VARCHAR2(128)
现在有一些重要的统计数据可以通过这个视图快速的查询得到:
SQL> select name,highwater,last_value from dba_high_water_mark_statistics;
NAME HIGHWATER LAST_VALUE
---------------------------------------- ------------- -------------
USER_TABLES 1037 875
SEGMENT_SIZE 13037993984 9277800448
PART_TABLES 31 31
PART_INDEXES 0 0
USER_INDEXES 1288 1275
SESSIONS 32 14
DB_SIZE 143333572608 124359950336
DATAFILES 19 16
TABLESPACES 13 12
CPU_COUNT 4 4
QUERY_LENGTH 77474 1871
SQL_NCHAR_COLUMNS 0 0
SERVICES 4 4
13 rows selected.
SQL> select count(*) from dba_tables where owner not in ('SYS','SYSTEM');
COUNT(*)
----------
867
-The End-
By eygle on 2008-05-23 00:09 |
Comments (1) |
FAQ | 1922 |
1 Comment
services 4 表示什么意思?