Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
August | 2010 | Oracle DBA – Tips and Techniques

Using GoldenGate to replicate between databases on same host

Posted by Gavin Soorma
On August 25, 2010
3 Comments

You need to be logged in to see this part of the content. Please Login to access.

Solving a 10g Bind Variable Peeking problem by granting and revoking privileges

Posted by Gavin Soorma
On August 23, 2010
0 Comments

The Cost Based optimizer peeks at the values of user-defined bind variables on the first invocation of a cursor. Based on this, the optimizer determines the selectivity of the WHERE clause condition as if literals have been used instead of bind variables. On subsequent invocations of the cursor, no bind peeking takes place, and the […]

Oracle GoldenGate – how to connect to a particular database if there are multiple databases on the source or target server

Posted by Gavin Soorma
On August 19, 2010
2 Comments

You need to be logged in to see this part of the content. Please Login to access.

News

Using GoldenGate to replicate between databases on same host

Solving a 10g Bind Variable Peeking problem by granting and revoking privileges

Oracle GoldenGate – how to connect to a particular database if there are multiple databases on the source or target server