Sql workshop

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report

14p trinh02 28-01-2013 73 4   Download

Preparation • Get INVALID Objects: • SQL SELECT UNIQUE object_name, object_type, owner SQL SELECT UNIQUE object_name, object_type, owner FROM dba_objects WHERE status='INVALID'; FROM dba_objects WHERE status='INVALID'; Recompile invalid objects in SYS and SYSTEM with utlrp.sql Compare invalid objects from before and after the upgrade • • Beginning with 11.1.0.7 the comparison has been automated registry$sys_inv_objs, registry$nonsys_inv_objs = utluiobj.sql • Get accurate performance statistics • Comparison: before ↔ after • Time specific...

20p vongsuiphat 04-01-2010 125 38   Download