If session_cached_cursors is set,oralce also cache SQL statement in PGA ,if we are using Dedicated server?

Author: asktom.oracle.com | Published: 4th Mar 2008 | Visited: 56 times | Add Comment
Filed in: Oracle FAQ

Hi Tom Good to have a chance to ask a quesion.. I read some discussions about the session_cached_cursors here in the forum. Would you please help to clarify the idea that: 1.If session_cached_cursors is set to non zero, I understand that ora...

Read Article

Sponsored Links

• How to call Server Side function from Client Side Code using PageMethods in ASP.NET AJAX How to call Server Side function from Client Side Code using PageMethods in ASP.NET ...

• PerformancePoint 2007: Installing Planning Server Building more intelligent dashboards for businesses is a great idea; however, getting the software installed can be a showstopper. Find out how to install Planning Server, one of several installations required to get PerformancePoint work ...

• A simplified non topic based Event Notification Server in wcf with multiple protocol support. To be notified when an alert is generated in a system without filtering for what type of event you are registe ...

• Sending/Recieving PictureBox Image in C# To/From Microsoft SQL SERVER this article is written for those stucking in such a hell pro ...

• PrismServer: A Chat Client and Server Solution for .NET 2.0 PrismServer is a complete solution for adding chat and other general purpose multi-user messaging to your .NET applications. Concepts like creating and entering chat rooms, and management of user profiles, are abstracted and exposed as simple properties, methods and eve ...

• Gallery Server Pro - An ASP.NET Gallery for Sharing Photos, Video, Audio and Other Media Gallery Server Pro is a complete, stable ASP.NET gallery for sharing photos, video, audio and other media. This article presents the overall architecture and major featu ...

• Comparing Multi-Core Processors for Server Virtualization Intel IT tested servers based on select Intel multi-core processors to analyze the potential role of each in our data center server virtualization strate ...

• Check Validity of Sql Server Stored Procedures/Views/Functions (updated) Command line tool to check validity of objects in SQL Server datab ...

• Article :: The Official Ubuntu Book, 2e: The Ubuntu Server This chapter provides a quick crash course on becoming an Ubuntu Server system administra ...

• SQL Server to SQL Server Compact Edition Database Copy Utility Create and manage your mobiles database using SQL Management Studio and export them to SQL Compact Edition datab ...

Next: Single exceution time of dbms_job