Take your 6i Certification exams soon

The Oracle Internet Application Developer Release 6i Certified Professional (OCP) certification and its related exams will be retired effective April 30, 2009. Exams for this certification may taken up to this date, after which time they will no longer be available through Prometric or any other avenue.

Those working with Oracle PL/SQL and Forms should consider the newer Oracle PL/SQL Developer Certified Associate (OCA), Oracle Advanced PL/SQL Developer Certified Professional (OCP), and Oracle Forms Developer Certified Professional (OCP) certifications.

EXAM RETIREMENTS:

Oracle will retire the following four related exams:

Exams 1Z0-001 and 1Z0-101 are recognized toward several Oracle certifications that are not being retired. Exams passed prior to April 30, 2009 will be accepted and will count towards any track not retired.

ALTERNATES FOR EXAM 1Z0-001:

Exam 1Z0-001 is just one of four SQL-related exam options. The three other exams that may be taken in lieu of this exam are:

These exam options are available now. To find out more, visit the appropriate track page in the Quick Links below.

6i CERTIFICATION VALIDITY :

Note that the Internet Application Developer Rel. 6i OCP certification credential remains valid indefinitely. This retirement therefore has no effect on those currently holding the certification as well as those who complete the certification requirements and earn the certification before April 30.

Fastest spool: SQL Plus Vs UTL_FILE

I got a following query from Suvankar Das.

"I need to unload few Oracle tables with average data volume of 15M records to flat files. Is the SQL* Plus spool a good option for this volume of data from performance point of view OR is it better to do through PL/SQL UTL_FILE option."

And this is how I responded:

"SQL* Plus will have the fastest result to the flat file. Only use UTL_FILE if you need some more programmatic control in between the spooling.

To make sure first take a sample set of data (some thousands of records) for spooling using SQL *Plus and do the same using UTL_FILE. Compare both the timings.

Also based on the sample estimate the time for the entire 15M records."

The Verdict:
There is no hard rule that says either SQL *Plus or UTL_FILE will perform faster. It varies from environment to environment.

Where SQL *Plus/UTL_FILE could perform faster
SQL *Plus is a client program which is accessing Oracle database. Therefore it highly depends on the network. If the network traffic to the server is slow, then SQL *Plus will perform slower. No doubt. If the server and client are in same machine expect SQL *Plus to perform faster.

UTL_FILE is a server-side program residing within the Oracle database server. Use this procedure if you need to spool something in the server. This will perform faster in such cases. In client machine it always depends on the network load. Whether you are using SQL *Plus or UTL_FILE the network load is always a factor to check with.