Reputation
213
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 10
Impact
~19k people reached

Aug
31
awarded  Notable Question
Jul
1
comment Is possible do an online snapshot backup , without archive logs at Oracle Database?
Thanks @miracle173 , I will check and test about this command. A fast look at manual appear it's what I'm looking for... please , post as answer and if my tests work I will check as correct answer.
Jun
30
asked Is possible do an online snapshot backup , without archive logs at Oracle Database?
Feb
2
awarded  Popular Question
Sep
25
awarded  Yearling
Sep
24
awarded  Autobiographer
Apr
17
answered Moving the IBM Informix IFMXDATA directory to another machine
Apr
9
comment Why DBMS_METADATA.GET_DLL not work with EXEC command ?
Thanks Balazs, but in some cases the message isn't 100% accurate, so I doesn't now if it's reliable.
Apr
9
accepted Why DBMS_METADATA.GET_DLL not work with EXEC command ?
Apr
9
asked Why DBMS_METADATA.GET_DLL not work with EXEC command ?
Mar
28
revised Identify in details the consumption of memory from a specific session
spell correction
Mar
28
accepted Identify in details the consumption of memory from a specific session
Mar
28
answered Identify in details the consumption of memory from a specific session
Mar
27
comment Enhance performance of update query
Considering we talking about ETL process, I consider this like a muscle hard work which can involve the table fragmentation, storage options and hardware stress, where all this should be revised and considered as variables at optimization process. I have doubt about create the index because will double the work updating the table and the index (which probably will unbalance the index tree/pages giving a gradually poor performance). Anyway I consider test : Create the index + update individually each filter. This way you will work only over the 17mi rows and not 50mi.
Mar
22
answered How to know what index is set on the table with command line in informix?
Mar
21
comment Identify in details the consumption of memory from a specific session
ok, I sad because I don't found any clear SQL to identify something which appear be basic... anyway... I will try the perfstats , if works I accept the answer. thanks!
Mar
20
comment Identify in details the consumption of memory from a specific session
Is perfstat paid?
Mar
18
asked Identify in details the consumption of memory from a specific session
Mar
12
comment Filter Stored Procedure Result (Informix)
@Hoj, Did you tested your SQL at any SQL Client? Did you observed the field aliases informed after the table() should match with the all fields generated by the procedure and the "filter" will be done at 'select' projection?
Mar
10
comment Filter Stored Procedure Result (Informix)
Hi @Hojjat , I put fews statements there... can you tell me what you tried to use?