orac的le常用命令大全.pdf

oracle dba 常用命令 1 运行SQLPLUS 工具 sqlplus 2 以OS 的默认身份连接 / as sysdba 3 显示当前用户名 show user 4 直接进入SQLPLUS 命令提示符 sqlplus /nolog 5 在命令提示符以OS 身份连接 connect / as sysdba 6 以SYSTEM 的身份连接 connect system/xxxxxxx@服务名 7 显示当然用户有哪些表 select * from tab; 8 显示有用户名和帐户的状态 select username,account_status from dba_users; 9 将SCOTT 帐号解锁(加锁) alter user scott account unlock(lock); 10 以SCOTT 的身份连接并且查看所属表 connect scott/tiger select * from tab; 11 查看EMP 的表结构及记录内容 desc emp select empno,ename from emp; 12 以OS 的身份登看SGA,共享池,CACHE 的信息 connect / as sysdba show sga select name,value/1024/1024 from v$sga; show parameter shared_pool_size select value/1024/1024 from v$parameter where name =shared_pool_size; show parameter db_cache_size select value/1024/1024 from v$parameter where name =db_cache_size; 13 查看所有含有SIZE 的信息 show parameter size bitmap_merge_area_size integer 1048576 create_bitmap_area_size integer 8388608 db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_block_size integer 4096 db_cache_size big integer db_keep_cache_size big integer 0 db_recycle_cache_size big integer 0 NAME TYPE VALUE global_context_pool_size string hash_area_size integer 1048576 java_max_sessionspace_size integer 0 java_pool_size big integer large_pool_size big integer 8388608 max_dump_file_size string UNLIMITED object_cache_max_size_percent integer 10 object_cache_optimal_size integer 102400 olap_page_pool_size integer oracle_trace_collection_size integer 5242880 parallel_execution_message_size integer 2148 NAME TYPE VALUE sga_max_size big integer 143727516 shared_pool_reserved_size big integer 2516582 shared_pool_size big integer sort_area_retained_size integer 0 sort_area_size integer 524288 workarea_size_policy string AUTO 14 显示SGA 的信息 select * from v$sgastat; POOL NAME BYTES fixed_sga 453532 buffer_cac