ACTIVE DB DUPLICATION

TEP 1: CREATE PASSWORD FILES ON SOURCE AND TARGET. THE SYS PASSWORDS SHOULD BE SAME. orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwTARGETZ password=sys entries=10 orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwSDB password=sys entries=10 STEP 2: ADD TNSENTRY ON BOTH THE SERVERS FOR BOTH THE DBS. SDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = test1.telenor.com)(PORT = 1521))     (CONNECT_DATA =       (SERVER

ALTER PARTITIONS

ALTER TABLE CB.SDPDUMP_SUBSCRIBER ADD PARTITION Y2013M11D02 VALUES LESS THAN (TO_DATE(‘ 2013-11-03 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) TABLESPACE SDPDUMP_SUBSCRIBER_DTS_OCT13;ALTER TABLE CB.SDPDUMP_SUBSCRIBER ADD PARTITION Y2013M11D03 VALUES LESS THAN (TO_DATE(‘ 2013-11-04 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) TABLESPACE SDPDUMP_SUBSCRIBER_DTS_OCT13;ALTER TABLE CB.SDPDUMP_SUBSCRIBER ADD PARTITION Y2013M11D04 VALUES LESS THAN (TO_DATE(‘ 2013-11-05 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) TABLESPACE SDPDUMP_SUBSCRIBER_DTS_OCT13;ALTER TABLE CB.SDPDUMP_SUBSCRIBER ADD PARTITION Y2013M11D05 VALUES

RMAN BACKUP

SQL> select current_scn from v$database; CURRENT_SCN ———–     3114652 SQL> archive log list Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /u01/NEWDB/ARC Oldest online log sequence     131 Next log sequence to archive   133 Current log sequence           133 SQL> select current_scn from v$database; CURRENT_SCN ———–     3114672 SQL> alter system switch logfile; System altered.

Index becoming unusable again and again

The application team was complaining about slow response. My reaction was to run a few queries to check the response. The SQL seem to be slow. The explain plan showed that the indices were not getting hit and the queries were doing full table scan. On checking the table structure the indices were Invalid (Two

Full table scan not hitting an index

What do you say to that? Dears; Kindly bee Informed after I ask you to Analyze below tables: b.pay, b.rec, b.trans When I chek above tables “Table Access full” appears so would you plz chec it agai why after analyze and re index tables still full. Of course :(:( …!!! Why would select all from

enq: TT – contention

enq: TT – contention.

enq: TT – contention

enq: TT – contention:The TT enqueue  is used to avoid deadlocks in parallel tablespace operations.  The TT enqueue can be seen with parallel create tablespace and parallel point in time recovery (PITR) REFERENCE : the definitive guide SELECT DECODE(request,0,’Holder: ‘,’Waiter: ‘) || sid sid, id1, id2, lmode, request, type, inst_id FROM GV$LOCK WHERE (id1, id2,

FAST COMMIT

FAST COMMIT.

FAST COMMIT

REFERENCE : ORACLE DATABASE 10g: SQL TUNING 1. The server process places a commit record, along with the scn, in the redo log buffer. 2. The LGWR performs a contiguous write of all the redo log buffer entries up to and including  the commit record to the redo log files.  After this point, the Oracle

ORA-00600: internal error code arguments:kcblasm_1, 103

ORA-00600: internal error code arguments:kcblasm_1, 103.