Arvind Toorpu

 Finding 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 OracleDba.In >select  2  (select last_ddl_time from dba_objects where object_name=’T’ and owner=’SYS’) “DDL Time”,  3   decode(maxscn,0,’N/A’,scn_to_timestamp(maxscn))…

Configuration of HugePages for Oracle database 10.2 on Red hat Linux 5.1 Environment: Oracle database 11.2.0.3 Enterprise Edition, Oracle Linux 6.4 64-bitHugePages can give a performance boost on Linux systems with large SGA sizes. However, this is not set up by default, and the configuration can sometimes be a bit tricky. This is how I…

Export/Zip and Unzip/Import using UNIX Pipes If you are creating and using large dump (.dmp) files with Oracle’s export (exp) and import (imp) utilities, you can compress and uncompress the dump file as needed using gzip and gunzip (from GNU) or the unix compress and uncompress utilities.  One problem with this is that you will…

Data Pump Export script for Linux/Solaris Data Pump is a command-line utility for importing and exporting objects like user tables and pl/sql source code from a Oracle database. It’s new since Oracle 10g, and it’s a better alternative for the “old” exp/imp utilities. However, do not use Data Pump to replace a full physical database…

Scheduler and data pump expdb Oracle Enterprise Edition 11.2.0.2Linux x86_64 I would like to routinely export some or all of my database as part of my DR strategy. I have always used crontab to call my expdp script on a routine basis. Now I want to change that from using crontab to using Oracle Scheduler.…