Home » SQL & PL/SQL » SQL & PL/SQL » V$ tables interrogate (v 10.0.0.2)
V$ tables interrogate [message #596767] Thu, 26 September 2013 04:48 Go to next message
strydod1@telkom.co.za
Messages: 2
Registered: September 2013
Location: Pretoria ZA
Junior Member
I would like to interrogate v$session, V$process etc.
Re: V$ tables interrogate [message #596768 is a reply to message #596767] Thu, 26 September 2013 04:56 Go to previous messageGo to next message
Littlefoot
Messages: 19693
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Dynamic performance views (V_$) are owned by SYS. There are public synonyms for these views, and they are prefixed with V$. So, you should just query these synonyms, such as
select * from v$session
Here's some more reading for you: Dynamic Performance (V$) Views.
Re: V$ tables interrogate [message #596769 is a reply to message #596767] Thu, 26 September 2013 05:00 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
what do you mean interrogate v$session, v$process? i couldn't understand your question, please explain clearly, i think as per your topic,there was no such dynamic view in the name of 'v$tables', go to sqlplus screen and type DESC V$SESSION and DESC V$PROCESS to understand better,


Re: V$ tables interrogate [message #596770 is a reply to message #596767] Thu, 26 September 2013 05:02 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2445
Registered: May 2013
Location: World Wide on the Web
Senior Member
select * from v$session;
select * from v$process;


Use "gv$" if it is a multi-node.

Regards,
Lalit
Re: V$ tables interrogate [message #596772 is a reply to message #596767] Thu, 26 September 2013 05:11 Go to previous messageGo to next message
pablolee
Messages: 2655
Registered: May 2007
Location: Scotland
Senior Member
It's a really bad idea to use your email as your user name. There will be programmes out there now, harvesting your email to use for a plethora of Phishing and spam mails.
icon2.gif  Re: V$ tables interrogate [message #596776 is a reply to message #596767] Thu, 26 September 2013 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You must ask your DBA to grant you the privileges to do so.

Re: V$ tables interrogate [message #596783 is a reply to message #596772] Thu, 26 September 2013 05:48 Go to previous messageGo to next message
Roachcoach
Messages: 1219
Registered: May 2010
Location: UK
Senior Member
pablolee wrote on Thu, 26 September 2013 11:11
It's a really bad idea to use your email as your user name. There will be programmes out there now, harvesting your email to use for a plethora of Phishing and spam mails.


Maybe it's his Boss's email address Laughing
Re: V$ tables interrogate [message #596786 is a reply to message #596783] Thu, 26 September 2013 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 19693
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Now that's a naughty but brilliant idea!
Re: V$ tables interrogate [message #596787 is a reply to message #596786] Thu, 26 September 2013 05:53 Go to previous messageGo to next message
strydod1@telkom.co.za
Messages: 2
Registered: September 2013
Location: Pretoria ZA
Junior Member
I need to interrogate these tables to verify if the ppid is valid in the process table of solaris. Platform has memory leak
Re: V$ tables interrogate [message #596789 is a reply to message #596783] Thu, 26 September 2013 05:55 Go to previous message
pablolee
Messages: 2655
Registered: May 2007
Location: Scotland
Senior Member
Roachcoach wrote on Thu, 26 September 2013 11:48
pablolee wrote on Thu, 26 September 2013 11:11
It's a really bad idea to use your email as your user name. There will be programmes out there now, harvesting your email to use for a plethora of Phishing and spam mails.


Maybe it's his Boss's email address Laughing



Thumbs Up
You're seriously considering that Mark, aren't you?
Previous Topic: splitting 1 output row into 3 output rows
Next Topic: How to get first Word from string
Goto Forum:
  


Current Time: Thu Oct 23 10:28:10 CDT 2014

Total time taken to generate the page: 0.05714 seconds