Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SET TIME_STATISTICS

Status
Not open for further replies.
oracle8

oracle8

MIS
Sep 30, 2000
69
PH
Merry Christmas to everyone!!!

Is there any problem that would crop up in our database or OS after setting the TIMED_STATISTICS to true. We are using oracle 8.05 in NT box. Any genuine ideas pls.

Thanks,

Rommel
 
Sort by date Sort by votes
You can enable TIMED_STATISTICS on session-level (alter session set timed_statistics=true).

Stefan
 
Upvote 0 Downvote
Well there is not problem in putting up TIMED_STATISTICS parameter to true, it will actually be very userful in knowing many performance statistics based on time for eg if you wish to use the v$waitstat view to show which resources are currently waiting for resources to be allocated to them

TBTL
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
127
jandresHDS
J
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
416
fredericofonseca
fredericofonseca
yorge
  • Locked
  • Question
Return unique row from a given set of rows 2
Replies
3
Views
201
cmmrfrds
cmmrfrds
CrystalProgDev
  • Locked
  • Question
set Variable value
Replies
4
Views
217
SantaMufasa
SantaMufasa
sonofsa
  • Locked
  • Question
Processing a result set output to a Table
Replies
8
Views
238
sonofsa
sonofsa

Part and Inventory Search

Sponsor

Back
Top