四、高频运维命令速查

分类	命令
连接	sqlplus / as sysdba、sqlplus scott/tiger@orcl
实例	startup / shutdown immediate、select status from v$instance;
监听	lsnrctl status、tnsping orcl
归档	archive log list、alter system archive log current;
表空间	select tablespace_name from dba_tablespaces;、select file_name from dba_data_files;
空间	SELECT tablespace_name, sum(bytes)/1024/1024 MB FROM dba_segments GROUP BY tablespace_name;
会话	select sid, serial#, username, status from v$session;、alter system kill session 'sid,serial#';
锁	select * from v$lock;、select object_name from dba_objects where object_id=...;
备份	rman target /、backup database;、list backup;
导出导入	expdp / impdp
性能	@?/rdbms/admin/awrrpt.sql、top + v$sql 结合