Virtual Private Database (VPD) Demo.

Security is very important in today technology world. for example in the company, the CEO doesn't want the employees working in the Department 20 see the salary of the employees working in Department 10. especially End Of Year..hehe..you know that. So in this demo I will show you how to implement the Virtual Private Database(VPD) in Oracle Database. using this method we can restrict the condition and archive this goal. I will create a policy to let the employees to see only his/her own Department Data(Deptno 20).

1. Before apply the policy

2. Creating the policy function.

3. Creating the security policy. (on user sys)

4. Verifying the policy

We can see that user can see only data of Department num 20.

5. To drop the policy

EXECUTE dbms_rls.drop_policy('HR','EMPLOYEES','EMP_DEPT_20');

DB init.ora for Flexcube

init.ora parameter recommendation for Flexcube:

FCUAT12.__data_transfer_cache_size=0

FCUAT12.__db_cache_size=9797894144

FCUAT12.__java_pool_size=67108864

FCUAT12.__large_pool_size=268435456

FCUAT12.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

FCUAT12.__pga_aggregate_target=4160749568

FCUAT12.__sga_target=12482248704

FCUAT12.__shared_io_pool_size=536870912

FCUAT12.__shared_pool_size=1677721600

FCUAT12.__streams_pool_size=0

*._allow_level_without_connect_by=TRUE

*.audit_file_dest='/u01/app/oracle/admin/FCUAT12/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

*.control_files='/data/oratest/FCUAT12/control01.ctl','/data/fast_recovery_area/FCUAT12/control02.ctl'

*.cursor_sharing='FORCE'

*.db_block_size=8192

*.db_cache_advice='OFF'

*.db_domain=''

*.db_name='FCUAT12'

*.db_recovery_file_dest='/data/fast_recovery_area'

*.db_recovery_file_dest_size=4560m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=FCUAT12XDB)'

*.fast_start_mttr_target=300

*.job_queue_processes=16

*.log_buffer=115343360

*.memory_max_target=16642998272

*.memory_target=16642998272

*.nls_date_format='DD-MON-RRRR'

*.open_cursors=5000

*.optimizer_dynamic_sampling=1

*.optimizer_index_caching=90

*.optimizer_index_cost_adj=90

*.parallel_adaptive_multi_user=FALSE

*.parallel_max_servers=32

*.pga_aggregate_limit=0

*.pga_aggregate_target=3960m

*.plsql_code_type='NATIVE'

*.plsql_optimize_level=2

*.processes=550

*.remote_dependencies_mode='SIGNATURE'

*.remote_login_passwordfile='EXCLUSIVE'

*.session_cached_cursors=400

*.sga_target=11881m

*.skip_unusable_indexes=FALSE

*.undo_retention=1800

*.undo_tablespace='UNDOTBS1'

*.utl_file_dir='*'

TFA (Trace File Analyzer)

Topics Include:

++Decrease the number of Reactive issues with Single Instance and RAC ++Promote Best Practices ++Maintain a “healthy” RAC Environment ++SR turnaround time reduced and quicker resolution when dealing with Reactive Types of Issues