Alert Log Rotation Script In Oracle

Comments

Post a Comment

Popular posts from this blog

Format Date in Oracle Database - NLS_DATE_FORMAT

Image
 When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of DD-MON-YY, and no time component.   There are multiple ways to see the time component of a DATE column, in sqlplus. You can either alter your session to set the date format, or you can use a function in your select statement to alter the format of the column. alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS' ; select sysdate from dual;   SYSDATE ------------------- 12/01/2022 20:19:06   select to_char(sysdate, 'DD-MON-YY HH24:MI:SS' ) from dual;   TO_CHAR(SYSDATE,'D ------------------ 12-JAN-22 20:19:50   How about RMAN? How can you see the date and time a backup completed or started? By default you only see the same format as in sqlplus: DD-MON-YY. This format is not always enough. You try an alter session command in RMAN (same as above), and it doesn’t work. Instead, what is the solution? You must set the NLS_DA...
Read more

Oracle Architecture SGA

Image
 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 ...
Read more

Database Practice Questions

 How Do you switch Database from using Pfile to spfile ? What is the Size of a segment & how do you measure the size of segments ? What is different types of diagnostic files in Database ? what is audit file dump destiantion ? What is AMM &ASMM ? how can you find &  modify the location & size  to archive log generation destination  ? How do you create a backup for COntrolfile manaully ? How do you list the Size of SGA & PGA ? Explain The Difference Between $oracle_home And $oracle_base? When A User Process Fails, What Background Process Cleans Up After It? Which Prcess is responsible for Cleaning up buffers once the COmmit is done ?  How Would You Force A Log Switch?  What Is The Difference Between A Temporary Tablespace And A Permanent Tablespace?  Name A Tablespace Automatically Created When You Create A Database?  When Creating A User, What Permissions Must You Grant To Allow Them To Connect To The Database?  Name ...
Read more