-- Find invalid objects
select OWNER , OBJECT_TYPE , OBJECT_NAME,STATUS
from dba_objects
where status != 'VALID'
order by owner, object_type;
-- Recompile invalid objects
select 'ALTER ' OBJECT_TYPE ' ' OWNER '.' OBJECT_NAME ' COMPILE;'
from dba_objects
where status = 'INVALID'
Subscribe to:
Post Comments (Atom)
-
* Stored procedures generally result in improved performance because the database can optimize the data access plan used by the procedure an...
-
Why TempDB Grows and Doesn’t Reset Easily TempDB Usage Causes: TempDB is a global workspace for SQL Server, used for sorting, hashing, ...
-
If you need to make small changes to an existing database object, then you will need to do some impact assessment to determine what SQL Serv...
No comments:
Post a Comment