Re: Grid 12c installation for standalone

Posted by Roshan on Jan 16, 2019; 7:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Grid-12c-installation-for-standalone-tp6368p7093.html

Hi Erman,

I have resized my Oracle ASM disks from 250 Gb to 500 GB as well as adding 4 new disks. But when I query  

SQL> set linesize 1000
SQL> break on report on disk_group_name skip 1
compute sum label "Grand Total: " of total_MB used_MB on report
SQL> SQL> SELECT
  2    name                                GROUP_NAME
  3  , round ( total_mb)                   TOTAL_MB
  4  , round ( (total_mb - free_mb) )      USED_MB
  5  , round ( free_mb)                    FREE_MB
  6  , ROUND((1- (free_mb / total_mb))*100,2  )  USED
  7  , (100 - ROUND((1- (free_mb / total_mb))*100,2))  FREE
  8  FROM
  9    v$asm_diskgroup
 10  ORDER BY
 11    name
 12  /

GROUP_NAME                       TOTAL_MB    USED_MB    FREE_MB       USED       FREE
------------------------------ ---------- ---------- ---------- ---------- ----------
DATA                              1023968    1018400       5568      99.46        .54
                               ---------- ----------
Grand Total:                      1023968    1018400

I see the size of the disks is still 250 GB.

Can you please advise?

Regards,

Roshan