Re: Parse Vs Execute

You don't necessarily need to reduce the parse count unless you definitely have latch contention on the library cache latches, and other parse-related latches. If you are using successfully using session_cached_cursors, then you will still see parse calls being counted, even though the parse

Re: what is oracle rdb?

Well said Mogens, I have been following your thread. I have worked with Rdb for several years it is an excellent product and thank GOD that they did not allove MS or CA or for that matter IBM to buy it. It would have been shot down to non-existence several years back. Murali Mogens_Nørgaard

Re: Oracle to MS-SQL Replication

Check for heterogenous services in Oracle docs. Tanel. - Original Message - From: Nikhil Khimani To: Multiple recipients of list ORACLE-L Sent: Friday, November 28, 2003 9:49 PM Subject: Oracle to MS-SQL Replication LG, Any pointers, white

FRM-41072

Do you know how to overcome this problem? Currently my forms work good with a 7.3.3 Database Server. Whilei get connected to the 9.2.0.1 database i receive this error "Cannot create the Group" My forms have been created by the Developer/2000 which i don;t own. I feel that i have something

Re: FRM-41072

John, This sounds like an application specific error. Was there an 'ORA-' error? If not, you will need to do some digging to find out what the app is attempting to do. Perhaps setting SQL_TRACE on for the session would provide some clues, especially if you don't have source for the app.

Re: FRM-41072

How to set SQL_TRACE on on my server? I am quite novice. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 9:54 PM John, This sounds like an application specific error. Was there an 'ORA-' error? If not, you

Re: RE: Parse Vs Execute

On Fri, 2003-11-28 at 09:24, Jared Still wrote: By using DBMS_SQL you can open a cursor and re-execute as many times as needed. You can't do that with execute immediate. On Wed, 2003-11-26 at 12:04, [EMAIL PROTECTED] wrote: i remember in tom kytes new book there is a 'softer parse' he

RE: Parse Vs Execute

Dear Jonathan Lewis, Many thanks for your response. Using session_cached_cursor parameter I am not getting better response time. I did run this testcases multiple times but always session_cached_cursor=0 gives better response time. But the same time w.r.t latch, session_cached_cursor=100 is

Writing a delay in PL/SQL?

I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know offhand whether there's a built-in PL/SQL procedure to just wait for a specified period

Re: Writing a delay in PL/SQL?

Hi try DBMS_LOCK.SLEEP (seconds IN NUMBER); /peter Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know

Re: Writing a delay in PL/SQL?

dbms_lock.sleep http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_lock2. htm#998469 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 8:34 PM I know this is going to sound rather crazy, but I want to

RE: Writing a delay in PL/SQL?

DBMS_LOCK.SLEEP (30)-- It will sleep for 30 secs -Original Message- Jonathan Gennick Sent: Saturday, November 29, 2003 8:34 PM To: Multiple recipients of list ORACLE-L I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say

Re: Writing a delay in PL/SQL?

sys.dbms_lock.sleep ( seconds_to_sleep ) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 7:34 PM I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a

Re: Writing a delay in PL/SQL?

try DBMS_LOCK.SLEEP() Cheers Jeff Herrick On Sat, 29 Nov 2003, Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does

Re[2]: Writing a delay in PL/SQL?

Saturday, November 29, 2003, 8:59:34 PM, a whole bunch of people wrote: try DBMS_LOCK.SLEEP() Thanks all. I'll give that a try. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and

RE: Writing a delay in PL/SQL?

I'm curious why? some testing? Regards, Waleed -Original Message- Sent: Saturday, November 29, 2003 8:34 PM To: Multiple recipients of list ORACLE-L I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or

.NET, connection pooling and security .

I hope somebody on the list can help me out with this. All of our 3-tier apps are architected with a schema owner (owns all objects used by an application) and application user (no create privs, but it does have full dml privs to the schema owner objects). On the web side, connection pooling is

Re: Writing a delay in PL/SQL?

DBMS_LOCK.SLEEP On 2003.11.29 20:34, Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know offhand whether

Re: .NET, connection pooling and security .

Steve, I'm not a web developer either, but I do know that this is a very common method of handling the database connections. Many 2 tier apps work this way as well. SAP for example. Unless you have influence on the architecture and can present a convincing argument, you best learn how to work

RE: Parse Vs Execute

Sami, 'cached_cursors' is not a valid hint, at least not in 9i. Or at least, I can find no reference to it. And 'cached cursors' as it appears in the SQL is not a valid hint syntax. You need to set the session_cached_cursors value in the init.ora, and bounce the database. This parameter

Re: .NET, connection pooling and security .

On 2003.11.29 22:49, Steve Perry wrote: I hope somebody on the list can help me out with this. All of our 3-tier apps are architected with a schema owner (owns all objects used by an application) and application user (no create privs, but it does have full dml privs to the schema owner

RE: .NET, connection pooling and security .

Well ... in general it's the apps that manage the system security, and the DB users are there to prevent the app users from doing damage, but in general these two work in unison. I have not seen any decent ways of having the DB administer users without there being a serious overhead, in terms of

RE: Parse Vs Execute

I thought the session_cached_cursors is dynamic and scope is session? This is on 8.1.7. I have used: alter session set session_cached_cursors=500; -Original Message- Sent: Sunday, November 30, 2003 12:24 AM To: Multiple recipients of list ORACLE-L Sami, 'cached_cursors' is not a