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;

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

Hot backup procedure?

2 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

what is asm?

0 Answers   Oracle,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---