Joords Oracle DBA blog

Both the serial and parallel version of:    INSERT /*+ APPEND */           INTO ...     SELECT ...         FROM ... uses the same quick interface as Direct Load under some conditions. Conditions are listed in Concepts Guide. How can one to tell if direct insert feature is used or not?

I have the following information : OOO 1 2 3 --- - - -  A  X X  B  X   X  C    X X And I want this as output: 000   print ---   -----  A      1  A      2   B      1   B      3  C      2  C      3  This can be done with the following SQL statement:

Oracle CertView This exciting new tool gives Oracle Certification candidates the ability to carry out some basic functions related to their certifications on their own, reducing wait times for information and verifications. Using this interface, you will be able to:  Review your demographic information Review your certification history Download your Oracle Certification logos Review your exam history Track your success kit status Send certification verification to a 3rd party

The GRANT ANY OBJECT PRIVILEGE system privilege allows users to grant and revoke any object privilege on behalf of the object owner. This provides a convenient means for database and application administrators to grant access to objects in any schema without requiring that they connect to the schema. This eliminates the need to maintain login credentials for schema owners so that they can grant access to objects, and it reduces the number of connections required during configuration. This system privilege is part of the Oracle supplied DBA role and is thus granted (with the ADMIN OPTION) to any user connecting AS SYSDBA (user SYS). As with other system privileges, the GRANT ANY OBJECT PRIVILEGE system privilege can only be granted by a user who possesses the ADMIN OPTION. When you exercise the GRANT ANY OBJECT PRIVILEGE system privilege to grant an object privilege to a user, if you already possess the object privilege with the GRANT OPTION, then the grant is performed in the ...

The following execute commands generate a trace file from controlfile. Option 1: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename>' RESETLOGS; A script is generated with only the RESETLOG clause. Option 2: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename>' NORESETLOGS; A script is generated with only the NORESETLOG clause. Option 3: ALTER DATABASE BACKUP CONTROLFILE              TO TRACE AS '<file location and filename> '; A script is generated with both options RESETLOG and NORESETLOG clauses.

Oracle 11gR2 is out for Linux, and I decided to upgrade one of my existing 11.1.0.6 database with ASM to 11.2.0.1. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a database 9.2.0.6 then first you need to upgrade to intermediate release i.e 9.2.0.8 then to 11.2.0.1.     9.2.0.6==>9.2.0.8==>11.2.0.1     8.1.7.0==>8.1.7.4==>10.2.0.4==>11.2.0.1 I will show a upgrade of an existing Single Instance 11.1.0.6 database with ASM, having same ORACLE_HOME, to Oracle 11gR2 with ASM. The Oracle environment is a Dataguard structure bases on 11.1.06 with ASM. The new situation will be one ASM instance with 11.2 and Oracle instance 11.1.0.6 The upgrade needs to be performed in two phases: Done       1. Upgrade the ASM instance of one of the DG’s Pending   2. Upgrade the other ASM instance of the DG ...

ZFS is a new kind of file system that provides simple administration, transactional semantics, end-to-end data integrity, and immense scalability. See on opensolaris . what is ZFS. New Information Update Configuring Oracle Solaris ZFS and your Oracle Database – A white Paper which provides planning information and step-by-step instructions for configuring and maintaining Oracle Solaris ZFS file systems for an Oracle database.