Месяц: Декабрь 2015
work with whitespace in bash scripts
example: psql -U username -qAt -c «select ftp_file_path from ftp_file_headers where 1=1 and ftp_file_type=’tm’;» | while read folder; do echo $folder ; done
SYS_OP_C2C full table scan
on prod system we have query that use FTS instead of IRS this is because developers put in bind variable nvarchar2 ( you may find bind type in v$sql_bind_capture ) instead of varchar2, they say that they can’t change code solved by
select from v$restore_point without catalog role
and you can grant select on this funtion to every one, without FLASHBACK ANY TABLE\SELECT_CATALOG_ROLE\SELECT ANY grants:
Oracle Memory Architecture
http://www.datadisk.co.uk/html_docs/oracle/memory.htm copy to my blog Oracle Memory Architecture Oracle uses three kinds of memory structures SGA (System Global Area) is a large part of memory that all the oracle background processes access. PGA (Process Global Area) This is memory that is private to a single process or thread and is not accessible by … Читать далее
script to slice awr\ash report by time
replace dba_hist_active_sess_history with v$active_session_history to get ash info
oracle 12c new features index:
CDB and PDB View • CDB_xxx: All of the objects in the CDB across all PDBs • DBA_xxx: All of the objects in a container or PDB • CDB_pdbs: All PDBs within CDB • CDB_tablespaces: All tablespaces within CDB • CDB_users: All users within CDB (common and local) • V$PDBS: Displays information about PDBs associated … Читать далее
Real-Time Database Operation Monitoring
A database operation is: • One or more SQL or PL/SQL statements • A series of statements done from on or more sessions A database operation can: • Be monitored • Produce active reports A DB operation is an operation that the database server runs to accomplish tasks. It can be either simple or composite. … Читать далее
Oracle Data Redaction
Available Redaction Methods Type Description None No redaction is performed. Full Columns are redacted to constant values based on the column data type. Partial User-specified positions are replaced by a user-specified character. Random Data type is preserved and different values are output each time. Regular Expression A “match and replace” based on parameters is performed. … Читать далее
Privilege Analysis
Oracle Database 12c offers a new package to analyze used privileges. Privilege Analysis requires Oracle Database Vault, which is a licensed option. good tutorial: Privilege Analysis Types and Conditions When creating an analysis, you first define the targeted objects to be analyzed in used privileges. You do that by setting the type of analysis: • … Читать далее