0 Comments

Starting and stopping an Oracle ASM instance for Noncluster Databases 0 (0)

Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called Oracle Instance.  The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and   background processes. […]

 383 total views

0 Comments

How to check ASM diskgroup Size. 0 (0)

Sometime we need to fetch ASM diskgroup utilization of database. Below is the sql query to find ASM diskgroup size in database which includes Name,Total_GB,Free_GB,Used_GB and Free_percentage of disk. Sql query to fetch ASM diksgroup size. Click here to get sample output . Reference: How to add disk into ASM diskgroup. click here Hope so […]

 170 total views,  1 views today

Spread the love

0 Comments

Add Disks to ASM Disk Group in Oracle 4.9 (10)

How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new application to fulfil testing. As per requirement, we need additional space in our database. Below are the steps that we have to follow to add […]

 1,173 total views

Spread the love