We have discussed on How Optimizer works in our previous article. Please find the article here Performance Tuning – Part4 Now we will discuss about the SQL Tuning. SQL TUNING Before going into how to perform SQL Tuning, let us begin with Thumb Rules… Read More
Till now in my previous articles we have discussed about the tools that are used in the performance tuning. Please find the previous article here. Performance Tuning in Oracle – Part3 Before we go in depth of the Performance tuning, it is important to… Read More
Performance Tuning Tools This is the continuation to the previous article about the Tools used in the performance Tuning. Please find the previous article here. Performance Tuning in Oracle – Part2 In this article we will discuss about Oracle SQL Tuning advisor and baseline.… Read More
Performance Tuning Tools We have discussed the tools that are being used for Performance Tuning in our previous article. Please find the article here Performance Tuning in Oracle – Part1 In this article we will be discussing the additional tools which are used in… Read More
Introduction of Performance Tuning: Performance tuning plays an important role in the DBA life. Performance tuning refers in the following areas: 1. Instance tuning 2. SQL tuning 3. Memory, Storage (I/O) 4. Network tuning 5. OS tuning For OS Tuning and Network tuning DBAs… Read More
Continuation to the Part 3 ORACLE – Physical Standby Database creation – Part 3 Configure the listener and tnsnames to support the database on both nodes Configure listener.ora on both servers to hold entries for both databases ON TEST1 (Primary Database… Read More
Continuation of Part 2 ORACLE – Creating a Data Guard Physical Standby environment – Part2 Standby Database Steps Create a Control File from Primary database for the Standby Database. The standby database will use a control file that is generated on… Read More
Continuation to the Data Guard Physical standby creation ORACLE – Creating a Data Guard Physical Standby environment – PART1 Enable Archiving On 10g you can enable archive log mode by mounting the database and executing the archivelog command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> startup mount; ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 75499088 bytes Database Buffers 205520896 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Archive Mode Database log mode Automatic archival Enabled Archive destination /test/PRIMARYDB/archdest/arch Oldest online log sequence 92 Next log sequence to archive 94 Current log sequence 94 |
Set… Read More
Creating a Data Guard Physical Standby environment Once you have your primary database up and running these are the steps to follow. Enable Forced Logging Create a Password File Configure a Standby Redo Log Enable Archiving Set Primary Database Initialization Parameters… Read More
Dear Readers, In this article, we will see the following Multitenant Database Introduction A Container database (CDB) is made up of the following containers: There is one root container which stores the Oracle supplied metadata like the PL/SQL data dictionary packages and the common users.… Read More
