Oracle License Cost Calculation basics
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
General DBA
General DBA
General DBA, General Performance tuning
Oracle PGA (Program Global Area) in 12c
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information
General DBA, General Performance tuning
Index in 12c by example test case
A. B-Tree Indexes I have discussed more details in the below blog. http://clouddba.co/index-internal-oracle-using-simple-test-case/ B.Invisible Indexes Deciding which columns to index
General DBA
Index internal oracle using simple test case
Index internal oracle using simple test case First of all I will create a table with char(1000) so that in
General DBA, Troubleshooting
Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555
Prepare by: Nurullah Sharif Scope: Undo Advisor Undo Advisor help to estimate the undo tablespace size and also advise
General DBA
How to check and implement best practice for Oracle Database 11g onwards
Author: Saibal Ghosh About author: I am an Oracle professional with twenty plus years of experience and have deep knowledge
Backup and Recovery, General DBA
FLASHBACK DATABASE AND QUERIES
FLASHBACK FEATURES Purging the Recycle Bin purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin;
General DBA
Network configuration listener and tnsnames in oracle
Oracle Network Configuration =========================== In its most basic form, Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.
General DBA
Memory and Process in Oracle generic note
MEMORY MANAGEMENT 11g ===================== http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ PGA+SGA=MEMORY_TARGET what are the shared memory IDs for my instance $ sysresv corresponding SysV SHM
General DBA
control files in general
What Is a Control File? Every Oracle database has a control file. A control file is a small binary file