Dba_ts_quotas
Oracle: 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 MoreHow to Query User Quotas in Oracle Database The code below retrieves and displays information about user quotas on all tablespaces excluding the temporary tablespace (TEMP) on a Oracle database. Sample SQL Command 1col quota format a10 2select username 3tablespace_name 4decode(max_bytes, -1, 'unlimited', ceil(max_bytes …
Read More