otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch

 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Performance, Scalability and HA Optimizing the performance of OTM / G-Log, configuring Scalability (SCA) and maintaining High Availability.

Tags: , , ,

Reply
Page 2 of 2 < 1 2
 
Submit Tools LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old December 4th, 2007, 00:24
Senior Member and Blogger
  
Join Date: Dec 2006
Location: Singapore
Posts: 147
Blog Entries: 5
Thanks: 5
Thanked 11 Times in 10 Posts
Groans: 0
Groaned at 1 Time in 1 Post
Rep Power: 2
ianlo is on a distinguished road
Send a message via AIM to ianlo Send a message via Skype™ to ianlo
Re: OTM 5.5: VPD Query Performance - Improvements
Dear Suresh,

You are most welcome! Glad that it work well for you! I am also glad that we could co-relate the issues. I did found performance improvement with Oracle 10g optimisation after several weeks of running the gather_table_stats.sql. The built in ADDM process also did suggest further increase of the Oracle SGA as well as number of open cursors.

I got my DBA to run the ADDM report on a weekly basis to help me identify any other DB parameters that would require tweaking.

On a side note, you might want to check out Metalink Note: 467668.1 This details how to run the gather_table_stats.sql script to ensure stable performance.

Thanks and Best Regards,
Ian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 2 of 2 < 1 2

« Performance issue integration | Documentation on using EventDiagServlet page »


Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
stored query nikesh mohanlal Branding, Screen Sets, XSL/CSS and Translations 1 March 14th, 2008 21:39
saved query nikesh mohanlal Database Administration 0 February 28th, 2008 13:38
riq-saved query rj5316 Rating 1 December 14th, 2007 17:09
[INSTRUCTIONS] Testing VPD Query Performance chrisplough Database Administration 3 October 12th, 2007 14:47
VPD profile has negative effect on query performance blasley Reports / FTI and Other Analytics 8 September 18th, 2007 08:53



All times are GMT. The time now is 18:16.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37