198 reputation
8
bio website imartins.com.br/informix
location Brazil
age
visits member for 1 year, 7 months
seen Jun 19 at 21:17

I'm DBA and ex-developer, working mostly of my life IBM Informix, but with MySQL and Oracle too...

Hobby: Photography , http://www.flickr.com/photos/cesar_camilla/sets


Sou DBA e ex-desenvolvedor, trabalhei boa parte da minha vida com IBM Informix, mas atualmente também atuo com MySQL e Oracle....


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?
Mar
9
answered Filter Stored Procedure Result (Informix)
Jan
2
awarded  Commentator
Jan
2
revised dbms_utility.get_dependency give me error “ORDER SIBLINGS BY clause not allowed here” , why?
add more information
Jan
2
comment dbms_utility.get_dependency give me error “ORDER SIBLINGS BY clause not allowed here” , why?
Hi @Phil, yes, I try with the owner and give the same error.
Jan
2
asked dbms_utility.get_dependency give me error “ORDER SIBLINGS BY clause not allowed here” , why?
Nov
1
comment How to get session parameters changed by the user in Oracle?
Hi @Raj, I think our problem maybe the old version of forms (6i) accessing v11.2.0.3 . I have the suspicious we are stopping at the Bug 16718027 (diana_version$ access). I have a SR open at oracle support trying find the cause. We have some dblinks, I will re-check them... thanks!