Jon.Lin
Follow / 8 Sep 2016 at 10:08pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 1:55pm

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation: https://support.quest.com/spotlight-on-oracle

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

   https://support.quest.com/spotlight-on-oracle

4797 2 / Create an account to join the discussion.
RZalavadia
Follow / 12 Jul 2018 at 3:16pm / Toad for Oracle
Latest post by on 13 Jul 2018 at 5:34am

email notification using oracle spotlight

Expand content
I would like to configure email notification using oracle spotlight for high cost sql running against database.

I would like to configure email notification using oracle spotlight for high cost sql running against database.

126 1 / Create an account to join the discussion.
kjellove.skarsbo
Follow / 29 Jun 2018 at 9:32am / Toad for Oracle
Latest post by on 3 Jul 2018 at 8:44am

Spotlight on ORacle with windows 10

Expand content
I have a new Windows 10 client machine (VM) where I have installed Oracle 10.2 client 32-bit with full administrator option. I have also installed Spotlight On Oracle. Starting spotlight and adds a...

I have a new Windows 10 client machine (VM) where I have installed Oracle 10.2 client 32-bit with full administrator option.

I have also installed Spotlight On Oracle. 

Starting spotlight and adds a new connection. Can choose from the list of databases defined in my tnsnames.ora from the connection string drop down list.

However, adding the config, I get a exception trying to connect with the following message:

Can't initialize OCI. Error -1

Running it from the cmd prompt indicates that ORACLE_HOME environment variable is set. Also the PATH variable is set to %ORACLE_HOME%\bin and the oci.dll exists in ORACLE_HOME\bin:

C:\oracle\ora10gClient\BIN>set
ORACLE_HOME=C:\oracle\ora10gClient
OS=Windows_NT
Path=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\oracle\ora10gClient\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Users\kos\AppData\Local\Microsoft\WindowsApps;

C:\oracle\ora10gClient\BIN>dir oci.dll
Volume in drive C has no label.
Volume Serial Number is 620B-2558

Directory of C:\oracle\ora10gClient\BIN

29.08.2005 22.47 344 064 oci.dll
1 File(s) 344 064 bytes
0 Dir(s) 14 520 000 512 bytes free

C:\oracle\ora10gClient\BIN>

Anyone seen this before?

372 4 / Create an account to join the discussion.
anders.gunnare
Follow / 7 Jun 2018 at 2:53pm / Toad for Oracle
Latest post by on 7 Jun 2018 at 3:41pm

How can I see the actual VALUE not just the variable ?!

Expand content
Hello World, How can I see the actual values for :B1, :B2 and so on ?! I need to see the values and not the variables ... Is it possible ? If so - how ? Please see my screenshot

Hello World,
How can I see the actual values for :B1, :B2 and so on ?!
I need to see the values and not the variables ...
Is it possible ?
If so - how ?

Please see my screenshot

715 2 / Create an account to join the discussion.
prakash.chada
Follow / 30 Apr 2018 at 3:51pm / Toad for Oracle
Latest post by on 15 May 2018 at 12:47am

Oracle 11g Operational Audit

Expand content
Oracle 11g on Linux. Just want to get feedback on how everybody is handling audit within Oracle table access. I just started the list with: 1: Successful Logins 2: Unsuccessful logins. What other audits...

Oracle 11g on Linux.

Just want to get feedback on how everybody is handling audit within Oracle table access.

I just started the list with:

1: Successful Logins
2: Unsuccessful logins.

What other audits can I turn on without really bogging down the performance of the db.

Thank you.

1093 1 / Create an account to join the discussion.
mikhan1
Follow / 21 Feb 2018 at 2:52pm / Toad for Oracle
Latest post by on 30 Apr 2018 at 9:14am

Data loading

Expand content
How to upload excel file using toad ?
How to upload excel file using toad ?
Unanswered 2227 4 / Create an account to join the discussion.
knareshseo92
Follow / 29 Mar 2018 at 7:03am / Toad for Oracle

Oracle connects the data swamps

Expand content
Oracle has announced the launch of the Oracle Data Integrator Cloud Service. This service is designed to extract, load and transform (E-LT) data into big data repositories. It supports Oracle Database...

Oracle has announced the launch of the Oracle Data Integrator Cloud Service. This service is designed to extract, load and transform (E-LT) data into big data repositories. It supports Oracle Database Cloud Service, Exadata Cloud Service, and Big Data Cloud Service. There is also support for non-Oracle services. What is key to the architecture is that it does not need to transfer the data to another location in order to transform it. This is important for a cloud data transfer service. It reduces the number of transfers that other services take and increases the speed accordingly.

Flexible service

Jeffrey T. Pollock, Vice President of Product Management, Oracle (Image Source LinkedIn/Jeff Pollock Jeffrey T. Pollock, Vice President of Product Management, Oracle The solution works with on-premises solutions and in the cloud. It supports several different databases and can ingest data from multiple sources such as Hadoop, applications, JDBC, files, XML, JSON and web services. Jeff Pollock, vice president of product management, Oracle commented: “To be effective and agile, enterprises need seamless communication and flow of data between sources and targets – data originating from IoT, Web, and business applications or data that is stored in the cloud or on premises. Oracle Data Integrator Cloud provides businesses with a high-performance, simple, and integrated cloud service to execute data transformations where the data lies, with no hand coding required, and without having to copy data unnecessarily.”

Designed for speed

To improve the speed of E-LT, Oracle has designed a new architecture and is taking advantage of parallel processing where appropriate. Businesses selecting the service are able to take advantage of the integrations into Oracle’s existing PaaS solutions, including Oracle Database Cloud, Oracle Database Exadata Cloud, and Oracle Big Data Cloud. There are also pre-built integrations for big data technologies such as Hive, HDFS, HBase, and Sqoop. Oracle also provides several code templates, known as Knowledge modules. These decrease the time taken to begin the data movements. They include: Reverse engineer metadata, journalize (CDC), load from source to staging, check constraints, integrate transform and data service. By getting training on ODI Training you will learn more about ODI integration with Cloud.

As they are reusable, companies are able to add new sets of data to ingest easily and rapidly consolidate their data from different sources. By decoupling the design, ODI mappings can transfer between underlying technologies without the need for extensive re-coding. The new Oracle service transfers data rapidly between data lakes and is also rapid to configure and set up. The graphical user interface is intuitive and allows developers to map data fields quickly and easily.

How much does it cost?

Oracle provides two sets of pricing: Non-Metered and Metered. Non-Metered pricing is $2,000/month/ Host OCPU. It is the OCPU’s running the Oracle Data Integrator Cloud Service instance that is counted. For metered pricing, there are two elements. Either $4,000/month/Host OCPU of $6.72/Hour/Host OCPU. This second option is interesting. It should allow companies to build templates and expertise to carry out the initial E-LT of data. If they need to repeat the transfer at a later date they can use a metered solution to cut the costs down.

Conclusion

Oracle has produced an E-LT service that is suitable for migrating the large data lakes that analytics requires without some of the issues. That it doesn’t need to take an interim copy of the data is key. he parallels processing capability is not explained in detail and it would be interesting to see some actual benchmarks for this service against competitors. As companies look to consolidate their data for improved analysis this tool should gain the interest of several companies. It could also become a key player as Oracle looks to persuade companies to move into the cloud ERP. Ingesting data quickly between on-premises and cloud databases is a challenge that companies need to overcome. For those considering moving to an ERP solution, this is a major hurdle.

984 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 1751 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

3232 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

2242 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.

2791 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

5090 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.

7800 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

7011 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

16679 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

 

 

 

8879 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

8752 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 19235 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.

 

 

15599 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
14284 1 / Create an account to join the discussion.