可以这么考虑!查询当前实例的状态，v$instance是个视图STATUSVARCHAR2(12)Statusoftheinstance:•STARTED-AfterSTARTUPNOMOUNT•MOUNTED-AfterSTARTUPMOUNTorALTERDATABASECLOSE•OPEN-AfterSTARTUPorALTERDATABASEOPEN•OPENMIGRATE-AfterALTERDATABASEOPEN{UPGRADE|DOWNGRADE}
session_开头session_roles 会话的角色信息session_privs 会话的权限信息index_开头index_stats 索引的设置和存储信息伪表dual 系统伪列表信息查询当前实例的状态，v$instance是个视图STATUS VARCHAR2(12) Status of the instance:•STARTED - After STARTUP NOMOUNT•MOUNTED - After ST...
一:查看ASM磁盘及磁盘组状态SQL> select * from v$asm_disk;SQL> select * from v$asm_diskgroup; 二:创建external 冗余磁盘组,添加,删除磁盘,删除磁盘的时候需要指定磁盘的name而不是pathSQL> create diskgroup FRA external redundancy disk /dev/asm-disk4;Diskgroup created.SQL> alter diskgroup fra add disk...
那么现在非常清楚了,如果非要访问sys的表,就要把这个参数设置为true,通过上面引用的官方文档可以看出,此参数是静态的,也就是修改参数值需要重启database,也可以通过下面方法判断修改此参数是需要重启数据库的: SQL> select name,ISSYS_MODIFIABLE from v$parameter where name='O7_DICTIONARY_ACCESSIBILITY'; NAME ISSYS...
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM --- --- --- --- --- --- --- --- --- 1 1 148 104857600 1 NO CURRENT 262708457 14-APR-06 2 1 146 104857600 1 NO INACTIVE 262662667...
SQL>SELECT ADDR,PID,SPID FROM V$PROCESS WHERE ADDR= C000000084435AD8'; ADDR PID SPID --- C000000084435AD8 91 4835 b. 设置事件,以10046为例 sqlplus /nolog SQL>connect / as sysdba; SQL>oradebug setospid 4835 SQL>oradebug unlimit --不限制转储...