Answer / mohapatra.gouranga@gmail.com

Data Guard Redo Transport Services coordinate the
Log Network Server (LNS);
transmission of redo from the primary database to the
standby database, at the same time the LGWR is processing
redo, a separate Data Guard process called the Log Network
Server (LNS) is reading from the redo buffer in the SGA and
passes redo to Oracle Net Services from transmission to a
standby database, it is possible to direct the redo data to
nine standby databases, you can also use Oracle RAC and
they don't all need to be a RAC setup. The process Remote
File Server (RFS) receives the redo from LNS and writes it
to a sequential file called a standby redo log file (SRL),
the LNS process support two modes synchronous and
asynchronous.

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---