Oracle Linux yum/wget proxy Tips
Linux Yum/Wget proxy setting
Oracle 12c PDB LOCKDOWN Profiles Tips
Oracle Database 12.2 New Feature – PDB Lockdown Profiles
Having fun with PDB LOCKDOWN PROFILES
oracle 12cR2新特性-PDB lockdown profile
Have a good work&life! 2019/09 via LinHong
Oracle 19c Query the patch Tips
Query the patch applied on database 19c.
SYS@orcl> !cat patch_list.sql
set line 300
col action form a12
col version form a40
col comments form a60
col action_date form a20
select comments, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, version from registry$history order by action_date;
set line 300
col action form a12
col version form a40
col description form a60
col action_date form a20
select description, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version from dba_registry_sqlpatch;
SYS@orcl>
Oracle 19c Import with disable_archive_logging Tips
Oracle12c feature is the ability to run in nologging mode in import execution, disabling archive logging during a large import. Only for table and index Not for tablespace.
transform=disable_archive_logging:Y
transform=disable_archive_logging:Y:tablename
transform=disable_archive_logging:Y:indexname
Linux 7 enable Autostarting of Oracle Database 19c Tips
The PLUSTRACE ROLE Tips
The Tips with seting up the autotrace role-PLUSTRACE.
Unix Shell Tips
Oracle Tools Tips
Find monitor tools for load test……
Have a good work&life! 2019/07 via LinHong
Oracle 12c MAX_IDLE_TIME Tips
Oracle Drop User Tips
Oracle ATP Swingbench Tips