For improving performance we need to move table to a different tablespace with higher block size. Higher blocksize increase the performance of select query tremendously. The following short article shows the process of creating the higher block tablespace and moving the table to it.
Showing posts with label Database Tutorial. Show all posts
Showing posts with label Database Tutorial. Show all posts
How to delete tempfile in temporary tablespace in Oracle database
First identify the temporary tablespace and corresponding datafiles issueing following command.
How to delete tempfile in temporary tablespace in Oracle database
First identify the temporary tablespace and corresponding datafiles issuing following command.
How to use Logminer to analyze the archive log
Here is a simple example of using logminer to analyze redo or archive logs.
A simple example of configuring Logminer to analyze the archive log or redo files
Logminer is a oracle tool to analyze the archive log files or log files in Oracle. In this article I have shown a very simple example how to setup a logminer.
Oracle Performance Tuning - Storage Tuning Part 2
The process of Elimination of Tablespace Fragmentation
Honeycomb tablespaces are very easy to be fixed using the following command.
Alter tablespace APPS_TS_TX_DATA coalesce;
Oracle Performance Tuning - Storage Tuning Part 1
-->
Storage related problem can be generated from different reasons. The following is an interesting example.
Once a database performance has stalled without any change in hardware level and physical layout level. The detail analysis shows that, the application running on the database is mistakenly submitting huge number of jobs in oracle job queue table. The application’s problem
Oracle Database Security Tutorial
Authentication
Authentication is the process of validating whether proper user is accesing the database Authentication has been done mostly
Flashback Feature in Oracle Database
Download the following document which discuss in details the flashback feature of oracle database 11i.
Oracle Data Guard Physical Standby Database Creation
I have followed the following documents to create a Physical Standby
Oracle DBA Health Checkup and performance scripts Part 2 Checking the database Alert Log in automatic manner for new alert or error
This script finds errors encountered in alert.log, if any. Also this script is written in the manner that it'll only show the errors those have not been
Oracle DBA Health Checkup and performance scripts Part 1 Tablespace and datafile monitoring scripts
The following script is a master oracle database performance monitoring script for checking the
database space usage by tablespace basis. The following scripts reports the
Oracle RMAN Tutorial Part 3 Recovery Operation
Block Media Recovery
check the corrupted block using following sql command.
SQL> select * from v$ database_block_corruption;
check the corrupted block using following sql command.
SQL> select * from v$ database_block_corruption;
Oracle RMAN Tutorial Part 2 BACKUP OPERATION
Full database backup using RMAN
RMAN> backup as backupset database spfile;
RMAN> sql 'alter system archive log current';
RMAN> backup as backupset database spfile;
RMAN> sql 'alter system archive log current';
Oracle RMAN Tutorial Part 1 Creating and configuring RMAN repository
Here are the basic description on RMAN configuration and setup. By reading this article you can configure a RMAN by yourself in a very practical manner. I have only concentrated on RMAN practical implementation perspective here.
Brief steps for Installing and Configuring RAC oracle database on ASM
software that is required
1. oracle database [11]
2. oracle clusterware
1. oracle database [11]
2. oracle clusterware
How to change the init parameter when oracle database is using SPFILE
first check db is running in SPFILE or PFILE using the following script.
SQL> SELECT instance_name,
DBA Admin06 - Archived Redo Log Files
Oracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log. The process
Subscribe to:
Posts
(
Atom
)