
98
|
Toad Pocket Reference for Oracle
lets you create a synchronization script to bring the schemas
into uniformity. It will work for schemas on the same
instance or on different instances. Note that this function
does not examine data.
TIP
If you want to compare the data between two tables or
views, then consider using Toad’s Compare Data screen
found under the Tools menu.
Compare Schemas does not provide details on database-level
objects such as users and tablespaces, but you can use DBA
➝ Compare Databases for this purpose. The Compare Data-
bases window lets you compare two databases and tells you
what has changed from the original reference source to the
comparison source.
Performing SGA Trace Optimization
You can use Tools ➝ SGA Trace Optimization to view infor-
mation about SQL statements that have been executed and
the resources used by those statements. While Auto Trace
and TKPROF information are specific to a single statement,
SGA Trace Optimization displays statistics from multiple
SQL statements currently present in Oracle’s System Global
Area (SGA).
Go to Tools
➝ SGA Trace Optimization to open the SGA
Trace window. You can set several options from this screen
in order to search for SQL statements. The default settings
are for “ALL Statements” for “ALL Users”, but you can click
on the corresponding dropdown list and choose another
option to change these choices. You can limit the selection to
a