Home » RDBMS Server » Performance Tuning » JUNIOR DBA
JUNIOR DBA [message #233901] Sat, 28 April 2007 01:08 Go to next message
kesevan
Messages: 17
Registered: April 2007
Location: MUMABI
Junior Member

Hi all,
when issue below query, iam not able to see the corresponding vaues....( i have connected AS SYSTEM ) and i have been instructed to check the current settings of my test database....my test database is in dubai and iam sitting in mumbai... how to see the values.... ? pls guide me...


instead of #### I need to see the values...
quote ..

SQL> select * from v$sysstat;

STATISTIC# NAME                                                    CLASS      VALUE
---------- -------------------------------------------------- ---------- ----------
         0 logons cumulative                                           1 ##########
         1 logons current                                              1 ##########
         2 opened cursors cumulative                                   1 ##########
         3 opened cursors current                                      1 ##########
         4 user commits                                                1 ##########
         5 user rollbacks                                              1 ##########
         6 user calls                                                  1 ##########
         7 recursive calls                                             1 ##########
         8 recursive cpu usage                                         1 ##########
         9 session logical reads                                       1 ##########
        10 session stored procedure space                              1 ##########
        11 CPU used when call started                                128 ##########


what would be the problem ?


[mod-edit : Add codes tags]

[Updated on: Sat, 28 April 2007 10:55] by Moderator

Report message to a moderator

Re: JUNIOR DBA [message #233915 is a reply to message #233901] Sat, 28 April 2007 02:35 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Read "How to format your posts". Your ouput is unreadable.

2/ Don't use SYSTEM, use your own account

3/ The ####### means your exceed your column format length. You should have somewhere something like 'col value format a9' or 'col value format 99999999'. execute "clear col". If this still happen, execute "set numwidth 20".

Regards
Michel
Previous Topic: can we grant SYSDBA privilege to SYSTEM user ?
Next Topic: oracle 10g slows down pc terribly
Goto Forum:
  


Current Time: Tue Dec 06 02:22:39 CST 2016

Total time taken to generate the page: 0.08089 seconds