Oracle Apex with ORDS return "Time Out" after the process to get sales

Our history.

Teniamos la version 18 de Oracle Apex y la base de datos de Oracle 11g, y cuando ejecutamos un proceso que llama aproximadamente mas de 3 millones de registros, despues de 1 minuto recibimos un erro de "Time Out" desde Oracle Apex.

Para solventar el problema decidimos hacer lo siguiente:

1-We migrate from Oracle 11g to Oracle 19c in an RDS in AWS.

2-We update our version of Oracle Apex to the last version that until a month ago was 20.0.

3-And we create an ORDS in CentOS to improve Apex performance and better manage queries.

4-We try to optimize the query that brings more than 3 million records caused by the "timeout".

Until this moment we think that everything was solved because the process did return data in seconds, but from one day to the next the "time out" back again, and it has become unstable, sometimes it works and sometimes it does not.

So, we need an expert in Oracle Database and Oracle Apex to help us at fixed this issue and try to identify why the "ORDS" no work or optimize more our queries.

Taidot: Oracle, Tietokannan hallinto, Oracle APEX, Oracle Database, Aws Lambda

Näytä lisää: oracle apex dicom, part time online media sales, oracle apex send sms, oracle apex freelance, page process sales sheet, oracle apex freelancing, oracle apex developer freelancer, accuracy turnaround time important process, pull menu list oracle apex code, jobs oracle apex freelancer, parsed time unix process, oracle apex htmldb, oracle apex create template, telemarketing data entry data process sales, oracle apex indonesia, oracle apex tabular forms, plsql function process oracle apex, time unable process request please return, oracle apex, ords, tomcat install, what is oracle apex ords

Tietoa työnantajasta:
( 0 arvostelua ) Waterdown, Canada

Projektin tunnus: #30233071

9 freelanceria on tarjonnut keskimäärin $664 tähän työhön


Hello, It sound like a Ords issue instead a Database problem. I've several Years working with Oracle Apex, Ords , please let me know more details about your installation. Use tomcat o antoher j2EE server for ords? wh Lisää

$600 CAD 7 päivässä
(16 arvostelua)

Hi Gabriel, As discussed we can resolve time out issue. Please give us an opportunity. Regards,

$650 CAD 14 päivässä
(5 arvostelua)

Hello there, I have read the brief details on the job listing. I believe its a doable job I have great experience doing projects with Aws Lambda, Oracle APEX, Oracle, Database Administration and Oracle Database. You Lisää

$750 CAD 15 päivässä
(0 arvostelua)
(0 arvostelua)

hi, I can help you, with ords or query optimization, so contact me for more details.............. ............................. ... ..............

$556 CAD 1 päivässä
(0 arvostelua)

Hi, I am certificated Oracle DBA with 10 years of experience in deployment, development and administration of Oracle databases from 10g to 19c with FS, ASM and RAC. Backup and recovery, cloning, patching, upgradation, Lisää

$444 CAD 7 päivässä
(1 arvostelu)

Hello, I am Senior Oracle DBA with 15+ years experience with Oracle E-Busiess Suite and Oracle Database Administration. I have expertise on Oracle EBS, DB, Oracle Cloud and also have knowledge on AWS EC2 instances. Lisää

$500 CAD 7 päivässä
(0 arvostelua)

I have 5 years of experience in oracle Apex, Oracle Plsql, Oracle sql . I have installed oracle 12c , oracle 18c and oracle apex so many times . I also faced lot of issues on ORDS while installing oracle apex . I ha Lisää

$400 CAD 7 päivässä
(0 arvostelua)

Hi, I will work on the Oracle APEX,Oracle VBCS and Oracle ADW .I will customize the application as wanted for the business need and customization for the 30 days

$1500 CAD 30 päivässä
(0 arvostelua)