[SUTMS1:/oracle/tmp/db_size]$ cat dbsize.sql
select sum(bytes)/1024/1024 MB from dba_segments;
quit

[SUTMS1] /oracle/tmp/db_size]$ sqlplus '/as sysdba' @/oracle/tmp/db_size/dbsize.sql

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 10 14:59:47 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options


        MB
----------
203063.188

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[SUTMS1] /oracle/tmp/db_size]$

[SUTMS1:/oracle/tmp/db_size]$ cat run.sh
date >> /oracle/tmp/db_size/dbsize.txt
sqlplus '/as sysdba' @/oracle/tmp/db_size/dbsize.sql | head -n 15 | tail -1 >> /oracle/tmp/db_size/dbsize.txt

[dbtms1:/]# crontab -l (ROOT USER)
00 6 * 8 * su - oracle -c "/oracle/tmp/db_size/run.sh"

# glance -> m 메모리 확인

Sys Mem  :   1.7gb   User Mem:   3.3gb   Phys Mem :   7.9gb
Buf Cache:   2.8gb   Free Mem:   105mb   FileCache:      na

hostname1:/]vmstat 2 5
         procs           memory                   page                         
    r     b     w      avm    free   re   at    pi   po    fr   de    sr     in
    1     0     0   773581   27051  127   27     0    0     0    0     0
    1     0     0   773581   27895   78   12     1    0     0    0     0 
    1     0     0   738741   27713   79   12     0    0     0    0     0  
    1     0     0   738741   27713   82   12     0    0     0    0     0 
    1     0     0   738741   27713   75   12     0    0     0    0     0 

hostname1:/]dmesg | grep page
    physical page size = 4096 bytes, logical page size = 4096 bytes

     memory   
   avm    free
773581   27051
773581   27895
738741   27713
738741   27713
738741   27713

avm = 2.95GB
free = 0.1GB 로 확인됨

*** 2008-11-26 09:31:28.414
I'm the master node
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
kjzcpchk: open connection to node 1 failed for 3 retries
kjzgmapbcast:error encounter when broadcasting
DIAG attached to DLM
*** 2008-11-26 09:31:42.137
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
kjzcpchk: open connection to node 1 failed for 3 retries
kjzgmapbcast:error encounter when broadcasting
*** 2008-11-26 09:31:53.967
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
kjzcpchk: open connection to node 1 failed for 3 retries
kjzgmapbcast:error encounter when broadcasting
*** 2008-11-26 09:32:06.387
Timeout when connecting to node 1 [status=5]
Timeout when connecting to node 1 [status=5]
A rcfg proposal from node 1 is received
*** 2008-11-26 09:32:10.538
Reconfiguration completes [incarn=3]