-
Upgrading Opatch from 10.2.0.4.2 to 10.2.0.5.1 Version
Continue reading →: Upgrading Opatch from 10.2.0.4.2 to 10.2.0.5.1 VersionUpgrading Opatch to Latest Version : It is so simple to upgrade th Opatch version for your database. I will check my current version of Opatch [oracle@linux5 OPatch]$ opatch version Invoking OPatch 10.2.0.4.2 OPatch Version: 10.2.0.4.2 OPatch succeeded. Now download…
-
Why is Swapping Bad for oracle?
Continue reading →: Why is Swapping Bad for oracle?Linux OS is a virtual memory system like any other modern operating system. The Virtual Memory Management system of Linux includes: Paging Swapping HugePages Slab allocator Shared memory When almost all of the available physical memory (RAM) is started to…
-
ORACLE GOLDEN GATE INSTALLATION
Continue reading →: ORACLE GOLDEN GATE INSTALLATIONwill start the post soon with all installation steps & snapshots ………
-
script to get all table and system privileges granted to a user
Continue reading →: script to get all table and system privileges granted to a userDescription This script all table and system privileges granted to a user. The scripts also takes into acount those privileges assigned via roles granted via roles Parameters username – The username to display privileges for SQL Source REM Copyright (C)…
-
Oracle Password Verification function
Continue reading →: Oracle Password Verification functionPassword Verification : Enforcing Password Complexity Password complexity is enforced using a verification function. Oracle provide an example password verification function in the “$ORACLE_HOME/rdbms/admin/utlpwdmg.sql” file, but you can code a custom one if you prefer. The function must accept three…
-
FLASHBACK STANDBY DATABASE
Continue reading →: FLASHBACK STANDBY DATABASEFLASHBACK STANDBY SQLPLUS commands to turn off DATA GUARD temporarily in order to activate the physical standby for testing purposes. Notice commands are indicated by PRMY or STBY designation for which database they need to executed on. 11g reduces these…
-
Some Very usefull Oracle Views
Continue reading →: Some Very usefull Oracle ViewsOracle Views dba_cons_columns dba_constraints dba_data_files dba_ddl_locks dba_errors dba_extents dba_free_space dba_indexes dba_jobs dba_lock dba_objects dba_role_privs dba_roles dba_rollback_segs dba_segments dba_source dba_tab_columns dba_tables dba_temp_files dba_triggers dba_ts_quotas dba_undo_extents dba_users dba_mview_logs dba_mview_refresh_times dba_mviews v$archived_log v$asm_disk v$backup_datafile v$controlfile v$database v$datafile v$db_cache_advice v$filestat v$instance v$lock v$locked_object…
-
Rman backup status
Continue reading →: Rman backup status——————————— Check if rman is still runnning —————————— select sid, start_time, totalwork sofar, (sofar/totalwork) * 100 pct_donefrom v$session_longopswhere totalwork > sofarAND opname NOT LIKE ‘%aggregate%’AND opname like ‘RMAN%’; select sid, spid, client_info, …
-
using sqlloader to insert data in database table
Continue reading →: using sqlloader to insert data in database tableOracle SQL Loader – Importing CSV files to a table This post shows how to easily insert data from a CSV file into a database table, using the Oracle SQL Loader tool. We will only concentrate on importing CSV formatted…
-
Finding out Last DDL and DML Activity on a Table
Continue reading →: Finding out Last DDL and DML Activity on a TableFinding out Last DDL and DML Activity on a Table Here is a small piece of SQL Commands to get the same info create table t (t1 number,t2 varchar2(20),t3 date); Table created. Here is how you could find the same…



