Home

About Me
Blog
Projects
Awards
Publications
Volunteer

Blog Posts

  • Oracle Shrink Table – regain your space back

    I believe this is better explained with an example.Sql code: lets first check if your database table spaces that re in manual and auto segment space management.  SELECT tablespace_name, extent_management, segment_space_management    FROM dba_tablespaces;        TABLESPACE_NAME                EXTENT_MANAGEMENT SEGMENT_SPACE_MANAGEMENT—————————— —————– ————————SYSTEM                         LOCAL             MANUAL                  SYSAUX                         LOCAL             AUTO                    UNDOTBS1                       LOCAL             MANUAL                  TEMP                           LOCAL             MANUAL                  USERS                          LOCAL             AUTO                     …

  • OCA 1Z0-051 dumps

    1Z0-051 dump pdf free download – Oracle 11g SQL Fundamentals I    Download Here: 1Z0-051-1 Download Here: 1Z0-051-2   Exam Details :  Oracle Database 10g and 11g: SQL Fundamentals I 1Z0-051 Exam Number: 1Z0-051 Associated Certifications: Oracle Database 11g Administrator Certified Associate  Exam Product Version: SQL and PL/SQL,   Exam Price: US$ 125 Duration: 120 minutes Number…

  • 1Z0-052 dump pdf free download

     Oracle Certified Associate – OCA 1Z0-052 dump pdf free download – Oracle 11g Database Administration I Download Here : 1Z0-052Exam Details :Oracle Database 11g: Administration I 1Z0-052 Exam Number: 1Z0-052 Associated Certifications: Oracle Database 11g Administrator Certified Professional   Exam Product Version: Oracle Database 11g, Exam Price: US$ 245 Duration: 90 minutes Number of Questions: 70 Passing…

  • Applying CPU Patch On Primary Database Server Environment

     Applying CPU Patch On Primary Database Server Environment.  Step 1: Incase if you have standby server. Now disable log shipping on the primary database by setting the log_archive_dest_state_2 to disable. As I said earlier, parameter log_archive_dest_2 on my primary database is set to point to the standby database. SQL> alter system set log_archive_dest_state_2=disable; System altered.…

  • Applying CPU Patch in a dataguard (Physical Standby) environment

    Here is a brief explanation on how to apply CPU(Critical Patch Update) in a dataguard environmentIn this demo, I am applying PSU 11.2.0.4.2 on the Primary and standby databases. Standby  Database Name :ORCL_STBYPrimary  Database Name : ORCL Primary Server: [oracle@PRIM ~]$ sqlplus sys/oracle@srprim as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 18 10:43:50 2012…

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts