Difference between revisions of "Recompile invalid objects"
From dbawiki
(Created page with "==Recompile invalid objects== *Connect to an Oracle database as user sys *Check to see how many objects are invalid: select count('e') from dba_objects where status='INVALID...") |
(→Recompile invalid objects) |
||
| Line 1: | Line 1: | ||
| − | + | *Connect to an Oracle database as user ''sys'' | |
| − | |||
| − | *Connect to an Oracle database as user sys | ||
*Check to see how many objects are invalid: | *Check to see how many objects are invalid: | ||
Latest revision as of 19:40, 6 December 2011
- Connect to an Oracle database as user sys
- Check to see how many objects are invalid:
select count('e') from dba_objects where status='INVALID';
- Recompile all invalid objects:
exec utl_recomp.recomp_serial();
