RE: cursor_sharing set to force on its own

From: Yong Huang <>
Date: Fri, 11 Apr 2008 08:06:23 -0700 (PDT)
Message-ID: <>

Thanks Pat. You're right. There's a trigger in an application user's schema created as "after logon on database... execute immdeiate 'alter session set cursor_sharing=force'". After disabling the trigger, the problem is gone. The trigger should have been created with the word "schema" instead of "database".

It takes a few seconds' thinking to realize that a regular user's trigger can have such effect on anybody's logon, just because it has the "logon on database" phrase. But it's us DBA's error because we created it.

Yong Huang

  • "Elliott, Patrick" <> wrote:

> Look for a login or startup trigger that is setting this parameter.
> Pat

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Received on Fri Apr 11 2008 - 10:06:23 CDT

Original text of this message