Home

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 v$sqlarea v$statname v$sysstat v$system_event v$tempfile…

——————————— 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,    v$session s where    p.addr…

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, otherwise I will need to…

 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…