查看Oracle数据库状态 无 show sgaset wrap offset linesize 400– 查看正在运行的后台进程select * from v$bgprocess;select * from v$bgprocess where paddr’00’;–查看数据库的物理组成：文件情况select * from v$controlfile;select * from v$datafile;se
查看Oracle数据库状态 <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;} .CodeEntity .code_
本文来源gao!daima.com搞$代!码网
pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms
- –> <!—ecms
- $velocityCount
–> <!—ecms
–>
show sgaset wrap offset linesize 400-- 查看正在运行的后台进程select * from v$bgprocess;select * from v$bgprocess where paddr'00';--查看数据库的物理组成：文件情况select * from v$controlfile;select * from v$datafile;select * from v$logfile;--查看实例内存情况show parameter sgashow parameter sharedshow parameter db_cacheshow parameter logalter system set db_cache_size=64m; //可以动态修改sga中内存区的大小，但是不能超过sga的最大内存select * from dept;--表空间管理CREATE TABLESPACE tbs2DATAFILE 'D:\oracle\oradata\APTECH\tbs2_01.dbf' SIZE 50M;conn sys/admin as sysdba(重启数据库必须以sys用户登陆)shutdown immediate(关闭数据库)启动数据库的三个步骤：startup nomount (启动实例)alter database mount;(装载数据库，读取控制文件)alter database open;(打开数据库，对数据文件，日志文件进行一致性校验)--用户管理-- Create the user CREATE USER MARTINIDENTIFIED BY martinpwdDEFAULT TABLESPACE USERSTEMPORARY TABLESPACE TEMP;-- Grant role privileges GRANT CONNECT TO MARTIN; GRANT RESOURCE TO MARTIN;-- 如果不使用 CONNECT 角色，则需要逐个赋予用户权限GRANT CREATE SESSION TO MARTIN;GRANT CREATE TABLE TO MARTIN;GRANT CREATE VIEW TO MARTIN;GRANT CREATE SEQUENCE TO MARTIN; GRANT CREATE SEQUENCE TO MARTIN; GRANT SELECT ON TEST TO MARTIN;GRANT ALL ON TEST TO MARTIN; -- 授予用户使用表空间 USERS 的权限ALTER USER MARTIN QUOTA UNLIMITED ON USERS; --修改用户密码ALTER USER MARTIN IDENTIFIED BY martinpass;--修改自己的密码在sql*plus中直接输入password命令即可--删除用户DROP USER MARTIN CASCADE; -- 查看用户 MARTIN 的信息select USERNAME,USER_ID,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACEfrom dba_userswhere username = 'MARTIN';
转载请注明原文链接：查看Oracle数据库状态
