Joords Oracle DBA blog

DBMS_PROFILE The profiler provides us with a source code tuning for our PL/SQL applications. It is still a unknown feature for developers and DBA’s. In the past, you would tune your PL/SQL applications using SQL_TRACE and TKPROF or by using dbms_output. Well, you no longer have to do this. There is a DBMS_PROFILER package available as of oracle 8i version.

My Oracle Support does not allow to choose between Flash or HTML interfaces as metalink did. Now Oracle has created a HTML interface to My Oracle Support.

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