Oracle DBA (12c/19c) Articles and Scripts

Profile Management ”default”  is the default profile from the pupbld. Sql script. Advantages of profiles Ensures that the users logoff their sessions when they have left their sessions idle for some time. Enables similar resource limits for group of users Easily assign resource limit to the users and control of passwords Privilege is a permission ot perform transactions against the database

What is Redo Log ?  Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records. A redo record also called a redo entry, is made up of a group of change vectors, each of which is a description of a change made to a single block in the database. Redo entries record data that you can use to reconstruct all changes made to the database, including the undo segments. Therefore, the redo log also protects rollback data. When you recover the database using redo data, the database reads the change vectors in the redo records and applies the changes to the relevant blocks. Whenever a transaction is committed, LGWR writes the transaction redo records from the redo log buffer of the SGA to a redo log file and assigns a system change number (SCN) to identify th...

With more than 500 new features, Oracle Database 12c is designed to give us exactly what we need for easy database administration, consolidation, security and availability. And I cannot deny the complexity it brings into our pluggable world. Pluggable Database Online Data file Movement Online Table Partition Movement DDL Logging Temporary UNDO for Temporary Tablespace RMAN Table level Recovery RMAN SQL Command Execution SQL Enhancement PGA Sizing Limitation Pre Upgrade fixes enhancement Disable Archive Log in Data Pump Concurrent Database Statistics Generation Flex Cluster Supported for Oracle RAC Architecture Flex architecture and Disk Scrubbing Support to Oracle ASM But straight to the point. Here are 12 new commands for Oracle DBAs: 1.  impdp … transform=disable_archive_logging:Y The new TRANSFORM option DISABLE_ARCHIVE_LOGGING appended to the impdp command line will cause Oracle Data Pump to disable (almost completely) redo logging when l...

set pagesize 2000 set linesize 2000 select output from GV$RMAN_OUTPUT where session_recid = ( select session_recid from V$RMAN_BACKUP_JOB_DETAILS where session_key=(select max(session_key) from v$RMAN_BACKUP_JOB_DETAILS) ); OUTPUT ---------------------------------------------------------------------------------------------------------------------------------- connected to target database: TEST (DBID=3221280546) connected to recovery catalog database allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=2817 devtype=DISK validation succeeded for archived log archive log filename=/data/TEST/arch/TEST1_1243_891780004.arc recid=2465 stamp=893720321 validation succeeded for archived log archive log filename=/backup/data/TEST/arch/TEST1_1243_891780004.arc recid=2466 stamp=893720321 validation succeeded for archived log archive log filename=/data/TEST/arch/TEST1_1244_891780004.arc recid=2467 stamp=893720321 validation succeeded...

Today we are going to have look at the Database growth. With the help of the given query. DBA can find the monthly growth of there database. Sometimes little information is too much useful. select to_char(CREATION_TIME,'RRRR') year, to_char(CREATION_TIME,'MM') month, round(sum(bytes)/1024/1024/1024) GB from   v$ datafile group by  to_char(CREATION_TIME,'RRRR'),   to_char(CREATION_TIME,'MM') order by   1, 2; oracle script to check the database growth : SET LINESIZE 200 SET PAGESIZE 200 COL "Database Size" FORMAT a13 COL "Used Space" FORMAT a11 COL "Used in %" FORMAT a11 COL "Free in %" FORMAT a11 COL "Database Name" FORMAT a13 COL "Free Space" FORMAT a12 COL "Growth DAY" FORMAT a11 COL "Growth WEEK" FORMAT a12 COL "Growth DAY in %" FORMAT a16 COL "Growth WEEK in %" FORMAT a16 SELECT (select min(creation_time...