List of Common Oracle Metrics Monitoring Methodologies Reactive Proactive Reactive monitoring is not a recommend approach but at times it becomes inevitable. Oracle 10g provide tools that aid in proactively monitoring database. Server-generated alerts and Automated Database Diagnostic Monitor(AADM) are going to be discussed in another post. Database and Instance Metrics Performance measurements [...]
Archive for the ‘Uncategorized’ Category
17 Sep
Increasing Recovery Area Size
To verify this run the following query. It will show the size of the recovery area and how full it is: set lines 100 col name format a60 select name , floor(space_limit / 1024 / 1024) “Size MB” , ceil(space_used / 1024 / 1024) “Used MB” from v$recovery_file_dest order by name / To fix the [...]
4 Aug
SQL Server 2008 Backup
Backup Types SQL Server 2008 allows you to create four different types of backups: Full Backups Differential Backups Transaction log Backups Filegroup Backups Full Backups A full backup captures all pages within a database that contain data. Pages that do not contain data are not included in the backup. Because it is more common to [...]
3 Jul
How to debug a Shell Script on Unix or Lunix
How to debug a Shell Script Use -x option to debug a shell script Run a shell script with -x option. This is valid for bash shell scripts as well. $ ksh -x tesh.sh$ ksh -v test.sh Use of set builtin command korn shell offers debugging options which can be turn on or off using [...]
20 Jun
Unicode Characterset in Oracle
Before starting this post let’s have an idea about unicode. Unicode is a Universal encoding scheme which is designed to include far more characters than the normal character set, in fact, Unicode wants to be able to list ALL characters. So, with unicode support in oracle data from any languages can be stored and retrieved [...]
