Toad World® Forums

Optimizer doesn't upgrade objects


#1

Hola a todos,

Soy un amigo de Toad, necesito un grande favor si me puedes ayudar.

EnQuest SQL Optimizer fork Oracle, modulo SQL Scanner, creo un job y enla BD elimino un paquete pero en el Optimizer me sigue saliendo esepaquete.

Debe ser algun chache o algo asi porque los cambios realizados en la BD no se reflejan en el Optimizer, como hago?

Muchas gracias.



Hello,

I am a friend of Toad, I need a big favor if you can help me.

InQuest SQL Optimizer fork Oracle, I modulate SQL Scanner, I believe ajob and in the BD I eliminate a package but in the Optimizer it followsme leaving that package.

Should some chache be or something like that because the changescarried out in the BD are not reflected in the Optimizer, like I make?

Thank you.


#2

Hi,

There are different ways to add database objects in SQL Scanner. In the Add Scanner Jobs window, under the Database Objects page, the database objects are organized by users or by types.

If you were using the “Objects by Users” nodes, you can expand it to see different users and then different types of objects under each user. You can add the “User” node to the right and if you do that all objects under this user would be scanned (so this will include the packages under this user). If you add only a particular type of object (e.g. “Functions”) to the right, only that type of objects under that user would be scanned. And if you further expand the type of objects, you should see the actual object name. You can then add a particular object to the right to scan.

If you are using the “by types” nodes, you can also add a type of object (which include the selected type of object under any users) or add an individual object by expanding the type.

Another option you may check is the “Include Dependents” checkbox on the list of selected objects. This option is unchecked by default. When checked, the SQL Scanner will look for other objects used by your selected object and include them in the scanning process. For example, if you have a function F1 that uses a package Pkg1. If you selected only F1 to scan but checked the “Include Dependents” option, then the SQL Scanner will actually add F1 and Pkg1 into the group to scan.

I hope that I have understood your question correctly and that my answer helped. If not, please elaborate your question further.

Thanks,
Alex


#3

Hola Julian.

Lo que pasa es que cuando usas el SQL Scanner los objectos que se agregan se va guardando un referencia en un archivo del SQL Scanner (puedes checar options, General, Directories si tienes curiosidad donde graba el SQL Scanner la informacion).
Si borras un objeto en un bd, el SQL Scanner no lo sabe por que lo grabo fue una liga. La unica forma de refrescar los objectos es que borres ese grupo y crees otro group agregando de nuevo los objectos. O puedes borrar de tu grupo ese objecto que es invalido.

De donde nos escribes? Que tal de parece el SQL Optimizer?

Muchas gracias por tu pregunta.

Saludos,
Claudia