CODEWITHSUNDEEP
oracle-databasetoad
Alfredo Osorio
Alfredo Osorio

Reputation: 11475

What command should I use to get the actual value of a parameter in Toad for Oracle?

I'm trying to get the actual value of OPTIMIZER_SECURE_VIEW_MERGING in Toad for Oracle but I don't know how.

Upvotes: 0

Views: 1607

Answers (1)

OldProgrammer
OldProgrammer

Reputation: 12169

Try this:

select * 
from v$parameter
where upper(name) = 'OPTIMIZER_SECURE_VIEW_MERGING'

See Oracle doc for details on v$parameter Your login would need read access to the v$parameter view. FYI, there is no dependency on TOAD for this - just a straight SQL query, can be run from any SQL client.

I am running TOAD 12, and you can also view all the current oracle parameters from the Database/Administer/Oracle Parameters menu item.

Upvotes: 3

Related Questions