Improve Query on Dictionary and Dynamic Views
Query on Views At times, I found that the query to check tablespace usage was running slowly. In the query, we retrieve some data from… Read More »Improve Query on Dictionary and Dynamic Views
Data Dictionary View
DATABASE_PROPERTIES, How and Why
DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »DATABASE_PROPERTIES, How and Why
Prefix DBA, ALL, USER Mix & Match
Scopes of Data Dictionary Views There're 3 different scopes of data dictionary views, DBA, ALL and USER. You may think all dictionary views always have… Read More »Prefix DBA, ALL, USER Mix & Match
How Oracle Search View Text in ALL_VIEWS
ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »How Oracle Search View Text in ALL_VIEWS
How to Check Oracle Segment Size
Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »How to Check Oracle Segment Size
How to Find Biggest Tables in Oracle
Top 10 Biggest Tables in Whole Database When the disk space is running out, you might want to calculate Oracle table size and list the… Read More »How to Find Biggest Tables in Oracle
How to List All Tables in Oracle
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… Read More »How to List All Tables in Oracle