Home » RDBMS Server » Backup & Recovery » wired issue
wired issue [message #231683] Wed, 18 April 2007 02:05 Go to next message
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 .
Re: wired issue [message #231693 is a reply to message #231683] Wed, 18 April 2007 02:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi

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


can you post output of above query...

regards
Taj

Re: wired issue [message #231717 is a reply to message #231683] Wed, 18 April 2007 04:16 Go to previous messageGo to next message
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
Re: wired issue [message #231719 is a reply to message #231717] Wed, 18 April 2007 04:25 Go to previous message
Michel Cadot
Messages: 64153
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
Previous Topic: issue about imp command
Next Topic: backup
Goto Forum:
  


Current Time: Sun Dec 11 07:53:51 CST 2016

Total time taken to generate the page: 0.23292 seconds