Sunday, September 30, 2007

Oracle Database 11g New Features for Administrators (1Z1 - 050 Beta Exam)

Dear friends,

The Beta Exam on Oracle Database 11g New Features for Administrators is now available.

Exam Number: 1Z1-050 ( Beta Exam )
Exam Registration: Pre-registration begins September 29, 2007.Beta Exam available November 1 – December 15, 2007
Exam Price: Beta Exam $50 US
Duration: 190 minutes
Number of Questions: 180-220
Passing Score: TBD
Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam.

For more information on training, preparation, exam topics and other information, please take a look at the below URL.

Preparation Books/Documents:

*** When you take this exam, please share your experience with this exam in this blog as comments ***

Thanks & Regards,

Sabdar Syed,

Monday, September 10, 2007

How to find the ORACLE_HOME path in Oracle Database?

In 9i:

SELECT substr(file_spec,1,instr(file_spec,'lib')-2) ORACLE_HOME FROM dba_libraries
WHERE library_name='DBMS_SUMADV_LIB';

In 10g:

SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;




start - run - regedit (enter) - HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE

Type the below command at prompt if the environment variable is defined for ORACLE_HOME

c:\> set oracle_home (ENTER)

Update: Take a look at my other post on "Setting an Oracle Environment variable – ORACLE_HOME"

Saturday, September 1, 2007

My blog has been added in Oracle Blogs list !!

Dear Friend,

This is to inform you that my blog has been reviewed by Oracle and added in Oracle’s official web site where all most all top blogs, on Oracle Technology, have been registered.

Happy Reading !!

With Best Regards,

Sabdar Syed,