OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » wired issue

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

wired issue [message #231683]

Wed, 18 April 2007 02:05

kaisy.lin
Messages: 12
Registered: April 2007

Junior Member

i know that there is a view named V$parameter for dba .but i can only find out V$paramter2 in my database .

Report message to a moderator

Re: wired issue [message #231693 is a reply to message #231683]

Wed, 18 April 2007 02:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> select NAME from v$fixed_table where name LIKE 'V$PARA%';

can you post output of above query...

regards
Taj

Report message to a moderator

Re: wired issue [message #231717 is a reply to message #231683]

Wed, 18 April 2007 04:16

kaisy.lin
Messages: 12
Registered: April 2007

Junior Member

the following is the output:

NAME
------------------------------
V$PARAMETER
V$PARAMETER2
V$PARALLEL_DEGREE_LIMIT_MTH

meanwhile , i have another question that how can i find out all the sql text that requested from all the client

Report message to a moderator

Re: wired issue [message #231719 is a reply to message #231717]

Wed, 18 April 2007 04:25

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you have another question create a new topic in the correct forum. Your current has nothing to do in "Backup & Recovery" forum.

Regards
Michel

Report message to a moderator

Previous Topic:	issue about imp command
Next Topic:	backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 13:44:36 CDT 2024