241 reputation
315
bio website scorch2000.com
location United States
age 35
visits member for 3 years, 9 months
seen Dec 1 at 4:53

Nov
27
awarded  Popular Question
Oct
20
awarded  Revival
Oct
20
awarded  Teacher
Oct
20
accepted ORA-02070: database does not support antijoin in this context
Oct
20
answered ORA-02070: database does not support antijoin in this context
Oct
14
awarded  Popular Question
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?