Joords Oracle DBA blog

Oracle validated RPM Preparing Linux for Oracle Clusterware and RAC installation is made fast and simple with the help of the Oracle Validated Rpm. See for more information   Oracle Enterprise Linux Archives  and The Oracle-Validated rpm is available for all users . Public Yum Server The Oracle public yum server offers a free and convenient way to install packages from the Enterprise Linux and Oracle VM installation media via a yum client. Read how to do this on Public Yum Server

Statspack cannot be executed on a standby Database due to its read-only nature therefore tuning the performance of the apply process involves manually collecting statistics. In the new Active Data Guard option, users can now use statspack from the primary database to collect data from a standby database that is opened read-only and performing recovery. The standby statspack is installed in a separate schema on the Primary database, STDBYPERF which is then propagated to the standby. This user "STDBYPERF" user does not have DBA privileges and has no access to local V$ tables.

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.