211 reputation
210
bio website scorch2000.com
location United States
age 35
visits member for 3 years, 1 month
seen Mar 26 at 21:29

Jan
28
accepted oracle active sessions waiting for scheduler
Jan
25
asked oracle active sessions waiting for scheduler
Jan
21
awarded  Popular Question
Oct
28
awarded  Yearling
Aug
6
comment fighting filter (nested loops) execution plan from Oracle
@a_horse_with_no_name yeah, only problem being that the category can be one of the hundreds of columns :) Sounds like the query generator will be changing.
Aug
6
comment fighting filter (nested loops) execution plan from Oracle
@a_horse_with_no_name because the query is generated and the condition might be more complex...
Aug
6
comment fighting filter (nested loops) execution plan from Oracle
Always reasonable thing to try but of course doesn't help here, all tables are fully analyzed.
Aug
6
asked fighting filter (nested loops) execution plan from Oracle
Aug
5
awarded  Notable Question
Aug
2
comment oracle tablespace extending
you would think that Oracle could handle such a basic thing, eh? 11g still doesn't log extends!!
Aug
2
comment oracle tablespace extending
So how do I tell it to autoextend before it runs out of tablespace?
Aug
1
comment oracle tablespace extending
@Mat well, yeah, we are going to try to preallocate, but I'd like to know 1) is it normal for this to take 30 minutes to extend by 1Tb 2) is it normal that all writing stops? Can it pre-extend before it really needs it to avoid stopping?
Aug
1
asked oracle tablespace extending
Jul
25
accepted oracle blocking sessions
Jul
25
asked oracle blocking sessions
Jul
12
accepted Oracle cluster top activity class “cluster”
Jul
12
comment Oracle cluster top activity class “cluster”
Waiting for the log buffer. Thanks!
Jul
12
asked Oracle cluster top activity class “cluster”
Apr
29
awarded  Popular Question
Mar
17
comment oracle huge hash_area_size
It is a good idea and I'll try it, but it will still use temp space (because I need 10-20Gb to fit entire result in memory and I can't parallelize it enough to fit into smallish work areas). It just feels like there should be a sane way to tell Oracle to do a huge join in memory!