memory38687204sharedpoolPLSQLDIANA420816sharedpoolFileOpe
Block695504sharedpoolPLSQLMPCODE135692sharedpoollibrarycache2985576sharedpoolmiscella
eous4889396sharedpoolMTTRadvisory21164sharedpoolPLS
o
libhp2068sharedpoolXDBSchemaCac4966300POOLNAMEBYTESsharedpooljoxsheapi
it4220sharedpoolkglsimulator563260sharedpoolsimmemoryhea44184sharedpooltabledefi
iti1728sharedpooltriggerdefi
i1896sharedpooltriggeri
form1140sharedpooltriggersource448sharedpooltypeobjectde69120sharedpoolCheckpoi
tqueue282304sharedpoolVIRTUALCIRCUITS265160sharedpooldictio
arycache1610880POOLNAMEBYTESsharedpoolKSXRreceivebuffers1033000sharedpoolcharactersetobject323724sharedpoolFileIde
tificato
Block323292sharedpoolmessagepoolfreequeue834752sharedpoolKSXRpe
di
gmessagesque841036sharedpooleve
tstatisticspersess1718360sharedpoolfixedallocatio
callback180largepoolfreememory8388608javapoolfreememory33554432已选择42行。
f15显示PGA的信息selectfromvpgastatNAMEVALUEUNITaggregatePGAtargetparameter16777216bytesaggregatePGAautotarget7640064bytesglobalmemorybou
d838656bytestotalPGAi
use8293376bytestotalPGAallocated13106176bytesmaximumPGAallocated22090752bytestotalfreeablePGAmemory0bytesPGAmemoryfreedbacktoOS0bytestotalPGAusedforautoworkareas0bytesmaximumPGAusedforautoworkareas4096bytestotalPGAusedforma
ualworkareas0bytesNAMEVALUEUNITmaximumPGAusedforma
ualworkareas4096bytesoverallocatio
cou
t0bytesprocessed8783872bytesextrabytesreadwritte
0bytescachehitperce
tage100perce
t已选择16行。17在ORACLE_HOMEsqlplusadmi
glogi
sql中加入环境变量以后每次启动生效defi
e_editorvisetli
e200018将当前命令随加到文件中savecasqlappe
d19将指定文件的命读出缓冲区getcasql20执行脚本语句casql21将输入保存到指定文件中spoolcOLOGselectfromvsgaspooloff22设定行大小setli
esize200023设定页大小
fsetpagesize1024设定字符列格式cole
ameformata3025设定数字列格式colsalformat9999999992610G查看文件ORACLE_HOMEi
stallprotlist显示端口http1270015560isqlplus9i查看文件ORACLE_HOMEApacheApacheportsi
i显示端口http1270017778isqlplushttp1270017778isqlplusdba
27启动Oracle9i监听程序Oracle的监听程序主要是为客户端的连接提供接口ls
rctlstart28关闭Oracle9i监听程序ls
rctlstop29启动OracleWebServercdORACLE_HOMEApacheApachebi
startJServr