Knowledge transfer to Wisdom

Labels

Blog (2)
Home (1)
Interview (6)
oracle scritpts (3)

Monday, December 20, 2010

Redo generation for SQL query in oracle database

at 10:05 PM

No comments:

Labels

Installation
Oracle Installation
RMAN
Interview
Patch
oracle 12c
Export and Import
Performance Tunning
oracle scritpts
Blog
VMware
ASM
Cloning Database
Data Guard
Disscussion
Home
Migration
RAC
schema management
space_administration

Total Pageviews

Blog Followers

Popular Posts

Oracle 12c:--ORA-65096: invalid common user or role name

Command prompt SQL> create user 12ctest identified by 12ctest; create user 12ctest identified by 12ctest * ERROR at...
Recover database when online redolog file is corrupted.

Oracle Database can be operates in two modes. 1. Archive log mode (The archive logs are generated and online backup is possible) ...
What happen during begin backup mode in oracle ?

Below activity happen during begin backup mode. DBWn checkpoints the tablespace (writes out all dirty blocks as of a given SCN...
Oracle DBA Interview Questions

Oracle DBA interview 09-Feb-2012 :- 1)What are the basic steps in upgrading 10g to 11g? 2)What is the difference between opatch napply ...
ORA-16401: archivelog rejected by RFS

Errors found in the alertlog file of oracle database. Tue Sep 27 12:09:10 2011 Errors in file /home/app/oracle/admin/pri/bdump/pri_arcr_4...
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Solution of the Error Step 1: Check permission on /etc/hosts $ ls -l /etc/hosts -rw-r--r-- 1 root root 153 Nov 24 2007 /etc/hosts Not...
ORA-28007: the password cannot be reused

SQL> alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxxx'; alter user "BACMONIT" IDENTIFIED BY VALUES '...
to check current temporary tablespace usage

--------- current tempoary tablespace usage --------------- SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_...
How to modify ASM diskgroup redundancy to external.

Steps to convert the asm disk group redundancy from normal to external DB: ==== shutdown immediate; startup mount; backup device t...
RMAN Recovery scenarios

Pre-requisite for RMAN RMAN recovery scenarios require that the database is in archive log mode, and that backups of datafiles, ...

Pages

Home

Labels

Interview
oracle 12c
oracle scritpts
RMAN

Watermark theme. Powered by Blogger.

Labels

Monday, December 20, 2010

Redo generation for SQL query in oracle database

No comments:

Post a Comment

Labels