Re: ole questions

Tech-Archive recommends: Fix windows errors by optimizing your registry


ewcon...@xxxxxxxxx wrote:
Paul Clement wrote:
On 4 Aug 2006 11:22:51 -0700, ewconrad@xxxxxxxxx wrote:


¤
¤ All of these things have been verified. INCREMENT BY is set to 1. The
¤ sequence has not restarted. Driving me crazy! We got a few people in
¤ my office looking at it, nobody can figure it out! Sucks!

Any chance that caching is causing the problem? I think after a certain period of time unused cached
sequence numbers can get flushed, which means it has to fetch more to fill the cache.


Paul
~~~~
Microsoft MVP (Visual Basic)

Our DBA says that cache is turned off. She verified this.

I'm beginning to wonder about the connection itself. I currently have
it defined as ORADYN_ORAMODE. I'm going to try some others like
READONLY and DEFAULT.


READONLY seems to have fixed it. Our DBA thinks it might have been
hitting the db twice, like PL_SQL. So, the fix is in. Thoughts anyone?

.

Relevant Pages

  • Re: Can someone please tell me...
    ... ¤>Oracle doesn't implement identity columns, ... You create a sequence for a unique ... ¤>(primary key) column in a Table. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ole questions
    ... ¤ All of these things have been verified. ... Driving me crazy! ... sequence numbers can get flushed, which means it has to fetch more to fill the cache. ... Our DBA says that cache is turned off. ...
    (microsoft.public.vb.general.discussion)
  • Re: Can someone please tell me...
    ... ¤>> everyone ... Oracle doesn't implement identity columns, but a sequence number. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Can someone please tell me...
    ... two trips are required if your code requires the value of the sequence number for a subsequent ... ¤>Don't know whether there is any real difference between the methods performance-wise. ... (such as a sequence number) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Quickest way to copy
    ... ¤ I have need to copy all the tables from one database to another - both ... to know the fastest way of copying each table from dbA to dbB. ... size limitations on dBase database names and column names. ...
    (microsoft.public.vb.database.dao)