be here now

less info
meta site favicon meta user | stack exchange network profile network profile
91 reputation
6
bio website howfuckedismydatabase.com
location Krasnoyarsk / Moscow, Russia
age 29
visits member for 7 months
seen May 12 at 8:08
stats profile views 1

17 Actions

suggestions reviews revisions comments badges posts accepts all
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
 comment oracle streams apply: how to get a reason why LCR message was not applied
check V$STREAMS_MESSAGE_TRACKING then.
Dec
24
 answered oracle streams apply: how to get a reason why LCR message was not applied
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.