• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: WO and Memory Management
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: WO and Memory Management


  • Subject: Re: WO and Memory Management
  • From: Mike Schrag <email@hidden>
  • Date: Fri, 14 Jul 2006 09:34:12 -0400

You can get a query execution plan from Oracle and see exactly which indexes are and are not being used (with the "explain plan" command -- it requires a little setup first).  You can also install statspack (I think this is renamed now?) and get extensive debugging stats from it.

On Jul 14, 2006, at 1:11 AM, Owen McKerrow wrote:

DOH ! **Hits self in the head** Thats one thing I need to do when there DBA gets back from holidays :) We moved the DB from OpenBase to Oracle and we haven't been back an applied indexing yet : )


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >WO and Memory Management (From: Owen McKerrow <email@hidden>)
 >Re: WO and Memory Management (From: Chuck Hill <email@hidden>)
 >Re: WO and Memory Management (From: Owen McKerrow <email@hidden>)
 >Re: WO and Memory Management (From: Chuck Hill <email@hidden>)
 >Re: WO and Memory Management (From: Owen McKerrow <email@hidden>)

  • Prev by Date: Re: WO & WYSIWG textarea editor
  • Next by Date: Re: WO and Memory Management
  • Previous by thread: Re: WO and Memory Management
  • Next by thread: Re: WO and Memory Management
  • Index(es):
    • Date
    • Thread