-
Titel
Predefined filters in the session brower are no longer listed. -
Beschreibung
There use to be a few predefined filters included by default in Toad's Session Browser. But now they are no longer listed in either the drop down or in the filters pop up window. How do I get them back?
Example of some predefined filters:
TOAD filter --
SELECT * FROM V$SESSION s
WHERE
(
UPPER( s.PROGRAM )LIKE '%TOAD%'
)
STATUS - ACTIVE filter --
SELECT * FROM V$SESSION s
WHERE
(
s.STATUS = 'ACTIVE'
)
SERVER - DEDICATED --
SELECT * FROM V$SESSION s
WHERE
(
s.SERVER = 'DEDICATED'
) -
Ursache
Toad searches for the file TOAD_SESSBROWFILTERS.INI for this information.
Example:
c:\program files\quest software\toad for oracle\user files\TOAD_SESSBROWFILTERS.INI -
Lösung
Please check the Toad installation directory for the TOAD_SESSBROWFILTERS.INI file and see if there is any information in there. If none or incomplete please find another copy of this file with the filter informations still in the file and copy it over into the current install.
A copy of the default file for Toad for Oracle version 9.1 is attached below.