Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079