Home

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

 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…

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…