You will no longer receive e-mail notifications from this forum.
Log-In to post
Here you can find information on our latest release, from features to downloads & documentation:
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
firstname.lastname@example.org | 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.
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 ?
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 22.214.171.124 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
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 HilkerToad World Admin