216 reputation
311
bio website scorch2000.com
location United States
age 35
visits member for 3 years, 5 months
seen Aug 26 at 14:23

Jul
2
awarded  Curious
Jun
25
asked ORA-02070: database does not support antijoin in this context
May
1
awarded  Notable Question
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!