Spotlight on Oracle Forum - Toad for Oracle - Toad World
Jon.Lin
Follow / 8 Sep 2016 at 10:08pm / Toad for Oracle

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation: support.software.dell.com/.../download-new-releases

Here you can find information on our latest release, from features to downloads & documentation:

   support.software.dell.com/.../download-new-releases

1104 0 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 30 May 2017 at 4:33pm / Toad for Oracle

no ciper supported by both: client and server

Expand content
Hello, While attempting to connect to monitor the OS while using Spotlight on Oracle, I receive the error message: "no ciper supported by both: client and server". The Oracle connection does...
Hello,
While attempting to connect to monitor the OS while using Spotlight on Oracle, I receive the error message: "no ciper supported by both: client and server".  The Oracle connection does succeed, howerver.  

I am able to monitor both the OS and the Oracle database on 2 other servers.  The server that fails to connect is a VM, while the servers that succeed are Redhat Linux RAC cluster servers.

Your help will be much appreciated.

Thanks,
Rick
Unanswered 89 0 / Create an account to join the discussion.
ss
Follow / 8 May 2017 at 3:08pm / Toad for Oracle
Latest post by on 9 May 2017 at 3:11am

Urgent

Expand content
I need to install spotlight on oracle on windows server 2008 and i need to access spotlight from my machine to monitor database please i need to know how achieve this

I need to install spotlight on oracle on windows server 2008 and i need to access spotlight from my machine to monitor database

please i need to know how achieve this

134 1 / Create an account to join the discussion.
Saty021
Follow / 26 Oct 2016 at 1:26am / Toad for Oracle

Best Promotion: Toad for oracle - Professional edition (Ranked No...

Expand content
Greeting from SoftwareONE!! We are SoftwareONE , a professional software solutions providers and reseller, well known around the world for our customer focused and loyal service. Currently we...

Greeting from SoftwareONE!!

 

               We are SoftwareONE, a professional software solutions providers and reseller, well known around the world for our customer focused and loyal service. Currently we are hosting a promotion on TOAD for oracle – Professional edition ( a database management tool) under buy 1 and get 1 free. It would be a great value proposition for your money spent because this tool provides many benefits for data base management.  Some of the highlighted features are,

 

  1. Create and maintain database platforms like PL/SQL code and SQL scripts. A robust and integrated debugging suite for PL/SQL and SQL Scripts is included.

  2. Toad data modeler – To simplify data modeling and design across multiple database platformsNo additional cost.

  3. Code analysis – to automate code-quality reviews to ensure its objective and consistency (incorporates rules form seasoned oracle experts).

  4. Data generation – populates tables with multiple rows of realistic data for functional testing.

 

  It is  a right opportunity for you take up Toad for oracle – Professional edition under Buy 1 Get 1 offer and be more cost efficient in the long-run along with  1 year maintenance - direct from dell support (free with the pack).

Note: Promotion period is form 1st of October to 31st of December.

For more information or in case query, Please contact :

Sathish Raja sekaran | Business Development Representative | Software One Experts Sdn Bhd

Direct: +60 3 2289 7640 | General: +60 3 2289 7728 | Fax: +603 2178 4965

sathish.rajasekaran@softwareone.com  | www.softwareone.com

694 0 / Create an account to join the discussion.
Jon.Lin
Follow / 8 Sep 2016 at 9:45pm / Toad for Oracle

Top 5 Knowledge Base Articles

Expand content
Here you can find what knowledge articles are trending. These are this month’s Top Knowledge Base Articles Here you can find what knowledge articles are trending. These are this month’s...

Here you can find what knowledge articles are trending.

These are this month’s Top Knowledge Base Articles

Here you can find what knowledge articles are trending.

These are this month’s Top Knowledge Base Articles:

   1. support.software.dell.com/.../193911
   2. support.software.dell.com/.../40788
   3. support.software.dell.com/.../70165
   4. support.software.dell.com/.../94878
   5. support.software.dell.com/.../52073

Feel free to browse them. Remember to sign in to get the entire information available for our Register users.

1030 0 / Create an account to join the discussion.
ezioflavio
Follow / 15 Jul 2016 at 5:37pm / Toad for Oracle
Latest post by on 16 Jul 2016 at 5:41pm

Buffer cache hit ratio

Expand content
Hi, How is calculated the buffer cache hit ratio showed on Spotlight on Oracle? It doesn't match the value calculated from v$sysstat: 1 - (('physical reads cache') / ('consistent gets...

Hi,

How is calculated the buffer cache hit ratio showed on Spotlight on Oracle? It doesn't match the value calculated from v$sysstat: 1 - (('physical reads cache') / ('consistent gets from cache' + 'db block gets from cache'))

Thanks,

Ezio

1752 4 / Create an account to join the discussion.
brian_hershey
Follow / 12 Jan 2016 at 3:31pm / Toad for Oracle
Latest post by on 21 Jan 2016 at 5:43pm

Redo Writes IO/sec

Expand content
On the main dashboard for Spotlight on Oracle RAC there is a Section for Redo Logs, and under it Redo Writes with IO/Sec. Recently my application performance went way down and the circular arrows were...

On the main dashboard for Spotlight on Oracle RAC there is a Section for Redo Logs, and under it Redo Writes with IO/Sec.

Recently my application performance went way down and the circular arrows were flashing red with high numbers.
However, the number of Redo Log Switches in my Database Alert was normal (3-5 per hour).
So, what does Redo Writes IO/sec on Spotlight really mean?

Per the AWR, Wait Time for Commit (log_file_sync) was very high.
Had a very large shrink table operation in progress at the time, but even when I killed the session, performance did not improve.

3704 7 / Create an account to join the discussion.
ss
Follow / 31 Dec 2015 at 2:45pm / Toad for Oracle
Latest post by on 12 Jan 2016 at 8:19am

Question

Expand content
Hello , I have installed spotlight on oracle and it's working but database was down but spotlight didn't detect that, it show only that cpu was 100% please help me why happen this? T...

Hello ,

I have installed spotlight on oracle and it's working but 

database was down but spotlight didn't detect that, it show only that cpu was 100% 

please help me why happen this?

Thanks

3589 5 / Create an account to join the discussion.
Damir Vadas
Follow / 3 Jan 2015 at 8:23am / Toad for Oracle
Latest post by on 9 Dec 2015 at 5:30am

Buffer busy wait alarm ... false result?

Expand content
Hi Mine config: Spotlight version is 10.2.1.1504 x64 Oracle client (used for Spotlight) was 11.2.0.3 x64 Client OS is Windows 7 x64 SP1 Monitored database was Oracle 11.2.0.3 x64 on AIX Once while...

Hi

Mine config:
Spotlight version is 10.2.1.1504 x64
Oracle client (used for Spotlight) was 11.2.0.3 x64
Client OS is Windows 7 x64 SP1
Monitored database was Oracle 11.2.0.3 x64 on AIX

Once while presenting Spotlight capabilities during one of mine Toad hotest features, I have situation that Spotlight shows pretty long time buffer busy wait alram.

The bb wait situation lasts for 3-5 minutes and then I decide to took a picture, which is here as live example.

Once again, before this picture was taken BB wait shows red alarm (99%-100% values), and here, when the picture was taken was blue level.

Then I took ASH from the same period to show to users that Spotlight can replace ASH reports. But ... but in generated html report (from the 3 minutes before and after monitored Spotlight pic) there was no sign of mentioned buffer busy wait event at all. I cannot place html report here ( do not know how and do not want to compromise client data!) but please let me get someone mail to send ... not a problem.

I was then asked why is Spotlight showing this (quite often by their words wait event) and this state/problem is not reflected in ASH (which I belieive more, sorry to say that).

So please understand that this may be obvious to you people but not to me and not to mine client, who is waiting for an straight answer-what is underneath of that Spotlight message and how to inter-prate in the future.

THX in advance

Damir

13265 7 / Create an account to join the discussion.
cunderwood
Follow / 24 Jun 2015 at 2:15pm / Toad for Oracle
Latest post by on 22 Jul 2015 at 4:51am

Spotlight for Oracle: Hard Parse Tuning Question

Expand content
Hello, Recently installed TOAD 12.7.0.121 and Spotlight 10.3.0.1632. Total Parse Wait Time Ratio Alarm constantly fires [yellow and sometimes red] 10.7 % wait over 30 sec. There is a Library Cache Miss...

Hello,

Recently installed TOAD 12.7.0.121 and Spotlight 10.3.0.1632.  Total Parse Wait Time Ratio Alarm constantly fires [yellow and sometimes red] 10.7 % wait over 30 sec.  There is a Library Cache Miss Rate alarm on Shared Pool Used as well [aqua color].   

Vendor reviewed Spotlight data and says "there isn't actually a problem. TOAD is complaining because the axiUm application is sending a lot of "literals" to the database, and those literals have to be parsed (hence, high level of parsing). And that's true, we are, because that's just the way the application is written." 

Vendor requires CURSOR_SHARING must be set to 'EXACT'.  SESSION_CACHED_CURSORS currently set to default 50, OPEN_CURSORS set to 900 per vendor recommendation.  Shared Pool size is 1.7 Gb 73% used on average.

Is it possible to tune this situation?

Thank you

Carol

 

 

 

5467 3 / Create an account to join the discussion.
dlyczek
Follow / 25 Jun 2015 at 2:28pm / Toad for Oracle
Latest post by on 6 Jul 2015 at 1:55pm

Spotlight on Oracle - Diagnostic and Tuning Pack (?)

Expand content
Hallo, I have Oracle SE, 11R2. could I have clear answer - if using Spotlight is related with any risk of not passing Oracle Audit ? Does Spotlight eg. shows warn messages if I would click any option...

Hallo,

I have Oracle SE, 11R2.
could I have clear answer - if using Spotlight is related with any risk of not passing Oracle Audit ?

Does Spotlight eg. shows warn messages if I would click any option related to AWR ?
Could options related to paid Oracle features be disabled ?

Best regards,

Dominik

5170 1 / Create an account to join the discussion.
gvergara
Follow / 26 Mar 2015 at 3:30pm / Toad for Oracle
Latest post by on 21 Apr 2015 at 12:18pm

spotlight for rac

Expand content
I am trying to configure the spotlight but appear the following error message ora-12514 when trying to connect, i send the configuration tnsnames.ora. the conection with toad work fine webcr= ...
I am trying to configure the spotlight but appear the following error message ora-12514 when trying to connect, i send the  configuration tnsnames.ora. the conection with toad work fine

webcr=
  (DESCRIPTION=
   (FAILOVER=on)
   (LOAD_BALANCE=on)
   (ADDRESS_LIST=
     (ADDRESS=
       (PROTOCOL=TCP)
       (HOST=mhoidsa05_vip.minhacienda.gov.co)
       (PORT=1521)
     )
     (ADDRESS=
       (PROTOCOL=TCP)
       (HOST=mhoidsa06_vip.minhacienda.gov.co)
       (PORT=1521)
     )
   )
   (CONNECT_DATA=
     (FAILOVER_MODE=
       (TYPE=select)
       (METHOD=basic)
     )
     (SERVER=dedicated)
     (SERVICE_NAME=webcr)
   )
 )
Unanswered 15994 2 / Create an account to join the discussion.
cynthia.l.hills
Follow / 19 Dec 2014 at 9:13pm / Toad for Oracle
Latest post by on 20 Mar 2015 at 12:40am

Launching Spotlight and setting up a user.

Expand content
I'm fond of launching spotlight from Toad for Oracle under monitor session browser. The first 2 database connections worked perfectly. The second and third give me this error. The Spotlight User...

I'm fond of launching spotlight from Toad for Oracle under monitor session browser.  The first 2 database connections worked perfectly.  The second and third give me this error.

The Spotlight User Wizard has encountered an error.  An error was reported for table "CreateATPkgBody" in connection "DRSD0.USPS.GOV".

The error is:

ORA-24344: success with compilation error
2658/10 PLS-00201: identifier 'DBMS_JOB.SUBMIT' must be declared
2658/10 PL/SQL: Statement ignored
 in table createATPkgBody

 

Any ideas on how to get around this?  It doesn't make sense that it works in some and not others.  The databases are installed the same and they are the same version.

 

 

12260 3 / Create an account to join the discussion.
eduardo.paula
Follow / 12 Mar 2015 at 7:26pm / Toad for Oracle
Latest post by on 16 Mar 2015 at 2:31pm

Enterprise Manager 12c

Expand content
Hi everybody, What are the main differences between EM 12c and Spotlight 10? Why choose Spotlight? Thanks. Eduardo
Hi everybody, What are the main differences between EM 12c and Spotlight 10? Why choose Spotlight? Thanks. Eduardo
10990 1 / Create an account to join the discussion.
varma@23121988
Follow / 11 Dec 2014 at 3:27pm / Toad for Oracle
Latest post by on 11 Dec 2014 at 6:57pm

spotlight on oracle

Expand content
hi , how to configure spotlight on oracle or how to know is this available foe me r not .. thanks,
hi ,

how to configure spotlight on oracle or how to know is this available foe me r not ..


thanks,
Unanswered 11917 1 / Create an account to join the discussion.
richs@meridinet.com
Follow / 8 Oct 2014 at 1:43am / Toad for Oracle
Latest post by on 8 Oct 2014 at 11:57pm

uninstalling or disabling predictive diagnostics during the holiday...

Expand content
How do you disable or uninstall the prdictive diagnostics ?? We are approaching our busiest part of our business year , i.e. Thanksgiving through New Years. We need to be able to get the most efficiency...

How do you disable or uninstall the prdictive diagnostics ??  We are approaching our busiest part of our business year , i.e. Thanksgiving through New Years.  We need to be able to get the most efficiency from our database servers and we experience high loads at times whenever the predictive diagnostics are collecting data.  Is there an easy way to do this or do we have to uninstall the predict diag altogether ?  And if so what do I remove ?

12336 1 / Create an account to join the discussion.
Jeff81
Follow / 6 Aug 2014 at 10:54pm / Toad for Oracle

High CPU coming from Spotlight connection

Expand content
I am new to Spotlight and I noticed while I have it running my CPU on my database goes up and I can tell it is all coming from my spotlight connection and from this SQL statement. Any help will be great...

I am new to Spotlight and I noticed while I have it running my CPU on my database goes up and I can tell it is all coming from my spotlight connection and from this SQL statement. Any help will be great.  I am running Enterprise 11.2.0.3 on Windows Server 2008r2 64bit.

SELECT :"SYS_B_00" Dummy,

SUM(DECODE(s.type,:"SYS_B_01",:"SYS_B_02",:"SYS_B_03")) system_sessions,
SUM(DECODE(s.username,NULL,:"SYS_B_04",DECODE(s.status,:"SYS_B_05",:"SYS_B_06",:"SYS_B_07"))) active_users,
SUM(DECODE(s.username,NULL,:"SYS_B_08",DECODE(s.status,:"SYS_B_09",:"SYS_B_10",:"SYS_B_11"))) inactive_users,
SUM(DECODE(s.type,:"SYS_B_12",:"SYS_B_13",DECODE(s.server,:"SYS_B_14",:"SYS_B_15",:"SYS_B_16"))) -
SUM(DECODE(s.type,:"SYS_B_17",:"SYS_B_18",DECODE(s.username,NULL,DECODE(SIGN(INSTR(p.program,:"SYS_B_19")),:"SYS_B_20",:"SYS_B_21",:"SYS_B_22"),:"SYS_B_23"))) -
SUM(DECODE(s.type,:"SYS_B_24",:"SYS_B_25",DECODE(s.username,NULL,DECODE(SIGN(INSTR(p.program,:"SYS_B_26")),:"SYS_B_27",:"SYS_B_28",:"SYS_B_29"),:"SYS_B_30"))) dedicated,
SUM(DECODE(s.username,NULL,:"SYS_B_31",:"SYS_B_32")) user_sessions
FROM v$session s, v$process p
WHERE p.addr=s.paddr

Thanks

11255 0 / Create an account to join the discussion.
cbatt
Follow / 11 Jun 2014 at 3:34pm / Toad for Oracle
Latest post by on 22 Jun 2014 at 11:31pm

Spotlight TNS Error

Expand content
While logged into toad, I try to open Spotlight and receive ORA-12154 TNS error. I have also tried openening Spotlight and creating a connection by choosing the database via the connection string in the...
While logged into toad, I try to open Spotlight and receive ORA-12154 TNS error. I have also tried openening Spotlight and creating a connection by choosing the database via the connection string in the application but get the same error.
Unanswered 12250 3 / Create an account to join the discussion.
acip_296
Follow / 8 Jan 2014 at 5:20pm / Toad for Oracle
Latest post by on 7 Apr 2014 at 3:21pm

SpotLight and OEM

Expand content
Hello When I try to open OEM from SpotLight Grid Control I get an error message: An error has occurred while retrieving the OEM Status. Please check the OEM Monitoring options. The error...
Hello

When I try to open OEM from SpotLight Grid Control I get an error message:

An error has occurred while retrieving the OEM Status.  
           Please check the OEM Monitoring options.
           The error details are: sh:/OraBase1/agent/agent11g/bin/emctl: cannot execute

My environment:

Oracle 11gR2 on IBM Unix, SoO v9.5.0.750 running on Windows 7 64bit

Where to start ??

Regards!


Unanswered 12767 3 / Create an account to join the discussion.
Steve Hilker
Follow / 5 Nov 2013 at 4:10pm / Toad for Oracle
Latest post by on 2 Jan 2014 at 7:09pm

Welcome

Expand content
Welcome to the Spotlight on Oracle forum. This forum is for discussing any and all aspects of Spotlight on Oracle. Have a question? Ask it here. Something been on your mind about Spotlight and you're...

Welcome to the Spotlight on Oracle forum.  This forum is for discussing any and all aspects of Spotlight on Oracle. Have a question?  Ask it here.  Something been on your mind about Spotlight and you're wondering what others think?  Again, post it here for general discussion.  This forum your place to ask questions, share your experiences, and hopefully have a little fun, too.

We look forward to your participation!

Steve Hilker
Toad World Admin

11829 2 / Create an account to join the discussion.