Amit is an Oracle expert who has written some excellent posts at Skill-Guru
He  has created a 49 questions for  OCP 11g certification practice test questions – 1Z0_050

The test costs $2.99 and 6 questions are free to try.

More details about the exam 1Z0_050

Time : 105 minutes

Number of questions : 77

Passing score : 61%

Exam Price: US$ 195

This Oracle Database 11g: New Features for Administrators practice test comes with money back gurantee. If not satosfied, we will refund your money.

Objectives of this 1Z0_050 exam : Read more…

Problem: For a Oracle (backend) – Java (frontend) system, a query  returning about 500 K rows was running very slow and is taking about 45 mins.  Oracle database is hosted on server (A), has a separate application server (B), and client can access database from client machine (C), using SQLPLUS.  Query is running slow from the clients machine (C) and from the java front end (B).

Basic Checks on dbase:

Make sure to check following with respects to the tables / database in question:

• Latest Database statistics exists for the tables in question.
• Indexes
• Degree of Parallelism at Table Level:
• Optimizer mode

Database configuration parameters  – sga_max_size,  pga_aggregate_target , memory_target, processes Read more…

Further to may last post , Oracle 11g new Features – Part 1 , I am covering some more features here.

Client Query Result Cache

Oracle 11g allows client’s memory to cache query result sets which significantly improves the performance of repetitive queries by OCI-based clients.

Benefits of Client Cache feature

• Extending server-side query caching to client side memory, by leveraging cheaper client-side memory and caching each application’s working set locally.
• Ensuring better performance by eliminating round trips to the server.
• Improving server scalability by saving server resources
• offering transparent cache management: memory management, concurrent access of result-sets.

To start using client cache – set following initialization parameter:
CLIENT_RESULT_CACHE_SIZE = 1G  Read more…

Oracle 11g has some pretty cool new features. I am covering some of the Read Only tables and Server result cache features in this post

Read only Tables

In 10g or prior oracle releases,  table can be made read only by granting the  SELECT object privilege to them. Oracle 11g allows tables to be marked as read-only by ALTER TABLE command.
Example:

Create table
CREATE TABLE orders (
id  NUMBER
);

Mark table as read-only
ALTER TABLE orders READ ONLY;

DML operations
INSERT INTO orders VALUES (2) ;
UPDATE orders SET id = 2;
DELETE FROM orders; Read more…