ORACLE DBA BLOG

 CLI reference  Create/Drop  a Directory : rdsadmin.rdsadmin_util.create_directory is the procedure that can be used to create a directory for Oracle DB in amazon RDS.10,000 directories can be created,all allocated in your main data storage space . exec rdsadmin.rdsadmin_util.create_directory(p_directory_name => 'product_descriptions'); rdsadmin.rdsadmin_util.drop_directory is the procedure to drop the directory in database . if we drop directory the files which are present in the drop directory are not removed and will be still visble as the rdsadmin.rdsadmin_util.create_directory procedure can reuse pathnames, files in dropped directories can appear in a newly created directory. exec rdsadmin.rdsadmin_util.drop_directory(p_directory_name => 'product_descriptions');   it is always recomended to clear out the files in respective directory before droping the directory . List & Remove Files from a Directory: rdsadmin.rds_f...

Oracle Dataguard is a High availabity  software solution  designed for   data availability, data protection and disaster recovery solutions on enterprise data. It is only available with database enterprise edition . The Solution is achieved  by Creating a single  Standby database or multiple Standbys databases  for major Database in which enterprise  data is handled  A standby database is Transactional- consistent  copy of the Production or Primary Database  Whenever a Primary Database becomes unavailable due to planned or unplanned outages ,the application traffic can be switched over to one of Standby to maintain a Business continuity . Data Guard can be used in combination with other Oracle High Availability (HA) solutions such as Real Application Clusters (RAC), Oracle Flashback and Oracle Recovery Manager (RMAN), to provide a very high level of data protection and data availability This data guard configuration ban be mang...

 Architecture :   Basic Memory Structures Oracle Database includes several memory areas, each of which contains multiple subcomponents. The basic memory structures associated with Oracle Database include: ·          System global area (SGA) The SGA is a group of shared memory structures, known as SGA components , that contain data and control information for one Oracle Database instance. All server and background processes share the SGA. Examples of data stored in the SGA include cached data blocks and shared SQL areas. ·          Program global area (PGA) A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process. Oracle Database creates the PGA when an Oracle process starts.One PGA exists for each server process and background process. The collection of individual PGAs is the total instance PGA, or instance PGA . Database ...