Oracle 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…

——————————— 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,   …

Oracle 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 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…

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…

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)…

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…

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…

 find all files in directory older than 90days syntax find -type f -mtime +30 -print example   find  -type f -mtime +90 -print delete all files in directory older than 90dayssyntaxfind -type f -mtime +30 -deleteexample : find  /u02/dump -type f -mtime +90…

ORA-28368: cannot auto-create wallet ORA-28368: cannot auto-create wallet ORA-28368: cannot auto-create wallet If you got this error simple create a directory named “wallet” on your $ORACLE_BASE/admin/$ORACLE_SID. SQL> alter system set encryption key identified by manager; alter system set encryption key…