Answer / Neetu Sinha

DBMS_STATS offers several benefits over ANALYZE:

1. Automatic sampling: DBMS_STATS collects statistics based on a sample of data blocks, which reduces the I/O overhead and improves performance compared to full-table scans performed by ANALYZE.

2. Customizable sampling method: You can configure the sampling method (e.g., DBMS_STATS.SET_SAMPLING) according to your specific requirements, unlike with ANALYZE which uses a fixed block sampling method.

3. Automatic gathering of statistics for index-organized tables and materialized views.

4. Dynamic performance tuning: DBMS_STATS can be scheduled as part of a database maintenance job to ensure that statistics are always up-to-date, helping to maintain optimal query performance.

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

Explain 1st, 2nd, 3rd normalization form of data base

3 Answers   KH, Thermotech,

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

What is the best way to do multi-row insert in oracle?

1 Answers  

---

what is the syntax of DELETE command?

8 Answers  

---

Explain about your project and its relation to the current job position you are applying to?

1 Answers  

---

Is rowid unique in oracle?

1 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1 Answers   Sierra Atlantica,

---

Explain how are indexes update?

1 Answers  

---

What is the parameter mode that can be passed to a procedure?

1 Answers  

---

How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  

---

What is the difference between alert log file and tarce file ?

1 Answers   TCS,

---