Dba_objects
Oracle: Uninstall Statspack Using the spdrop Script
Sep 6, 2025 / · 5 min read · oracle database statspack database administration performance tuning sql plus oracle dba database cleanup oracle scripts dba_objects dba_users ·How to Uninstall Oracle Statspack Using the spdrop Script - Complete Guide Oracle Statspack uninstallation is accomplished using the @?/rdbms/admin/spdrop command, which completely removes the Statspack performance monitoring framework from your Oracle database. This command removes all associated objects including the …
Read MoreIdentifying Locked Rows in Oracle Using v$session
Identifying Locked Rows in Oracle Database using tables v$session and dba_objects Purpose At 09:00 a user reports that an order screen has frozen. The user pressed Save, and nothing happens. The session is not busy with work. It is waiting. Another transaction changed the same row and has not finished, so the database …
Read MoreIdentify Locked Objects in Oracle Database
Sep 3, 2024 / · 16 min read · Oracle Database Administration SQL v$locked_object dba_objects v$lock v$session v$transaction ·Identify Locked Objects in Oracle Database using v$locked_object, dba_objects, v$lock and v$session Purpose A developer reports that an INSERT that should finish in seconds is still running after ten minutes. No error has come back to the application, no timeout has fired, and nothing is moving. In the vast majority of …
Read MoreOracle DBA_OBJECTS: List All Objects Owned by a User
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 …
Read MoreHow 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 …
Read MoreIdentify and Fix Invalid Objects in Oracle Database
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 …
Read MoreOracle Recompile Invalid Objects with utlrp.sql
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 …
Read MoreShows the distribution of objects and data across all schemas using dba-segments & dba_objects Gain insights into object distribution across database users and their corresponding storage usage for data management, capacity planning, and optimization. Which schemas are taking up all of the space? SQL Code 1set pages …
Read More