oracle DBA常用命令大全

《oracle DBA常用命令大全》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、1运行SQLPLUS工具sqlplus2以OS的默认身份连接/assysdba3显示当前用户名showuser4直接进入SQLPLUS命令提示符sqlplus/nolog5在命令提示符以OS身份连接connect/assysdba6以SYSTEM的身份连接connectsystem/xxxxxxx@服务名7显示当然用户有哪些表select*fromtab;8显示有用户名和帐户的状态selectusername,account_statusfromdba_users;9将SCOTT帐号解锁(加锁)alteruserscottaccountunlock(lock);10以SCO

2、TT的身份连接并且查看所属表connectscott/tigerselect*fromtab;11查看EMP的表结构及记录内容descempselectempno,enamefromemp;12以OS的身份登看SGA,共享池,CACHE的信息connect/assysdbashowsgaselectname,value/1024/1024fromv$sga;showparametershared_pool_sizeselectvalue/1024/1024fromv$parameterwherename='shared_pool_size';showparameterdb_

3、cache_sizeselectvalue/1024/1024fromv$parameterwherename='db_cache_size';13查看所有含有SIZE的信息showparametersizebitmap_merge_area_sizeinteger1048576create_bitmap_area_sizeinteger8388608db_16k_cache_sizebiginteger0db_2k_cache_sizebiginteger0db_32k_cache_sizebiginteger0db_4k_cache_sizebiginteger0db_

4、8k_cache_sizebiginteger0db_block_sizeinteger4096db_cache_sizebiginteger33554432db_keep_cache_sizebiginteger0db_recycle_cache_sizebiginteger0NAMETYPEVALUE------------------------------------------------------------global_context_pool_sizestringhash_area_sizeinteger1048576java_max_sessionspa

5、ce_sizeinteger0java_pool_sizebiginteger33554432large_pool_sizebiginteger8388608max_dump_file_sizestringUNLIMITEDobject_cache_max_size_percentinteger10object_cache_optimal_sizeinteger102400olap_page_pool_sizeinteger33554432oracle_trace_collection_sizeinteger5242880parallel_execution_message

6、_sizeinteger2148NAMETYPEVALUE------------------------------------------------------------sga_max_sizebiginteger143727516shared_pool_reserved_sizebiginteger2516582shared_pool_sizebiginteger50331648sort_area_retained_sizeinteger0sort_area_sizeinteger524288workarea_size_policystringAUTO14显示SG

7、A的信息select*fromv$sgastat;POOLNAMEBYTES-----------------------------------------------fixed_sga453532buffer_cache33554432log_buffer656384sharedpoolsubheap46884sharedpoolKGKheap3756sharedpoolKQRMPO586792sharedpoolKQRSPO180232sharedpoolKQRSSO5128sharedpoolsession