Home / Tag Archives: SIZE

Tag Archives: SIZE

Managing Indexes

Managing Indexes About Indexes Indexes are optional structures associated with tables and clusters that allow SQL queries to execute more quickly against a table. Oracle Database provides several indexing schemes that provide complementary performance functionality. These are: ■B-tree indexes: the default and the most common ■B-tree cluster indexes: defined specifically …

Read More »

Overview of Data Blocks

Overview of Data Blocks Oracle Database manages the logical storage space in the data files of a database in units called data blocks, also called Oracle blocks or pages. A data block is the minimum unit of database I/O. Data Blocks and Operating System Blocks At the physical level, database …

Read More »

Using the Result Cache

Using the Result Cache

Using the Result Cache You can improve the response times of frequently executed SQL queries by using the result cache. The result cache stores results of SQL queries and PL/SQL functions in a new component of the SGA called the Result Cache Memory. The first time a repeatable query executes, …

Read More »

ASMM (AUTOMATIC SHARED MEMORY MANAGEMENT)

ASMM (AUTOMATIC SHARED MEMORY MANAGEMENT) In 9i, SGA has been made dynamic i.e. sizes of SGA components can be changed without shutting down the database. (not possible in 8i) Many times DBA’s faced problem in calculating correct memory sizes which lead to performance problems in instance level and DBA’s are …

Read More »

COMPONENTS OF ORACLE DATABASE ARCHITECTURE

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

COMPONENTS OF ORACLE DATABASE ARCHITECTURE USER PROCESS : It is the process which places request from client side and will be created when user starts any application. SERVER PROCESS : It is the process which will do work on behalf of user process on server side. PRIVATE GLOBAL AREA (PGA) …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe