hq181msn的个人空间 http://space.itpub.net/216109 欢迎您的到来!!!呵呵 Copyright(C) hq181msn的个人空间 SupeSite/X-Space Sat, 11 Oct 2008 12:37:35 GMT Expert one-on-one study one day http://space.itpub.net/216109/viewspace-218002 平台无关，查看sga的大小　，sqlplus中运行

SQL> compute sum of bytes on pool
SQL> break on pool skip 1
SQL> select pool ,name ,bytes from v$sgastat order by pool ,name;

POOL        NAM...]]> blog hq181msn Thu, 27 Mar 2008 10:53:10 GMT ORA-01157,ORA-01110 http://space.itpub.net/216109/viewspace-217957 01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
// *Cause:  The background process was either unable to find one of the data
//         files or failed ...]]> blog hq181msn Wed, 26 Mar 2008 15:20:28 GMT