b.r.reddy


{ City } gurgaon
< Country > india
* Profession * oracle dba
User No # 40306
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 8
Users Marked my Answers as Wrong # 3
Questions / { b.r.reddy }
Questions Answers Category Views Company eMail




Answers / { b.r.reddy }

Question { 3795 }

From the database level, how can you tell under which time
zone a database is operating?


Answer

Select dbtimezone from dual;

Is This Answer Correct ?    4 Yes 1 No

Question { 5113 }

What's the benefit of "dbms_stats" over "analyze"?


Answer

We can manually set the statistical values.
We can gather statistics in parallel mode.

Is This Answer Correct ?    4 Yes 2 No