Home / K Sravya

K Sravya

Shared Server Architecture

Shared Server Architecture In a shared server architecture, a dispatcher directs multiple incoming network session requests to a pool of shared server processes, eliminating the need for a dedicated server process for each connection. An idle shared server process from the pool picks up a request from a common queue. …

Read More »

Overview of Background Processes

Overview of Background Processes Process Monitor Process (PM ON) The process monitor (PM ON) monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally. PM ON is responsible for cleaning up the database buffer cache and freeing resources that the client process was …

Read More »

Server Result Cache

Server Result Cache

Server Result Cache Unlike the buffer pools, the server result cache holds result sets and not data blocks. The server result cache contains the SQL query result cache and PL/SQL function result cache, which share the same infrastructure. A client result cache differs from the server result cache. A client …

Read More »

Overview of the System Global Area

System Global Area

Overview of the System Global Area The SGA is a read/write memory area that, along with the Oracle background processes, makes up a database instance. All server processes that execute on behalf of users can read information in the instance SGA. Several processes write to the SGA during database operation. …

Read More »

ADR Structure

ADR Structure The ADR base is the ADR root directory. The ADR base can contain multiple ADR homes, where each ADR home is the root directory for all diagnostic data—traces, dumps, the alert log, and so on—for an instance of an Oracle product or component. Alert Log Each database has …

Read More »

Oracle 10G New Features Of Data Gaurd

What’s New in Oracle Data Guard 10g Release 2? Fast-Start Failover This capability allows Data Guard to automatically, and quickly fail over to a previously chosen, synchronized standby database in the event of loss of the primary database, without requiring any manual steps to invoke the failover, and without incurring …

Read More »

Brief Description of Oracle DATAGUARD

OVERVIEW DATAGUARD Oracle Data Guard is one of the most effective and comprehensive data availability, data protection and disaster recovery solutions available today for enterprise data.Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data …

Read More »

Oracle FLASHBACK DATABASE

FLASHBACK DATABASE Database must be in archivelog mode and flashback should be enabled for performing this. When placed in flashback mode, we can observe flashback logs getting generated in flash_recovery_area — Create a dummy table. CONN scott/tiger CREATE TABLE flashback_database_test (id  NUMBER(10) ); — Flashback 5 minutes. CONN sys/password AS SYSDBA …

Read More »

FLASHBACK TRANSACTION QUERY

FLASHBACK TRANSACTION QUERY—————————————————- SELECT xid, operation, start_scn,commit_scn, logon_user, undo_sql FROM   flashback_transaction_query WHERE  xid = HEXTORAW(‘0600030021000000’); update “SCOTT”.”FLASHBACK_VERSION_QUERY_TEST” set “DESCRIPTION” = ‘ONE’ where ROWID = ‘AAAMP9AAEAAAA AYAAA’; FLASHBACK TABLE—————————– Flashback table requires following privileges1) FLASHBACK ANY TABLE or FLASHBACK object2) SELECT,INSERT,DELETE and ALTER privs on table3) Row movement must be enabled CREATE TABLE …

Read More »

FLASHBACK FEATURES

FLASHBACK FEATURES FLASHBACK QUERY—————————– CREATE TABLE flashback_query_test (  id  NUMBER(10)); SELECT current_scn, TO_CHAR(SYSTIMESTAMP, ‘YYYY-MM-DD HH24:MI:SS’) FROM v$database; CURRENT_SCN TO_CHAR(SYSTIMESTAM ———– ——————-     722452 2004-03-29 13:34:12 INSERT INTO flashback_query_test (id) VALUES (1); COMMIT; SELECT COUNT(*) FROM flashback_query_test; COUNT(*) ———-         1 SELECT COUNT(*) FROM flashback_query_test AS OF TIMESTAMP TO_TIMESTAMP(‘2004-03-29 13:34:12’, ‘YYYY-MM-DD HH24:MI:SS’); COUNT(*) …

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