Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    3

    Unanswered: v$db_object_cache

    Environment : V8.1.6/Win2K

    hi there..

    when v$db_object_cache is queried, I noticed that each dml & ddl statements are having two entries in this view. Every unique statement should have only one cursor, right? If so, what's happening?

  2. #2
    Join Date
    Nov 2001
    Posts
    25
    Provided Answers: 1
    Check in v$sql, if they have two enteries for the sql , there must be some difference.

  3. #3
    Join Date
    Dec 2002
    Posts
    1

    v$db_object_cache

    Hi!!...Hope u remember me!.This is prabhakar.

    I guess the reason for two entries belonging to a dml statement in the v$db_object_cache is for representing a sql statement's private area and shared sql-area.If we query the view like this:"select name rfom v$db_object_cache where type ='CURSOR';" we see two cursors for every select statments.This I guess probably represnts private ans shared-sql areas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •