TOAD is not for advanced Oracle DBA stuff... it's very light... it cant match Oracle's SQL ANALYZE....
-nagarjuna
I still prefer TOAD when running SQL, creating/editiing packages/procs/functions. Viewing the scripts for objects examining what segments via tablespaces etc, seeing contraints, indexes etc for associated objects.
OCP 8i, 9i DBA Brisbane Australia
I said we have SQL ANALYZE in OEM.. for very advanced DBA stuff like tuning the SQL query with index building simulation kinda stuff... regular works... we can use TOAD because it loads faster than OEM... but, TOAD is not for the advanced things...
Forum Rules