Shoumadip Das - Page 3 of 4 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…

GLOBAL TEMPORARY TABLE Applications often use some form of temporary data store for processes that are too complicated to complete…

Oracle database allocates logical space for all data in the database. Logical storage structures are recognized by Oracle DB and…

When base tables contain large amount of data, it is expensive and time-consuming to compute the required aggregates or to…

INDEX SCAN define how the Optimizer will traverse the index block to get the result. It is a access path…

Oracle Database Cache improves the scalability and performance of applications that access Oracle databases by caching frequently used data on…

Index Organized Tables ( IOT ) have their primary key data and non-key column data stored within the same B*Tree…

In PL/SQL,we can use both VARRAY & NESTED TABLE collection type as table column datatype. The difference between these implementation…

CONCURRENT access is accessing same data by multiple users at the same time. • SHARED lock is acquired when user…

What Is A Transaction ? Transaction is logically joining multiple SQL statements (unit of work) which we can either commit/rollback.In…

WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…