meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 9 hours ago | |
| stats | profile views | 363 |
Oracle ACE
|
Dec 10 |
comment |
Oracle aggregate functions slows query down massively What are the query plans? How many rows does the first query return? Is 0.002 seconds the time to return the first row? Or the time to return the last row? |
|
Dec 4 |
revised |
Increase Oracle buffer cache gets slower edited tags |
|
Dec 4 |
answered | Increase Oracle buffer cache gets slower |
|
Dec 4 |
answered | Support ticket system - when/how to move old tickets? |
|
Nov 26 |
comment |
Oracle 10g - Sudden change in execution time for specific query @Emil - What does select * from v$version return? I'm also a bit confused by your answer regarding your access to the AWR. If you are saying that you are using this ASHMON perfvision.com/ashmon.php then that tool is querying the AWR tables. If you are licensed to be able to use ASHMON, you should be licensed to query the AWR tables. If you aren't licensed to use the AWR, do you have Statspack installed? |
|
Nov 26 |
comment |
Oracle 10g - Sudden change in execution time for specific query What version of Oracle are you using? What edition? Are you licensed to use the AWR? Is Statspack installed? Do you see different query plans when the query is fast vs. when it was slow? You state that there are bind variables-- are there histograms on those bind variables? Might this be an issue of bind variable peeking? |
|
Nov 23 |
answered | What's the maximum number of listeners an Oracle database can have? |
|
Nov 21 |
revised |
Oracle 10g using collection with sql edited tags |
|
Nov 21 |
answered | Oracle 10g using collection with sql |
|
Nov 16 |
comment |
Oracle locked sessions with ASP.Net Again, what is a "locked session"? I still don't understand what that term means to you. |
|
Nov 16 |
comment |
Oracle locked sessions with ASP.Net What is a "permanently locked session"? That's not a term I've ever come across so I'm very unsure what you're seeing and why you believe what you are seeing is problematic. |
|
Nov 16 |
comment |
Oracle locked sessions with ASP.Net What does it mean to you to have a "locked session"? What query are you running and what results are you seeing that leads you to believe that there is a problem? |
|
Nov 13 |
answered | How high can I set undo retention on Oracle 11gR2 |
|
Nov 9 |
comment |
How to isolate general Oracle 10g issues through SQL @Emil - Does maintenance have access to AWR? Can they generate the report and share it with you? The top 5 wait events (and the more detailed wait event breakdown) on the AWR report will tell you what the database is waiting on. Whatever the bottleneck (or at least whatever the most common bottleneck) should be clear from those wait events. |
|
Nov 7 |
awarded | Enlightened |
|
Nov 7 |
awarded | Nice Answer |
|
Oct 31 |
comment |
Should I use select count(*) for counting records or having a field like comments_no for tables like post, comments? Is there a requirement that the count must always be correct? Or do you have some flexibility to return approximate results? Does it matter if the count eventually matches reality or can it remain approximate forever? For example, if all comments on a YouTube video were halted and there were actually 1 million comments while the counter said 995,867 comments, no one would probably care about a discrepancy of 4000-some comments. Other systems will have other sorts of requirements for accuracy and consistency. |
|
Oct 27 |
answered | How can I identify and fix bottlenecks in an Oracle11gR2 import |
|
Oct 27 |
answered | Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table? |
|
Oct 26 |
answered | Upgrading from 10.2g to 11g by incrementals |
