Answer / guest

alter system switch logfile


Regards
Abhinav Phadnis

Answer / rajesh naidu

ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH

Answer / senthil

By this way also you can force log switch:

ALTER SYSTEM CHECKPOINT

FAST_START_MTTR_TARGET="timeSpecification"

Answer / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

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

2 Answers   CSC,

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

what is the use of ocr?

0 Answers   Oracle,

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---