106 reputation
6
bio website howfuckedismydatabase.com
location Krasnoyarsk / Moscow, Russia
age 31
visits member for 2 years, 2 months
seen 2 days ago

Jul
12
comment How to optimize query?
1. show us your table definition and execution plan. 2. execute the same query in SQL*Plus and check the timing. 3. you mean, 376, not 376000?
Apr
29
awarded  Teacher
Apr
29
answered how to check which background process are running in my oracle database?
Dec
29
comment 9i streams capture doesn't evaluate rules
@Threaten there are no (visible) errors or warnings. capture process' status is active. it just does nothing (or something I mentioned above)
Dec
26
awarded  Citizen Patrol
Dec
24
awarded  Promoter
Dec
20
asked 9i streams capture doesn't evaluate rules
Dec
10
awarded  Scholar
Dec
10
accepted oracle streams - how to get last successfully applied scn for crashed apply?
Dec
10
comment Oracle aggregate functions slows query down massively
@user1578653 can you post autotrace for both queries also?
Dec
7
awarded  Student
Dec
7
answered oracle streams - how to get last successfully applied scn for crashed apply?
Dec
7
revised oracle streams - how to get last successfully applied scn for crashed apply?
edited tags
Dec
7
asked oracle streams - how to get last successfully applied scn for crashed apply?
Oct
2
awarded  Supporter
Oct
2
comment How to modify an update in Oracle so it performs faster?
@StrayChild01 if FEE_SCHEDULE_HISTORICAL + ETL_FEE_SCH_TMP = FEE_SCHEDULE, why do you perform additional costly FTS exists check for FEE_SCHEDULE at all, if you are somewhat sure to have all the data in former two tables which you joined? doesn't make sense to me.