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...
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...
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...
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...