SVRMGR> select df.tablespace_name name,df.file_name "file",f.phyrds pyr,
2> f.phyblkrd pbr,f.phywrts pyw, f.phyblkwrt pbw
3> from v$filestat f, dba_data_files df
4> where f.file# = df.file_id
5> order by df.tablespace_name;
NAME
file
PYRPBRPYWPBW
------------------------------ -------------------------------------------------------------------------------- ---------- ---------- ---------- ----------
DRSYS
/oracle/data/oradata/mir2/drsys01.dbf
52 52 50 50
INDX
/oracle/data/oradata/mir2/indx01.dbf
920920460460
RBS
/oracle/data/oradata/mir2/rbs01.dbf
66 66 1176 1176
MIR2
/oracle/data/oradata/mir2/server.dat
78771 115841 5182 5182
MIR2
/oracle/data/oradata/mir2/server2.dat
3416 3416615615
SYSTEM
/oracle/data/oradata/mir2/system01.dbf
482 1393199199
TEMP
/oracle/data/oradata/mir2/temp01.dbf
128359126359
TEMPS
/oracle/data/oradata/mir2/temps.dat
376120 546210 129601 633434
TOOLS
/oracle/data/oradata/mir2/tools01.dbf
52 52 50 50
USERS
/oracle/data/oradata/mir2/users01.dbf
2022037 38620125 1030 1030
10 rows selected.
SVRMGR>
建立用户的指令
create user login identified by ASDFqwelrAFKM default tablespace mir2 temporary tablespace temps;
grant dba to login;
create user card identified by ASDFqwelrAFKM default tablespace mir2 temporary tablespace temps;
grant dba to card;
为什么tablespace USERS的物理读写都非常的大呢?比应用程序中的MIR2还大啊/
|