oracleÄÚ´æ½á¹¹Ð¡ÎÊÌâ

ÎÒÔÚѧϰoracleÄÚ´æ½á¹¹ÎÊÌâʱ£¬Óöµ½ÁËÏÂÃæµÄÎÊÌ⣺

ÎÊÌâ1£º
select count(*) from dba_objects;

Ìáʾ³ö´í£ºdatabase not open:queries allowed on fixed tables/views only

ÎÊÌâ2£ºÔÚ¼ÆËãÃüÖÐÂÊʱ£º
select a.value+b.value "logical_reads",c.value "phys_reads",100*((a.value+b.value)-c.value)/(a.value+b.value) "buffer hit ratio" from v$sysstat a,v$sysstat b,v$sysstat c where a.statistic#=40 and b.statistic#=41 and c.statistic#=42;

Ìáʾ³ö´í£ºdivisor is equal to zero!!!


ÏëÁ˺þ㬶¼Ã»½â¾ö£¬µÈ´ý¸ßÊÖ£¡£¡£¡

---

Ŷ£¬¹Ø×¢£¡

---

1.

´íÎóÌáʾÒѾ­ºÜÃ÷ÏÔÁË
Ìáʾ³ö´í£ºdatabase not open:queries allowed on fixed tables/views only

Êý¾Ý¿âûÓÐopen£¬¿ÉÄÜÖ»ÊÇmount״̬¡£ ¶¯Ì¬±íºÍÐÔÄÜͼҪÊý¾Ý¿âopen״̬²ÅÄÜ·ÃÎÊ¡£


2.
Ìáʾ³ö´í£ºdivisor is equal to zero!!!
³ýÊýÊÇ0£¬²»Äܱ»³ý

Òª²éÒ»ÏÂdata²ÅÖªµÀ¾ßÌåÎÊÌâ¡£

---

SQL code:

SQL> select count(*) from dba_objects;

COUNT(*)
----------
50932

SQL> select a.value+b.value "logical_reads",c.value "phys_reads",100*((a.value+b.value)-c.value)/(a.value+b.value) "buff
er hit ratio" from v$sysstat a,v$sysstat b,v$sysstat c where a.statistic#=40 and
2 b.statistic#=41 and c.statistic#=