How to check Database Size, Used and Free Space in a Database

  select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size" , round(sum(used.bytes) / 1024 / 1024 / 1024 ) - round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space" , round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space" from (select bytes from v$datafile … Continue reading How to check Database Size, Used and Free Space in a Database

Advertisements

RESIZING DATAFILE IN ASM

Re-sizing  datafiles in ASM is very simple. +ASM oracle@akyaka:/home/oracle>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 26 14:53:56 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved.   Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application … Continue reading RESIZING DATAFILE IN ASM

VirtualBox UDEV SCSI Rules Configuration In Oracle Linux 6 ( Install Oracle Grid on VM )

Oracle grid 11g r2, i added three disk on oracle vm. like as : Identify the Disks (/sbin/scsi_id) [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdb 1ATA_VBOX_HARDDISK_VB08a6b549-f300066c [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdc 1ATA_VBOX_HARDDISK_VBe062438c-ccbaf371 [root@erman ~]# /sbin/scsi_id -g -u -d /dev/sdd 1ATA_VBOX_HARDDISK_VBfcd96dfe-06d07a8b Create the "/etc/udev/rules.d/99-oracle-asmdevices.rules" file. [root@erman ~]# KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", … Continue reading VirtualBox UDEV SCSI Rules Configuration In Oracle Linux 6 ( Install Oracle Grid on VM )

INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Hello, For storing Voting disks in ASM,we require minimum of three disks or three failgroups for Normal Redundancy diskgroup. The number of voting files you can store in a particular Oracle ASM disk group depends upon the redundancy of the disk group. ASM puts each voting disk in its own failure group within the disk … Continue reading INS-30510 reported while installing GridInfrastructure for Cluster or Single DB

Linux Unix d.bin command

Hello, Some useful Oracle RAC Database commands in daily use Background Processes fraudms80:/dev#cd fraudms80:/home/oracle#ps -ef |grep d.bin oracle 7536914 1 0 10:17:18 - 0:00 /oracle/product/11.2.0.4/grid/bin/ohasd.bin reboot oracle 12452116 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmd.bin oracle 14287240 1 0 10:17:38 - 0:00 /oracle/product/11.2.0.4/grid/bin/oraagent.bin oracle 23200164 12452116 0 10:17:39 - 0:00 /oracle/product/11.2.0.4/grid/bin/evmlogger.bin -o /oracle/product/11.2.0.4/grid/evm/log/evmlogger.info -l /oracle/product/11.2.0.4/grid/evm/log/evmlogger.log fraudms80:/home/oracle# … Continue reading Linux Unix d.bin command

AIX server : The file access permissions do not allow the specified action Error Solutions !

Hello, my server version AIX fraudms80 2 7 00CC51B74C00 while copy folder, creating a new folder or etc. is returning: The file access permissions do not allow the specified action Error.  the file is being copied with the expected permissions so why is AIX giving me this error? Look for the dot "." directory, ownership … Continue reading AIX server : The file access permissions do not allow the specified action Error Solutions !

Memory management in Oracle database

  SQL> COLUMN component FORMAT A30 SELECT component, current_size, min_size, max_size FROM v$memory_dynamic_components WHERE current_size != 0;SQL> SQL> 2 3 COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE ------------------------------ ------------ ---------- ---------- shared pool 771751936 318767104 771751936 large pool 67108864 67108864 603979776 java pool 50331648 50331648 50331648 streams pool 33554432 0 33554432 SGA Target 2030043136 1862270976 2030043136 DEFAULT buffer … Continue reading Memory management in Oracle database