Hi,

What we think you have seen is a manifestation of Oracle bug 3539401.  Oracle
claim it has been resolved, but it wasn't.  The bug is identified as happening
on HP-UX 64 bit systems, but we have seen it on AIX platforms and now Red Hat. 
Spotlight automatically disables this query for HP-UX, in accordance with the
Oracle note.

As you can see, Spotlight has mechanisms to switch off queries, but at this
point, I don't think there are any others that I can identify that are likely to
be a concern.  Certainly, as mentioned by Scott Stone, you could consider using
the Performance Slider to select the "Lower Impact" setting, which amongst other
things will disable the query we have been discussing.  You could then
selectively re-enable certain queries as you need them.

For your interest, Oracle bug 3539401 is described as follows:

Symptoms

You are querying X$views and it takes a while to return the output.

Specifically if you query X$KSMSP, the DB almost hangs for a while, CPU usage is
almost 90% + till the query returns.

Cause

Querying X$KSMSP and other X$ views in turn calls slrac() function. Although
slrac() is mainly used in diagnostic code, it is called from other locations too
such as X$KSMSP and other X$ views.

If any code calls slrac() when the process has > 50 memory segments then repeat
OS calls to pstat_getprocvm() will occur.

slrac() on HPUX uses pstat_getprocvm() to check if the address being checked is
in a mapped segment in the OS process. On larger systems using large SGA sizes
it is possible for an Oracle OS process to have a large number of distinct
mapped segments. At present we only cache information about the first 50
segments so on such systems slrac() calls for addresses not in the first 50
segments always result in calls to pstat_getprocvm().

This OS call can be quite expensive.

If any code calls slrac() when the process has > 50 memory segments then repeat
OS calls to pstat_getprocvm() will occur, as the Oracle code only cache 50
entries of address mapping.


--- In spotonoracle@yahoogroups.com, Scott Stone <scott.stone@...> wrote:
>
> The simplest thing to do is use the performance slider that you can find under
the checkered flag icon.   It works like the security slider in Internet
Explorer to adjust several settings with one control.   Just by moving the
slider you can turn off the more expensive queries and slow down others.  You
can also increase the granularity for more information collected when
performance impact is less of a concern.
>
>
>
> From: spotonoracle@yahoogroups.com [mailto:spotonoracle@yahoogroups.com] On
Behalf Of colmenero_ignacio
> Sent: Friday, August 14, 2009 9:52 AM
> To: spotonoracle@yahoogroups.com
> Subject: [spotonoracle] Re: Spotlight causes my Oracle Production DB to
collapse
>
>
>
> Bill, one of my fellow DBAs has the following concern regarding Spotlight and
the issue we had yesterday:
> "Since this issue really hurt our production system today, I am worried about
my testing. Can you tell me if there is any other option/switch we should turn
off in advance? We are new to spotlight, so if you can give us a checklist about
all those issues which may hit performance in a heavy load environment like
ours, that would be great."
>
> Thanks again.
>

Bill, one of my fellow DBAs has the following concern regarding Spotlight and
the issue we had yesterday:
"Since this issue really hurt our production system today, I am worried about my
testing. Can you tell me if there is any other option/switch we should turn off
in advance? We are new to spotlight, so if you can give us a checklist about all
those issues which may  hit performance in a heavy load environment like ours,
that would be great."

Thanks again.
--- In spotonoracle@yahoogroups.com, "colmenero_ignacio" <ignacio.colmenero@...>
wrote:
>
> Thanks Bill for your prompt response.
> We'll try your suggestion tomorrow and let you know.
> In the meantime, the OS in our database server is: Red Hat Enterprise Linux AS
release 4 (Nahant Update 4) 2.6.9 42.ELsmp (64-bit)
>
> Thanks again,
> Ignacio.
> --- In spotonoracle@yahoogroups.com, "billjacobs2323" <bill.jacobs@> wrote:
> >
> > Hi Ignacio,
> >
> > This query can be problematic in some scenarios.  Spotlight actually
actively blocks it with certain OS / Database combinations.  A couple of things
to check/try.
> >
> > First: what operating system (eg HP-UX) are you using for your database
server?  And is it a 32 bit or 64 bit box?
> >
> > Second:  one thing you should try on your sandbox is to turn off the SGA
Storage Summary queries.
> >
> > With Spotlight on Oracle running and displaying the home page, click Tools |
Performance Settings (or click the flag in the toolbar).
> >
> > Select "Custom"
> >
> > Scroll down and select the line "SGA Storage Summary".
> >
> > In the lower dropdown, select "Do not refresh data in this category".
> >
> > Click OK, then OK.
> >
> > Now navigate to the SGA Utilization drilldown.  The SGA Storage Summary will
not be populated.  Do you still see the performance issue in that scenario?
> >
> > Regards ...
> > Bill Jacobs
> > Quest Software
> >
> > --- In spotonoracle@yahoogroups.com, "colmenero_ignacio"
<ignacio.colmenero@> wrote:
> > >
> > > I have to add that we just were able to duplicate the event in our sandbox
database. The problem occurs when we open the "SGA Utilization" screen from the
"Shared Pool" icon. The results are the ones I just mentioned.
> > >
> > > Thanks again.
> > > --- In spotonoracle@yahoogroups.com, "colmenero_ignacio"
<ignacio.colmenero@> wrote:
> > > >
> > > > Hi all.
> > > > We've been using Spotlight on trial for about a week on sandbox and
development databases, and we were quite happy with it. Today, we created a
connection to our Production database and within minutes our group was flooded
with phone calls from angry users that were complaining about the system.
> > > > I checked OEM and saw that the Spotlight user we created had blocked 62
user sessions.
> > > > The Spotlight query that seems to be the culprit is:
> > > > SELECT DECODE(ksmchcls, 'freeabl', '1',          --'Freeable'
> > > >                         'recr',    '2',          --'Re-creatable'
> > > >                         'R-freea', '1',          --'Freeable'
> > > >                         'R-recr',  '2',          --'Re-creatable'
> > > >                         'perm',    '3',          --'Permanent'
> > > >                         'R-free',  '4',          --'Reserved pool free'
> > > >                         'free',    '5',          --'Free'
> > > >                         'no acce', '6',          --'No Access'
> > > >                         ksmchcls) status,
> > > >        SUM(ksmchsiz) bytes
> > > >   FROM x$ksmsp
> > > >  WHERE inst_id = USERENV('INSTANCE')
> > > >  GROUP BY DECODE(ksmchcls, 'freeabl', '1',
> > > >                            'recr',    '2',
> > > >                            'R-freea', '1',
> > > >                            'R-recr',  '2',
> > > >                            'perm',    '3',
> > > >                            'R-free',  '4',
> > > >                            'free',    '5',
> > > >                            'no acce', '6',
> > > >                            ksmchcls)
> > > > Is there any way to overcome this issue? Is this a known bug?
> > > > I also checked an article by Jonathan Lewis related to being cautious
when using x$ and v$ objects.
> > > > The Database version is 10.2.0.4.0 and the Spotlight version is
6.1.0.1433.
> > > >
> > > > Thanks for any response.
> > > >
> > >
> >
>

Thanks Bill for your prompt response.
We'll try your suggestion tomorrow and let you know.
In the meantime, the OS in our database server is: Red Hat Enterprise Linux AS
release 4 (Nahant Update 4) 2.6.9 42.ELsmp (64-bit)

Thanks again,
Ignacio.
--- In spotonoracle@yahoogroups.com, "billjacobs2323" <bill.jacobs@...> wrote:
>
> Hi Ignacio,
>
> This query can be problematic in some scenarios.  Spotlight actually actively
blocks it with certain OS / Database combinations.  A couple of things to
check/try.
>
> First: what operating system (eg HP-UX) are you using for your database
server?  And is it a 32 bit or 64 bit box?
>
> Second:  one thing you should try on your sandbox is to turn off the SGA
Storage Summary queries.
>
> With Spotlight on Oracle running and displaying the home page, click Tools |
Performance Settings (or click the flag in the toolbar).
>
> Select "Custom"
>
> Scroll down and select the line "SGA Storage Summary".
>
> In the lower dropdown, select "Do not refresh data in this category".
>
> Click OK, then OK.
>
> Now navigate to the SGA Utilization drilldown.  The SGA Storage Summary will
not be populated.  Do you still see the performance issue in that scenario?
>
> Regards ...
> Bill Jacobs
> Quest Software
>
> --- In spotonoracle@yahoogroups.com, "colmenero_ignacio" <ignacio.colmenero@>
wrote:
> >
> > I have to add that we just were able to duplicate the event in our sandbox
database. The problem occurs when we open the "SGA Utilization" screen from the
"Shared Pool" icon. The results are the ones I just mentioned.
> >
> > Thanks again.
> > --- In spotonoracle@yahoogroups.com, "colmenero_ignacio"
<ignacio.colmenero@> wrote:
> > >
> > > Hi all.
> > > We've been using Spotlight on trial for about a week on sandbox and
development databases, and we were quite happy with it. Today, we created a
connection to our Production database and within minutes our group was flooded
with phone calls from angry users that were complaining about the system.
> > > I checked OEM and saw that the Spotlight user we created had blocked 62
user sessions.
> > > The Spotlight query that seems to be the culprit is:
> > > SELECT DECODE(ksmchcls, 'freeabl', '1',          --'Freeable'
> > >                         'recr',    '2',          --'Re-creatable'
> > >                         'R-freea', '1',          --'Freeable'
> > >                         'R-recr',  '2',          --'Re-creatable'
> > >                         'perm',    '3',          --'Permanent'
> > >                         'R-free',  '4',          --'Reserved pool free'
> > >                         'free',    '5',          --'Free'
> > >                         'no acce', '6',          --'No Access'
> > >                         ksmchcls) status,
> > >        SUM(ksmchsiz) bytes
> > >   FROM x$ksmsp
> > >  WHERE inst_id = USERENV('INSTANCE')
> > >  GROUP BY DECODE(ksmchcls, 'freeabl', '1',
> > >                            'recr',    '2',
> > >                            'R-freea', '1',
> > >                            'R-recr',  '2',
> > >                            'perm',    '3',
> > >                            'R-free',  '4',
> > >                            'free',    '5',
> > >                            'no acce', '6',
> > >                            ksmchcls)
> > > Is there any way to overcome this issue? Is this a known bug?
> > > I also checked an article by Jonathan Lewis related to being cautious when
using x$ and v$ objects.
> > > The Database version is 10.2.0.4.0 and the Spotlight version is
6.1.0.1433.
> > >
> > > Thanks for any response.
> > >
> >
>

Hi Ignacio,

This query can be problematic in some scenarios.  Spotlight actually actively
blocks it with certain OS / Database combinations.  A couple of things to
check/try.

First: what operating system (eg HP-UX) are you using for your database server? 
And is it a 32 bit or 64 bit box?

Second:  one thing you should try on your sandbox is to turn off the SGA Storage
Summary queries.

With Spotlight on Oracle running and displaying the home page, click Tools |
Performance Settings (or click the flag in the toolbar).

Select "Custom"

Scroll down and select the line "SGA Storage Summary".

In the lower dropdown, select "Do not refresh data in this category".

Click OK, then OK.

Now navigate to the SGA Utilization drilldown.  The SGA Storage Summary will not
be populated.  Do you still see the performance issue in that scenario?

Regards ...
Bill Jacobs
Quest Software

--- In spotonoracle@yahoogroups.com, "colmenero_ignacio" <ignacio.colmenero@...>
wrote:
>
> I have to add that we just were able to duplicate the event in our sandbox
database. The problem occurs when we open the "SGA Utilization" screen from the
"Shared Pool" icon. The results are the ones I just mentioned.
>
> Thanks again.
> --- In spotonoracle@yahoogroups.com, "colmenero_ignacio" <ignacio.colmenero@>
wrote:
> >
> > Hi all.
> > We've been using Spotlight on trial for about a week on sandbox and
development databases, and we were quite happy with it. Today, we created a
connection to our Production database and within minutes our group was flooded
with phone calls from angry users that were complaining about the system.
> > I checked OEM and saw that the Spotlight user we created had blocked 62 user
sessions.
> > The Spotlight query that seems to be the culprit is:
> > SELECT DECODE(ksmchcls, 'freeabl', '1',          --'Freeable'
> >                         'recr',    '2',          --'Re-creatable'
> >                         'R-freea', '1',          --'Freeable'
> >                         'R-recr',  '2',          --'Re-creatable'
> >                         'perm',    '3',          --'Permanent'
> >                         'R-free',  '4',          --'Reserved pool free'
> >                         'free',    '5',          --'Free'
> >                         'no acce', '6',          --'No Access'
> >                         ksmchcls) status,
> >        SUM(ksmchsiz) bytes
> >   FROM x$ksmsp
> >  WHERE inst_id = USERENV('INSTANCE')
> >  GROUP BY DECODE(ksmchcls, 'freeabl', '1',
> >                            'recr',    '2',
> >                            'R-freea', '1',
> >                            'R-recr',  '2',
> >                            'perm',    '3',
> >                            'R-free',  '4',
> >                            'free',    '5',
> >                            'no acce', '6',
> >                            ksmchcls)
> > Is there any way to overcome this issue? Is this a known bug?
> > I also checked an article by Jonathan Lewis related to being cautious when
using x$ and v$ objects.
> > The Database version is 10.2.0.4.0 and the Spotlight version is 6.1.0.1433.
> >
> > Thanks for any response.
> >
>

I have to add that we just were able to duplicate the event in our sandbox
database. The problem occurs when we open the "SGA Utilization" screen from the
"Shared Pool" icon. The results are the ones I just mentioned.

Thanks again.
--- In spotonoracle@yahoogroups.com, "colmenero_ignacio" <ignacio.colmenero@...>
wrote:
>
> Hi all.
> We've been using Spotlight on trial for about a week on sandbox and
development databases, and we were quite happy with it. Today, we created a
connection to our Production database and within minutes our group was flooded
with phone calls from angry users that were complaining about the system.
> I checked OEM and saw that the Spotlight user we created had blocked 62 user
sessions.
> The Spotlight query that seems to be the culprit is:
> SELECT DECODE(ksmchcls, 'freeabl', '1',          --'Freeable'
>                         'recr',    '2',          --'Re-creatable'
>                         'R-freea', '1',          --'Freeable'
>                         'R-recr',  '2',          --'Re-creatable'
>                         'perm',    '3',          --'Permanent'
>                         'R-free',  '4',          --'Reserved pool free'
>                         'free',    '5',          --'Free'
>                         'no acce', '6',          --'No Access'
>                         ksmchcls) status,
>        SUM(ksmchsiz) bytes
>   FROM x$ksmsp
>  WHERE inst_id = USERENV('INSTANCE')
>  GROUP BY DECODE(ksmchcls, 'freeabl', '1',
>                            'recr',    '2',
>                            'R-freea', '1',
>                            'R-recr',  '2',
>                            'perm',    '3',
>                            'R-free',  '4',
>                            'free',    '5',
>                            'no acce', '6',
>                            ksmchcls)
> Is there any way to overcome this issue? Is this a known bug?
> I also checked an article by Jonathan Lewis related to being cautious when
using x$ and v$ objects.
> The Database version is 10.2.0.4.0 and the Spotlight version is 6.1.0.1433.
>
> Thanks for any response.
>

Hi all.
We've been using Spotlight on trial for about a week on sandbox and development
databases, and we were quite happy with it. Today, we created a connection to
our Production database and within minutes our group was flooded with phone
calls from angry users that were complaining about the system.
I checked OEM and saw that the Spotlight user we created had blocked 62 user
sessions.
The Spotlight query that seems to be the culprit is:
SELECT DECODE(ksmchcls, 'freeabl', '1',          --'Freeable'
                         'recr',    '2',          --'Re-creatable'
                         'R-freea', '1',          --'Freeable'
                         'R-recr',  '2',          --'Re-creatable'
                         'perm',    '3',          --'Permanent'
                         'R-free',  '4',          --'Reserved pool free'
                         'free',    '5',          --'Free'
                         'no acce', '6',          --'No Access'
                         ksmchcls) status,
        SUM(ksmchsiz) bytes
   FROM x$ksmsp
  WHERE inst_id = USERENV('INSTANCE')
  GROUP BY DECODE(ksmchcls, 'freeabl', '1',
                            'recr',    '2',
                            'R-freea', '1',
                            'R-recr',  '2',
                            'perm',    '3',
                            'R-free',  '4',
                            'free',    '5',
                            'no acce', '6',
                            ksmchcls)
Is there any way to overcome this issue? Is this a known bug?
I also checked an article by Jonathan Lewis related to being cautious when using
x$ and v$ objects.
The Database version is 10.2.0.4.0 and the Spotlight version is 6.1.0.1433.

Thanks for any response.

I'm out of ideas.  I suppose you could try installation on another PC to see if
the problem is reproducible.  Beyond that, you will probably need to log a call
with Quest Support.

Cheers ... Bill

--- In spotonoracle@yahoogroups.com, "Rameez Hasan" <rameez1@...> wrote:
>
> I am still out of luck. I tried re-registering all the DLLs Bill suggested but
no go here. Can someone please shed some more light on this?
>

I am still out of luck. I tried re-registering all the DLLs Bill suggested but
no go here. Can someone please shed some more light on this?

There are multiple msxml.dll files.  For example msxml4.dll, msxml4r.dll, and so
on.  It could be any one or several of these that need to be
installed/registered.  If that still doesn't work, then I think you would need
to go to Tech Support, because it could be another issue altogether.

Cheers ... Bill

--- In spotonoracle@yahoogroups.com, "Rameez Hasan" <rameez1@...> wrote:
>
> Thanks for the sugesstion Bill, but unfortunately this did not work. I tried
registering the DLL but I still get the error
>
> --- In spotonoracle@yahoogroups.com, "billjacobs2323" <bill.jacobs@> wrote:
> >
> > This is typically due to a problem with loading XML files, which might be
because the relevant Microsoft MSXML.DLL files are not installed or have been
deregistered.
> >
> > Try opening any XML file with Internet Explorer.  If it fails, then it
points to a problem with the MSXML system.
> >
> > Quest Technical Support should be able to give more assistance.  In most
cases the problem can be resolved by installing and/or registering MSXMLnn.DLL
files in C:\Windows\System32.
> >
> > Cheers ... Bill
> >
> > --- In spotonoracle@yahoogroups.com, Scott Stone <scott.stone@> wrote:
> > >
> > > Let me research this a bit to see if anyone can provide guidance.
> > >
> > > From: spotonoracle@yahoogroups.com [mailto:spotonoracle@yahoogroups.com]
On Behalf Of Rameez Hasan
> > > Sent: Wednesday, March 04, 2009 10:23 AM
> > > To: spotonoracle@yahoogroups.com
> > > Subject: [spotonoracle] Spotlight Error - Assertion Failure
> > >
> > >
> > > Hey guys,
> > >
> > > I am installing Spotlight in our organization. Installation runs fine but
however, when I exeute the app, I get the following error:
> > >
> > > Assertion Failure (C:\Spotlight
Console\MDK\2.0\Shell\SpotlightConfiguration.pas, line 464).
> > >
> > > I am not sure what to do about this or how can I fix this. Any help would
be appreciated
> > >
> > > Thanks
> > >
> >
>

Thanks for the sugesstion Bill, but unfortunately this did not work. I tried
registering the DLL but I still get the error

--- In spotonoracle@yahoogroups.com, "billjacobs2323" <bill.jacobs@...> wrote:
>
> This is typically due to a problem with loading XML files, which might be
because the relevant Microsoft MSXML.DLL files are not installed or have been
deregistered.
>
> Try opening any XML file with Internet Explorer.  If it fails, then it points
to a problem with the MSXML system.
>
> Quest Technical Support should be able to give more assistance.  In most cases
the problem can be resolved by installing and/or registering MSXMLnn.DLL files
in C:\Windows\System32.
>
> Cheers ... Bill
>
> --- In spotonoracle@yahoogroups.com, Scott Stone <scott.stone@> wrote:
> >
> > Let me research this a bit to see if anyone can provide guidance.
> >
> > From: spotonoracle@yahoogroups.com [mailto:spotonoracle@yahoogroups.com] On
Behalf Of Rameez Hasan
> > Sent: Wednesday, March 04, 2009 10:23 AM
> > To: spotonoracle@yahoogroups.com
> > Subject: [spotonoracle] Spotlight Error - Assertion Failure
> >
> >
> > Hey guys,
> >
> > I am installing Spotlight in our organization. Installation runs fine but
however, when I exeute the app, I get the following error:
> >
> > Assertion Failure (C:\Spotlight
Console\MDK\2.0\Shell\SpotlightConfiguration.pas, line 464).
> >
> > I am not sure what to do about this or how can I fix this. Any help would be
appreciated
> >
> > Thanks
> >
>

This is typically due to a problem with loading XML files, which might be
because the relevant Microsoft MSXML.DLL files are not installed or have been
deregistered.

Try opening any XML file with Internet Explorer.  If it fails, then it points to
a problem with the MSXML system.

Quest Technical Support should be able to give more assistance.  In most cases
the problem can be resolved by installing and/or registering MSXMLnn.DLL files
in C:\Windows\System32.

Cheers ... Bill

--- In spotonoracle@yahoogroups.com, Scott Stone <scott.stone@...> wrote:
>
> Let me research this a bit to see if anyone can provide guidance.
>
> From: spotonoracle@yahoogroups.com [mailto:spotonoracle@yahoogroups.com] On
Behalf Of Rameez Hasan
> Sent: Wednesday, March 04, 2009 10:23 AM
> To: spotonoracle@yahoogroups.com
> Subject: [spotonoracle] Spotlight Error - Assertion Failure
>
>
> Hey guys,
>
> I am installing Spotlight in our organization. Installation runs fine but
however, when I exeute the app, I get the following error:
>
> Assertion Failure (C:\Spotlight
Console\MDK\2.0\Shell\SpotlightConfiguration.pas, line 464).
>
> I am not sure what to do about this or how can I fix this. Any help would be
appreciated
>
> Thanks
>

Hey guys,

I am installing Spotlight in our organization. Installation runs fine but
however, when I exeute the app, I get the following error:

Assertion Failure (C:\Spotlight
Console\MDK\2.0\Shell\SpotlightConfiguration.pas, line 464).

I am not sure what to do about this or how can I fix this. Any help would be
appreciated

Thanks

Hi Dear,


   Here is a great article to learn and understand the working of the
Oracle Financial GL.


   To read oracle Financial GL please visit the following:


	 http://www.etechnologyinfo.com/ora_apps_gl.php



If you are new to our site you can find many great Oracle articles
with examples on our site at


   http://www.etechnologyinfo.com/ora_general.php

you can find many more other articles at

    http://www.etechnologyinfo.com

regards,

Dear users,

   Welcome back after a long time, here know you can find the step 2 of
our online learning the Oracle financial,
where is "Oracle Apps Technical Interview Questions"

    I hope you it will be helpful to the users of Oracle Financial and
also to the beginer having not any environment
for oracle financial.

    The purpose of this article is just to make some technical
understanding to the new users as well as old one, but
finally it will be helpful in our comming lectures where you will
learn oracle apps modules step by step with all
screen shots.

   To read oracle apps technical interview questions please visit the
following:


    http://www.etechnologyinfo.com/ora_apps_tech_interview.php



If you are new to our site you can find many great Oracle articles
with examples on our site at


   http://www.etechnologyinfo.com/ora_general.php

you can find many more other articles at

    http://www.etechnologyinfo.com

regards,

Hi Dear,

We are moving to start learning Oracle Financial, in the first step we
are introducing you with some important
interview questions in this regard and then we will move towards some
technical questions/points with their answers.

after it we will move to understand and practice all the modules of
Oracle financial one by one with some examples.

hope you will understand Oracle financial from our forum in short time
of about 3 to 4 months.

to start to the first step please find below the link for some
important interview questions on Oracle Apps.

    http://www.etechnologyinfo.com/ora_apps_interview.php



If you are new to our site you can find many great Oracle articles
with examples on our site at


   http://www.etechnologyinfo.com/ora_general.php




regards,

--- In spotonoracle@yahoogroups.com, "billjacobs2323" <bill.jacobs@...> wrote:
>
> See:
> http://www.toadworld.com/Knowledge/DatabaseKnowledge/GuyHarrisonsResolvi
> ngOracleContention/ResolvingOracleContention/ReducingOracleNetworkConten
> tion/tabid/374/Default.aspx
>
> This article explains Oracle's array interface, and shows Spotlight on
> Oracle's array-fetch alarm (new in version 5.0, just released).
>

Hmm, hoping this works better as a hyperlink:

http://www.toadworld.com/Knowledge/DatabaseKnowledge/GuyHarrisonsResolvingOracleContention/ResolvingOracleContention/ReducingOracleNetworkContention/tabid/374/Default.aspx

See:
http://www.toadworld.com/Knowledge/DatabaseKnowledge/GuyHarrisonsResolvi
ngOracleContention/ResolvingOracleContention/ReducingOracleNetworkConten
tion/tabid/374/Default.aspx

This article explains Oracle's array interface, and shows Spotlight on
Oracle's array-fetch alarm  (new in version 5.0, just released).

I'd like to know whether anyone has any suggestions for the SQL Performance screen in Spotlight on Oracle Xpert version 5.0.

In particular:

• Do you typically need to alter the default settings of the SQL Statement Trend Analysis Wizard?

If so, would you want to be able to save the wizard's settings so that they can be loaded/restored the next time you use Spotlight?

• Would you want to be able to save and restore the contents of the SQL Performance screen so that you can process the listed SQL statements in an ad hoc manner over time?

That is, to be able to leave the SQL Performance screen without losing your work. This implies you'd want to be able to categorize each SQL statement in the screen's grid so that you know whether you've already processed/inspected the SQL statement.

Spotlight is designed to place no more than 2% load on your database.
If you want to reduce the server load even further there are a few
techniques you can use.

First and foremost, you can reduce the frequency with which Spotlight
queries the database.  By default, Spotlight refreshes itself every 15
seconds for data that is currently being displayed (foreground refresh
rate), and every 60 seconds for data that is to be collected but is not
currently being displayed (background refresh rate).

You can change this via a Spotlight Option.  From the View menu, select
Options, Spotlight Console, Data Collection tab, and modify the refresh
rates.

Alternatively, you can change the Overhead Settings by clicking the
Flag icon on the toolbar.  If you move the slider to "Lower Impact"
setting, several of the more expensive Spotlight queries will not run;
and also some queries will only be executed when the associated
drilldown is being displayed.

If you are a Spotlight customer, what request or question do you have
that you wish could bypass normal channels and go directly to the
developers?

What is your top enhancement request for Spotlight?

Please provide examples of scenarios when you have used Spotlight to
diagnose a problem.

Do you keep it open at all times or only open it when you already know
a problem exists?

Are you one of the customers with Spotlight on a plasma screen on your
operations center?  If you are, can you get cable on the same
screen?  :-)

Welcome to the Spotlight on Oracle user forum.   Please use this forum
to discuss ways you use the product to manage the performance of
Oracle databases and suggest improvements to product management and
the development team.