Re: server column of v$session

hi~~~

i am korean..
my english is baby... sorry..

v$session ...

login system or dba... then

GRANT SELECT ANY TABLE TO "user_userName";

after

connect user_userName/user_userNamePassword_at_SID_Name;

select * from v$session;

...........end

bye bye~~~

<new_dba_at_my-deja.com> wrote in message news:8q99l4$9pj$1_at_nnrp1.deja.com...
> Hi,
>
> I have a database configured as Multi Threaded Server.
> When I connect to the server from unix prompt using SQL-Net, the server
> column of v$session shows "SHARED" for my session. But when I connect
> from front end, it shows "NONE". In tnsnames.ora on front-end, even if
> I specify "server = shared", still it shows "NONE".
>
> Could somebody tell me what "NONE" and "PSEUDO" values mean in server
> column of v$session ? Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 20 2000 - 00:00:00 CDT