Subscriber Count


Subscribe to Posts by Email


12c Database – Degraded Query Performance – 12c Clients with Queries on Lob tables

The issue is there’s a query which executes quickly through 12c client in 12c database where as it is taking longer time when connecting as with 11g Clients to 12c database.

The table has a […]

Result Cache: RC Latch – Troubleshooting

Most of us know the result cache is introduced in 11g initially with pl/sql result cache and then the query result cache to store the results of query in a separate memory structures in shared pool.

As I do not want to get into how it works, what it do, may be the best start […]