Oracle 11g Architecture Oracle – PGA+ Instance + DB files Instance – SGA + BG Instance —SGA and BG SGA — Shared Pool, Database buffer cache, Redo log buffer cache, large pool, Java pool & Streams pool. Shared Pool — Most recently executed statements and definitions. Data Dictionary cache & Library cache Data Dictionary — most recently used definitions, including table, index & privilege. Library cache — most recently used SQL & PL/SQL statements Shared SQL area & Shared PL/SQL area Database buffer pool — It stores a copy of data block. Default, keep & Recycle Redo log buffer pool — it stores all the changes made to the…
-
-
Oracle DBA Unix commands-02
DBA Unix commands | symbol is for combine and filter the results like we use in Power Shell pipe out. R is for recursive & grep command is used to search text ps -ef |grep pmon – Get the running user process. ps -ef |grep smon – Get the running user process. Disk related commands: # df -h {-m,-k} -- Disk free # du -h /opt -- Disk usage for Particular mount point disk # pwd -present working directory # cd /opt - change directory # ls - list the files and folders -l -long list like a windows properties -lt - long list with time -ltr - long list…
-
Install oracle 11g on redhat centos vmware on laptop -01
I have been asked to support oracle, I have started self learning and had some corporate training as well. In this post, I am sharing how to build VM and install oracle database in your desktop or laptop. Install and build VMware workstation in your laptop Build new VM by installing CentOS or Linux Copy the DB software and install DB binaries Create a oracle database Create a listener Connect the database by putty and SQL developer How to Install Linux on VMware workstation 1&2 Install VMware work station On the OS part — install OS later option– 40 GB disk size VM –Store virtual machine in single file– Click customize…