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
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
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
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
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