Data Dictionary View Sets Comparison
DBA_, ALL_ and USER_ Views You may think all dictionary views have their corresponding ones in different sets or scopes. For example, I'd like to… Read More »Data Dictionary View Sets Comparison
Data Dictionary View
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