Reputation
14,088
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 25 39
Newest
 Guru
Impact
~763k people reached

Dec
12
answered Materialized view for the last 24 hour period
Dec
12
comment Which RDBMS has the most advanced “table-valued” functions?
Why are you splitting a string so frequently that it becomes part of the criteria for what database engine to use? To @RemusRusanu's point, if you are storing a value in a cell that is a composite, you're violating basic principles of normalization. If you are going to work with any relational database, you are going to be much better served normalizing the data model. That's the "relation" in "relational database"-- any relational database is going to perform better and be easier to use when your data model is normalized.
Dec
11
comment Searching transaction logs for changes
What type of database are you using? Oracle? SQL Server? MySQL? PostgreSQL? Something else? The answer is going to be very specific to the database in question.
Dec
11
answered What would be the correct size of redo logs?
Dec
10
comment Oracle aggregate functions slows query down massively
Can you generate and post a complete plan using the DBMS_XPLAN package? In particular, we're going to want to see columns for things like cardinality, cost, and estimated time as well as the filter predicates.
Dec
10
comment Oracle aggregate functions slows query down massively
Please edit your question to include the plans (so that you can format them so that they are readable). Don't try to post the plans in the comments.
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.