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

Thread: what does user calls mean

Threaded View

  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.

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