数据库性能查看
数据库性能查看
pake35110 发表于7个月前
数据库性能查看
  • 发表于 7个月前
  • 阅读 2
  • 收藏 0
  • 点赞 0
  • 评论 0

腾讯云 技术升级10大核心产品年终让利>>>   

1 状态查询

启动状态

SQL语句

结果

nomount

select status from v$instance;

STARTED

select open_mode from v$database;

ERROR at line 1:

ORA-01507: database not mounted

mount

select status from v$instance;

MOUNTED

select open_mode from v$database;

MOUNTED

open

select status from v$instance;

OPEN

select open_mode from v$database;

READ WRITE 或者 READ ONLY

2 实验过程

SQL> startup nomount;

Oracle instance started.

 

Total System Global Area  125829120 bytes

Fixed Size                  1247684 bytes

Variable Size              92276284 bytes

Database Buffers           25165824 bytes

Redo Buffers                7139328 bytes

 

SQL> select status from v$instance;

 

STATUS

------------

STARTED

 

SQL> select open_mode from v$database;

select open_mode from v$database

*

ERROR at line 1:

ORA-01507: database not mounted

 

SQL> alter database mount;

 

Database altered.

 

SQL> select status from v$instance;

 

STATUS

------------

MOUNTED

 

SQL> select open_mode from v$database;

 

OPEN_MODE

----------

MOUNTED

 

SQL> alter database open;

 

Database altered.

 

SQL> select status from v$instance;

 

STATUS

------------

OPEN

 

SQL> select open_mode from v$database;

 

OPEN_MODE

----------

READ WRITE

 

共有 人打赏支持
粉丝 5
博文 53
码字总数 155143
评论 (0)
×
pake35110
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: