Category: oracle

Redhat tuning for Oracle

In /etc/sysctl update these fs.file-max net.ipv4.ip_local_port_range net.core.rmem_default net.core.rmem_max net.core.wmem_default net.core.wmem_max kernel.shmall kernel.shmmax kernel.shmmni kernel.sem

Oracle Version Info

Release Number Format To understand the release nomenclature used by Oracle, examine the following example of an Oracle Database server labeled “Release 10.1.0.2.3”. 10 – Major Database Release Number The first digit is the most general identifier. It represents a…

Listing tables in DB

User tables select distinct owner from dba_objects; If you logged in as Normal User without DBA permission you may uses the following command to see your own schema’s all tables and views. select * from tab; it will show all…