OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » JUNIOR DBA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

JUNIOR DBA [message #233901]

Sat, 28 April 2007 01:08

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

Michel Cadot
Messages: 68651
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 00:27:39 CDT 2024