Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

base to oracle database connection slow

I use LibreOffice in Ubuntu 16.04. I installed and tried jre1.8.0_74 jre1.8.0_152 jre1.7.0_80 openjdk 1.8.0_151. Also, I increased the memory for 300MB for libreoffice, and 50MB for per object.

When I sign in to a remote oracle 11g XE database on the local network with hr user(has sysdba role), it takes like 30 seconds or so. If I go to the end of the table with about 80K rows or so, it takes 4-5min to retrieve.

Is this normal? If not, what can I do to improve the performance.

Thank you very much