DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Constraint types, Perfmon utility on NT

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi guys,

    What is the meaning of following Constraint types which I saw in dba_constraints

    C
    O
    P
    R
    U
    V

    I think all know about C, P, R and U but what about O and V?

    Secondly, what is the exact use of perfmon utility of NT and how can I use it for performance monitoring of Oracle Database. I have never found it very useful and much enjoying.

    Thanks in Adv.


    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is the explanation:


    C (check constraint on a table)

    P (primary key)

    U (unique key)

    R (referential integrity)

    V (with check option, on a view)

    O (with read only, on a view)



    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up good question


    Type of constraint definition:
    C (check constraint on a table)
    P (primary key)
    U (unique key)
    R (referential integrity)
    V (with check option on a view)
    O (with read only, on a view)


    - Magnus

  4. #4
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Thanks Sambavan,

    if someone could answer the perfmon part plz...

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

Posting Permissions

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


Click Here to Expand Forum to Full Width