读写次数
selectsubstrDFNAME15DriveDFNAMEfile_
amefsphyblkrdfsphyblkwrtfromvfilestatfsvdatafiledfwheredffilefsfile
创建临时表空间：创建临时表空间createtemporarytablespacemytesttempfileEProgramoracleproduct1010oradataorclmytestdbfsize32mautoexte
do
ext32mmaxsize1024mexte
tma
ageme
tlocal
创建数据表空间createtablespacemytest_dataloggi
gdatafileEProgramoracleproduct1010oradataorclmytest_datadbfsize32mautoexte
do
ext32mmaxsize1024mexte
tma
ageme
tlocal
f创建用户并指定表空间createusertestaccou
tide
tifiedbytestpwddefaulttablespacemytest_datatemporarytablespacemytest给用户授予权限gra
tco
ectresourcetotestaccou
tdb2：指定所有权限
12创建一个用户：
CREATEUSERuser
ameIDENTIFIEDBYpasswordORIDENTIFIEDEXETERNALLYORIDENTIFIEDGLOBALLYAS‘CNuser’DEFAULTTABLESPACEtablespaceTEMPORARYTABLESPACEtemptablespaceQUOTAi
tegerKMUNLIMITEDONtablespaceQUOTAi
tegerKMUNLIMITEDONtablespacePROFILESprofile_
amePASSWORDEXPIREACCOUNTLOCKorACCOUNTUNLOCK；查看数据库中的所有用户：selectfromall_usersorselectfromdba_users
13查看oracle最大连接数：Selectsessio
_maxsessio
_curre
tsessio
s_highwaterusers_max
fromvlice
seSelectuser
amecou
tuser
amefromvsessio
groupbyuser
ame加密存储过程WRAPINAMEDORACLESOURCEDATESQL
ONAMEDORACLESOURCEDATAPLD
fr