You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
Here you can find information on our latest release, from features to downloads & documentation:
I would like to configure email notification using oracle spotlight for high cost sql running against database.
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>setORACLE_HOME=C:\oracle\ora10gClientOS=Windows_NTPath=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
Anyone seen this before?
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
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 Logins2: Unsuccessful logins.
What other audits can I turn on without really bogging down the performance of the db.
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.
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.
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.
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
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,
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.
Toad data modeler – To simplify data modeling and design across multiple database platforms – No additional cost.
Code analysis – to automate code-quality reviews to ensure its objective and consistency (incorporates rules form seasoned oracle experts).
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
email@example.com | www.softwareone.com
Here you can find what knowledge articles are trending.
These are this month’s Top Knowledge Base Articles
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.
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'))
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.
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?
Mine config:Spotlight version is 10.2.1.1504 x64Oracle client (used for Spotlight) was 184.108.40.206 x64Client OS is Windows 7 x64 SP1 Monitored database was Oracle 220.127.116.11 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
Recently installed TOAD 18.104.22.168 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?
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 ?
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 error2658/10 PLS-00201: identifier 'DBMS_JOB.SUBMIT' must be declared2658/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.