Nice and easiest way to to extract the DDL for all tablepaces..  Generate the DDL using the below query and you can re create the table spaces in any environment with any changes you want to make. set heading off;set echo off;Set pages 999;set long 90000; spool ddl_list.sql select dbms_metadata.get_ddl(‘TABLESPACE’,tb.tablespace_name)…

Upgrading 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 the latest Opatch version from oracle support site.in this case…

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 be used in Linux, the kernel will start to swap…

will start the post soon with all installation steps & snapshots ………

Description 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) Think Forward.com 1998- 2005. All rights reserved. set echo offset…

Password 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 parameters (username, password and old_password) and return a boolean value,…

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 v$log v$logfile v$parameter v$process v$segment_statistics v$session v$session_longops v$session_wait v$sesstat v$sort_usage…

——————————— 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,    event,    seconds_in_wait,    p1, p2, p3 from    v$process p,…

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 data to the Oracle table with a 1-to-1 column mapping,…