JUNIOR DBA [message #233901] |
Sat, 28 April 2007 01:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 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
|
|
|