Answer / shiva

After we have verified that STATSPACK is installed and working, we can schedule automatic data collection. By using the statsauto.sql script we can automatically schedule an hourly data collection for STATSPACK. The statsauto.sql script contains the following directive:

SQL> execute dbms_job.submit(:jobno, 'statspack.snap;',
trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);

why we use cursors

1 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

How do you resize a data file?

2 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

how can you record information about current session?

0 Answers   Oracle,

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---