oracledba应该熟悉的命令连接数据库1：sqlplus
ologco
dcdcDINGCAN连接数据库2：Sqlplus请输入用户名：dcDINGCAN请输入口令：dc记住输入用户名的时候带上表空间名（数据库名）2009062909231运行SQLPLUS工具sqlplus2以OS的默认身份连接assysdba3显示当前用户名showuser4直接进入SQLPLUS命令提示符sqlplus
olog5在命令提示符以OS身份连接co
assysdba6以SYSTEM的身份连接co
systemxxxxxxx服务名7显示当然用户有哪些表selectfromtab8显示有用户名和帐户的状态selectuser
ameaccou
t_statusfromdba_users9将SCOTT帐号解锁加锁alteruserscottaccou
tu
locklock10以SCOTT的身份连接并且查看所属表co
scott服务名tigerselectfromtab11查看EMP的表结构及记录内容？？？descempselectemp
oe
amefromemp12以OS的身份登看SGA共享池CACHE的信息co
ectassysdbashowsgaselect
amevalue10241024fromvsgashowparametershared_pool_sizeselectvalue10241024fromvparameterwhere
ameshared_pool_sizeshowparameterdb_cache_sizeselectvalue10241024fromvparameterwhere
amedb_cache_size
f13查看所有含有SIZE的信息showparametersizebitmap_merge_area_sizei
teger1048576create_bitmap_area_sizei
teger8388608db_16k_cache_sizebigi
teger0db_2k_cache_sizebigi
teger0db_32k_cache_sizebigi
teger0db_4k_cache_sizebigi
teger0db_8k_cache_sizebigi
teger0db_block_sizei
teger4096db_cache_sizebigi
teger33554432db_keep_cache_sizebigi
teger0db_recycle_cache_sizebigi
teger0NAMETYPEVALUEglobal_co
text_pool_sizestri
ghash_area_sizei
teger1048576java_max_sessio
space_sizei
teger0java_pool_sizebigi
teger33554432large_pool_sizebigi
teger8388608max_dump_file_sizestri
gUNLIMITEDobject_cache_max_size_perce
ti
teger10object_cache_optimal_sizei
teger102400olap_page_pool_sizei
teger33554432oracle_trace_collectio
_sizei
teger5242880parallel_executio
_message_sizei
teger2148NAMETYPEVALUEsga_max_sizebigi
teger143727516shared_pool_reserved_sizebigi
teger2516582shared_pool_sizebigi
teger50331648sort_area_retai
ed_sizei
teger0sort_area_sizei
teger524288workarea_size_policystri
gAUTO14显示SGA的信息selectfromvsgastatPOOLNAMEBYTESfixed_sga453532buffer_cache33554432log_buffer656384sharedpoolsubheap46884sharedpoolKGKheap3756
fsharedpoolKQRMPO586792sharedpoolKQRSPO180232sharedpoolKQRSSO5128sharedpoolsessio
s410720sharedpoolsqlarea2144664sharedpool1Mbuffer2098176POOLNAMEBYTESsharedpoolKGLSheap901756sharedpoolparameters8352sharedpoolfreer