ORACLE DBA Knowledge Share
a place to share experience of Oracle, JAVA and Linux and my favorite topic performance tuning
A note to the orthodox DBA
›
DBA communities took statspack and AWR very warmly but as it happens usually there are many features, ignored to name few: 1. SQL Monitor...
Configure Huge Page in Linux for efficient memory utilization for performance tuning Oracle Database
›
Traditional Virtual Memory Page Size is only 4K and as as Linux does not have intimate shared memory model unlike Solaris the size of Page ...
Best Linux I/O Scheduler(elevator) for Oracle database
›
There is no single answer for this question but it is easy to answer it depends on your workload. Beginning from RHEL 4 (Completely Fair Q...
ORACLE Instance (pid = ) - Error 1578 encountered while recovering transaction (, ) on : ORA-01578: ORACLE data block corrupted (file # , block # )Block corruption after crashed database recovered
›
There are many cases when automatic crash recovery fails and Oracle database has to be salvaged from manual recovery [without restore and w...
ORA-00333: redo log read error block 9167 count 1073
›
If database is not able to start after failed crash automatic recovery with error you receive ORA-00333: redo log read error block xxxx cou...
Add processor/core in physical/ virtual Linux machine
›
This look very trivial though it is simple but sure not trivial for non Linux expert so here I'm with my experience. If your Linux mach...
ORA-01172: recovery of thread 2 stuck at block 224 of file 4
›
Error ORA-01172 should not come in ideal database It comes when database crashes(all RAC instances crashes) and automatic database crash re...
Which file system(OCFS) or RAW device vs ASM to choose for shared disk in RAC
›
Depending on manageability and performance trade off this is a very important question: My view based on my practical experience is below. ...
BACKUP , RECOVERY and archive log handling in RAC
›
Here are few basic points to consider about safe backup and recovery in RAC environment : If DB running in archive log mode then archive...
ORA-00314: log 3274 of thread 1, expected sequence# 3276 doesn't match 3276
›
I had power failure while there was heavy DMLs running on my database and after restating machine I my database(running in noarchive log ...
ORA-00443: background process "LCK0" did not start
›
my 12cRAC Clusterware(grid infra) services stack did not start. When I checked I found CSS was online(it means shared disk was ok) but ther...
Performance Tuning Linux Virtual machine on VMWARE, Oracle Virtual box and Oracle VM for performance testing
›
Performance testing is generally not suggested on Virtualized machine. But if we allocate resources properly, create test cases properly a...
Creating service in Oracle RAC
›
To reduce the Oracle cluster overhead you may want your application or some of module of your application to connect only wit...
Tuning Inserts in RAC
›
If Oracle database is not I/O bounded and is scalable by adding more CPU to single instance database then it is li...
›
Home
View web version