Arvind Toorpu

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, where the value TRUE signifies…

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…