Dba_indexes
Identify Indexed Columns in Oracle Database Tables
Mar 19, 2024 / · 9 min read · indexing oracle indexes dba_ind_columns user_ind_columns all_ind_columns dba_indexes dba_ind_expressions ·Identify Indexed Columns in Oracle Database Tables Purpose Which columns does this index cover, and in what order? A developer asks it before adding an index that might already exist. A DBA asks it when a query scans a whole table and the team swears an index is in place. The answer is in the data dictionary, one row …
Read MoreOracle: Identify Large Indexes with SQL and DBA_SEGMENTS
Mar 17, 2024 / · 4 min read · dba_indexes dba_segments storage optimization peformance sql dba_ts_quotas ·Optimizing Your Oracle Database: A Guide to Identifying Large Indexes with SQL Keeping your Oracle Database running smoothly requires constant monitoring and optimization. Indexes, a crucial component for efficient data retrieval, can sometimes grow excessively, impacting performance. This blog post dives into a …
Read MoreOracle DBA SQL Scripts and Database Commands
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read More