what does user calls mean
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: what does user calls mean

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    what does user calls mean

    Hi

    on a single user system ..when i logged in a single user and issued the following sql

    SQL> select * from v$sysstat
    2 /

    STATISTIC# NAME CLASS VALUE
    ---------- -------------------------------------------------- ----- ---------
    0 logons cumulative 1 16260
    1 logons current 1 11
    2 opened cursors cumulative 1 52747
    3 opened cursors current 1 1
    4 user commits 1 4
    5 user rollbacks 1 4
    6 user calls 1 49538

    why so much usercalls when i am not executing any sql whatsoever ?
    why 4 user commits and some rollbacks when i have not done any transaction
    why logons cummulative 16260 ?

    regards
    Hrishy
    Last edited by hrishy; 02-05-2003 at 05:35 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Adewri

    Thanks for the link...by the way are you amar ?

    regards
    Hrishy

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    yep why ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Dude

    Well the reason..is this there were many people here who helped me during my OCP certification processes..through numerous posts over here..clearing my doubts .i justed wanted to say a big thank you..

    regards
    Hrishy

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Thumbs up

    congrats for ur OCP
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Amar

    Thank you very much..but i noticed a starnge thing with your nick..although you are browsing this forum your nick doesnt seem to be there in the users browsing this forum..why is that..i also need to thank pipo..i am not sure wheather he visits this site now ?

    regards
    Hrishy

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    there are people looking for me( i wont name them ) so im invisible

    Actually i'm drunk and dead this is my spirit answering :-)
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Amar

    well..i really really sympathise with..you mom told me after death that you get time to enjoy with the angels..well in your case the spirit became a DBA ..hehe..so ur the imortal DBA..long live amar..

    hey but still how come ur invisible i am kinda curious..:-D

    regards
    Hrishy

  10. #10
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hrishy, Amar has invoked the mighty power of invisibility from the lord of user preferences.

    Besides don't you know that spirits can only be seen at night (or in haunted houses) hey prehaps this form is haunted
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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