TOAD is not for advanced Oracle DBA stuff... it's very light... it cant match Oracle's SQL ANALYZE....
Printable View
TOAD is not for advanced Oracle DBA stuff... it's very light... it cant match Oracle's SQL ANALYZE....
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.
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...