oracle

  • perf-test.com need your contributions to build up a strong repository of performance engineering resources.

  1. admin

    Script to Create Huge Table for Performance Testing

    1. Create table in the database CREATE TABLE speforums_bigtable ( id NUMBER(10), created_date DATE, lookup_id NUMBER(10), data VARCHAR2(50) ); 2. Execute following script to create 1000000 rows of data. This may take some time to complete the operation...
  2. admin

    Installing Oracle Database on Desktop

    Installing oracle Database 1. Download installable files for your operating system from here. You may have to create an oracle account (if you do not have it already). 2. Unzip the files and click on setup.exe file for installation to begin 3. Installer will ask you for email. Please click...
  3. C

    Why Tomcat not releasing files [Too many open files error] (oracle APEX -> Tomcat)

    I am working as an Oracle developer. Recently I am facing an issue with tomcat where I keep getting "Too many open files" 25-Jul-2018 08:17:49.504 SEVERE [http-nio-443-exec-31] . /u01/app/ords/ords.18.1.1.95.1251/db_conf/m/url-mapping.xml: Too many open files java.nio.file.FileSystemException...
  4. A

    Tuning WebLogic Server For Best Performance

    Understand Performance Objectives: Gather information about the level of activity expected on your server, the anticipated number of users, the number of requests, acceptable response time, and an optimal hardware configuration (e.g., fast CPU, disk size vs. speed, sufficient memory, and so...