Objects

Unveiling the Mystery: Demystifying an Oracle SQL Code Snippet for Object Size Analysis In the ever-evolving realm of database management, efficient resource utilization is paramount. Oracle, a widely recognized database management system, offers powerful tools to help optimize storage and performance. This blog post …

Unveiling Your Database Toolkit: Exploring Objects Owned by a User in Oracle In the intricate world of database management, understanding the landscape of objects is crucial for efficient operation. This blog post empowers you to leverage a specific Oracle Database SQL code snippet to list all objects owned by a …

How to Search for Objects in Oracle Database This post explains how to search for objects (tables, views, sequences, etc.) in an Oracle database using SQL. Sample SQL Command 1set pages 999 2col owner format a15 3col object_name format a40 4col object_type format a20 5select owner 6, object_name 7, object_type 8from …

How to Identify and Fix Invalid Objects in an Oracle Database Purpose A list of invalid objects tells you more than it first seems to. Ten invalid objects in one application schema right after a release can point to one changed table. Hundreds of invalid objects across many schemas more often follow a patch or an …

Oracle Recompile Invalid Objects with utlrp.sql Purpose Recompiling invalid objects is a routine job that follows an upgrade or a patch. You run one Oracle-supplied script, and the database works through every invalid object, so users do not meet them one by one. The script is utlrp.sql. It lives in the …

Show the ten largest oracle objects in the database using dba_segments Capacity planning starts with knowing which segments hold the most space. DBA_SEGMENTS describes the storage allocated for all segments in the database, so one sorted query shows the ten biggest consumers. SQL Code 1col owner format a15 2col …