| IMG_01 | DB_STRUCTURE | KNOWLEDGE | Oracle 11g/12c database memory, process, and physical structure. |
| FILE_01 | OCA_11G_TUTORIAL | KNOWLEDGE | Oracle 11g OCA tutorial. |
| FILE_02 | OCA_12C_TUTORIAL | KNOWLEDGE | Oracle 12c OCA tutorial. |
| DOC_01 | NLS_DATE_FORMAT | SQL | SQL for altering session NLS date format. |
| DOC_02 | DATA_PUMP | KNOWLEDGE | Oracle Data Pump related knowledge and commands. |
| DOC_03 | MSMTP_MSWIN | KNOWLEDGE | Configure MSMTP email client on windows system. Download |
| DOC_04 | BLAT_MSWIN | KNOWLEDGE | Configure BLAT email client on windows system. Download |
| DOC_05 | ARCHIVE_LOG_PERIOD | SQL | SQL for querying archived log generated size by hour or day. |
| DOC_06 | LINUX_FOLDER_SIZE | COMMAND | Linux command for sorting folder size. |
| DOC_07 | BLOCKING_SESSION | SQL | SQL for quering blocking session wait and resolve procedure. |
| DOC_08 | PROCESS_ID_SQL | SQL | SQL for querying full SQL text and session ID via Linux process ID. |
| DOC_09 | DATABASE_SIZE | SQL | SQL for querying database full size, temp size, and free size. |
| DOC_10 | FRA_UTILIZATION | SQL | SQL for querying FRA utilization. |
| DOC_11 | DML_LAST_MODIFY | SQL | SQL for querying object last DML modification time. |
| DOC_12 | SESSION_PERIOD | SQL | SQL for querying session number by period. |
| DOC_13 | OBJECT_DDL | SQL | SQL for quering object DDL. |
| DOC_14 | LOG_MINER | KNOWLEDGE | Oracle log miner guide. |
| DOC_15 | REDO_MULTIPEX | KNOWLEDGE | Procedure of multiplexing redo log group. |
| DOC_16 | LONG_OPERATION | SQL | SQL for quering long operation running within database. |
| DOC_17 | TABLESPACE_DATAFILE | SQL | SQL for checking tablespace utilization, and adding data file procedure. |
| DOC_18 | ASM_UTILIZATION | SQL | SQL for checking ASM disk group utilization. |
| DOC_19 | RESTORE_PROGRESS | SQL | SQL for checking RMAN database restore progress. |
| DOC_20 | DATAFILE_RELOCATION | KNOWLEDGE | Oracle data file relocation procedure. |
| DOC_21 | TEMP_TABLESPACE_RECREATION | KNOWLEDGE | Procedure of recreating Oracle database default temp tablepace. |
| IMG_02 | PROCESS_EXPLORER | KNOWLEDGE | Tool for monitoring Windows processes. Download |
| DOC_22 | INVALID_OBJECT | SQL | SQL for querying invalid objects. |
| DOC_23 | PATCHING_MSWIN | KNOWLEDGE | Oracle Windows platform bundle patching procedure. |
| DOC_24 | AUDIT_FILE_CLEANING | SHELL | Linux shell script for cleaning huge size auditing files by time period. Download |
| DOC_25 | LISTENER_LOG_ROTATION | BATCH | Windows batch script for rotating listener log. Download |
| DOC_26 | SYS_AUDIT_CLEANING | BATCH | Linux shell script for cleaning auditing information from sys$aud table. Download |
| DOC_27 | RAC_MSWIN_REBOOT | BATCH | Windows batch scripts for rebooting system with Oracle cluster. Download |
| DOC_28 | MULTIPLE_INSTANCES_REBOOT | SHELL | Linux shell scripts for rebooting multiple database instances. Download |
| DOC_29 | IMPDP_AUTO_REFRESH | SHELL | Linux shell scripts for impdp auto refresh. Download |
| DOC_30 | LINUX_CRONTAB_TITLE | KNOWLEDGE | Linux crontab job title. |
| DOC_31 | LINUX_RMAN_BACKUP | SHELL | Linux shell scripts for RMAN level 0 and level 1 backup. Download |
| DOC_32 | LINUX_EXPDP_BACKUP | SHELL | Linux shell scripts for data pump expdp backup. Download |
| DOC_33 | MSWIN_EXPDP_BACKUP | BATCH | Windows batch script for data pump expdp backup. Download |
| DOC_34 | MSWIN_RMAN_BACKUP_DAY | BATCH | Windows batch script for rman backup. Download |
| DOC_35 | SGA_UTILIZATION | SQL | SQL for querying SGA utilization divided by individule component. |
| DOC_36 | PGA_UTILIZATION | SQL | SQL for querying PGA utilization divided by individule component. |
| DOC_37 | OCA_EXAM | KNOWLEDGE | Oracle OCA 12c & 11g exam overview introduction. |
| DOC_38 | LISTENER_REGISTRATION | KNOWLEDGE | Registering a created listener within database. |
| DOC_39 | MSWIN_BATCH_COMMAND | KNOWLEDGE | Windows frequently used batch commands. |
| DOC_40 | MSWIN_SHUTDOWN_TYPE | KNOWLEDGE | Address shutdown type via terminating Oracle service on Windows platform. |
| DOC_41 | MEMORY_PARAMETER | KNOWLEDGE | Knowledge of SGA/PGA auto memory management [AMM] parameters. |
| DOC_42 | ENABLE_ARCHIVELOG | KNOWLEDGE | Enable Oracle database archive log mode. |
| DOC_43 | SESSION_STATUS | SQL | SQL for checking and killing session count by time frame. |
| DOC_44 | SESSION_KNOWLEDGE | KNOWLEDGE | Knowledge of Oracle session. |
| DOC_45 | SCHEMA_SYNONYM | KNOWLEDGE | Creating synonym of a schema. |
| DOC_46 | CPU_LOADAVERAGE | KNOWLEDGE | Knowledge of CPU loadaverage. |
| DOC_47 | CPU_CORE | KNOWLEDGE | Knowledge of CPU/CORE count information on Linux and Windows system. |
| DOC_48 | WINDOWS_REGISTRY | KNOWLEDGE | Knowledge of Windows operating system registry. |
| DOC_49 | TEMP_TABLESPACE_SESSION | SQL | SQL for querying temp tablespace utilization by session. |
| DOC_50 | OBJECT_LOCK | SQL | SQL for querying locks attached on table objects. |
| DOC_51 | DISK_LEVEL | KNOWLEDGE | Knowledge of RAID hard disk level defination.View |
| DOC_52 | DISK_BITS | KNOWLEDGE | Knowledge of disk bits, bytes, and network speed Mbps. View |
| DOC_53 | HOST_FILE | KNOWLEDGE | Knowledge of Linux/Windows host file. |
| FILE_03 | OPERATING_SYSTEM_TUTORIAL | KNOWLEDGE | Operating system concept tutorial. |
| DOC_54 | SEGMENT_SIZE | SQL | SQL for querying schema, table segment size. |
| DOC_55 | DATABASE_CHECKPOINT | KNOWLEDGE | Knowledge of database checkpoint event. View |
| DOC_56 | RMAN_PROGRESS | SQL | SQL for checking RMAN restore progress. |
| DOC_57 | KERNEL_SHELL | KNOWLEDGE | Knowledge of Operating System kernel and shell. |
| DOC_58 | HIGH_WATER_MARK | KNOWLEDGE | Knowledge of Oracle data file block high water mark. |
| DOC_59 | PUBLIC_PRIVATE_KEY | KNOWLEDGE | Knowledge of SSH RSA public and private key. View |
| DOC_60 | CPU_ELAPSE_TIME | KNOWLEDGE | Knowledge of CPU time, elapse time, and associated subdivision. View |
| DOC_61 | WINDOWS_API | KNOWLEDGE | Knowledge of Windows operating system API. |
| DOC_62 | WINDOWS_SERVICE | KNOWLEDGE | Knowledge of Windows service. |
| DOC_63 | RMAN_COMMAND | COMMAND | RMAN commands. |
| DOC_64 | ORACLE_WALLET | KNOWLEDGE | Knowledge of Oracle wallet, and wallet manager. |
| DOC_65 | CLIENT_LISTENER | KNOWLEDGE | Knowledge of Oracle client initating session with remote listener. |
| DOC_66 | DATABASE_SCN | KNOWLEDGE | Knowledge of Oracle database SCN. View |
| DOC_67 | ASYNCHRONOUS_IO | KNOWLEDGE | Knowledge of Operating System asynchronous I/O. View |
| DOC_68 | CONTROL_FILE | KNOWLEDGE | Knowledge of Oracle database control file. |
| DOC_69 | CPU_MODE | KNOWLEDGE | Knowledge of CPU kernel and user mode. |
| DOC_70 | SYSTEM_CALL | KNOWLEDGE | Knowledge of process mode means by system call. |
| DOC_71 | MEMORY_PROCESS | KNOWLEDGE | Knowledge of how process running in memory. |
| DOC_72 | RMAN_RESTORE_RECOVER | KNOWLEDGE | Procedure of rman restore and recover a database. |
| DOC_73 | LINUX_SCP | COMMAND | Command of Linux SCP transferring files between servers. |
| DOC_74 | NETWORK_TYPE | NETWORK | Knowledge of network type, such as LAN, WAN. |
| DOC_75 | NETWORK_TOPOLOGY | NETWORK | Knowledge of network topology, such as bus, ring, star, and mesh. View |
| DOC_76 | NETWORK_BACKBONE_DEVICE | NETWORK | Network backbone device, such as modem, hub, bridge, switch, and router. View |
| DOC_77 | NETWORK_IP_PACKET | NETWORK | Knowledge of network IP packet. |
| DOC_78 | NETWORK_VPN | NETWORK | Knowledge of network VPN. View |
| DOC_79 | NETWORK_DNS | NETWORK | Knowledge of domain name server [DNS]. View |
| DOC_80 | NETWORK_GATEWAY | NETWORK | Knowledge of network gateway. View |
| DOC_81 | NETWORK_ADAPTER | NETWORK | Knowledge of network adapter or network interface card. View |
| DOC_82 | NETWORK_PUBLIC_PRIVATE_IP | NETWORK | Knowledge of network public and private IP. |
| DOC_83 | NETWORK_PORT | NETWORK | Knowledge of network server port. |
| DOC_84 | NETWORK_PROXY | NETWORK | Knowledge of network proxy server. |
| DOC_85 | NETWORK_DIGITAL_CERTIFICATE | NETWORK | Knowledge of network digital certificate. View |
| DOC_86 | NETWORK_MAC_ADDRESS | NETWORK | Knowledge of network MAC address. View |
| DOC_87 | NETWORK_SUBNET_MASK | NETWORK | Knowledge of network subnet mask. |
| DOC_88 | NETWORK_TCP_IP | NETWORK | Knowledge of network TCP/IP protocal layer model. |
| DOC_89 | MOUNT_DISK | LINUX | Knowledge of mounting disk with file system on Linux platform. |
| DOC_90 | ODA_SR | ORACLE | Procedure of configuring Oracle Database Appliance [ODA box] ASR. |
| DOC_91 | LINUX_TOP | LINUX | Knowledge of Linux top command output. |
| DOC_92 | DISK_INFO | LINUX | Command of displaying hard disks on Linux platform. |
| DOC_93 | IO_STATE | LINUX | Command of displaying IO state on Linux platform. |
| DOC_94 | SWAP_SPACE | LINUX | Knowledge of Linux memory swap space. |
| DOC_95 | MSWIN_ODBC | KNOWLEDGE | Knowledge of Microsoft ODBC driver. |
| DOC_96 | ORACLE_LISTENER | KNOWLEDGE | Knowledge of Oracle listener dedicated and shared mode. View |
| DOC_97 | HARDWARE_STRUCTURE | KNOWLEDGE | Knowledge of server CPU, memory, disk hardware structure. View |
| DOC_98 | ROUTE_TABLE | NETWORK | Knowledge of network route table. |
| DOC_99 | XMING_CONFIG | LINUX | Knowledge of configuring Xming on Linux platform. View |
| DOC_100 | IE_ENABLE_DOWNLOAD | KNOWLEDGE | Knowledge of enabling download on IE browser. View |
| DOC_101 | SWITCH_SCHEMA | KNOWLEDGE | Knowledge of switching schema within Oracle database. |
| DOC_102 | OPTIMIZER_STATISTICS | KNOWLEDGE | Knowledge of Cost-Based Optimizer [CBO] statistics. View |
| DOC_103 | FLUSH_SHARED_POOL | KNOWLEDGE | Flushing a single SQL statement from library cache or whole shared pool. |
| DOC_104 | EXECUTION_PLAN | KNOWLEDGE | Knowledge of explaining an Oracle execution plan. |
| DOC_105 | BACKUP_SET_PIECE | KNOWLEDGE | Knowledge of Oracle backup set and piece. View |
| DOC_106 | ADDING_PRIMARY_KEY | KNOWLEDGE | Creating trigger and sequence to add primary key on an existing table. |
| DOC_107 | TDE_KEYSTORE_SOFTWARE | KNOWLEDGE | Creating Oracle software keystore for TDE master encryption key. |
| DOC_108 | DATABASE_SHARED_DRIVE | KNOWLEDGE | DB failed to start with access denied error due to files on Windows shared drive. |
| DOC_109 | CLEANUP_FILE_MTIME | COMMAND | Linux command of cleaning up files within a folder by mtime. |
| DOC_110 | TDE_LOB_REDEFINITION | KNOWLEDGE | TDE tablespace with Lob data type via online redefinition without db downtime. |
| DOC_111 | TDE_TABLE_REDEFINITION | KNOWLEDGE | Shell script of TDE redefiniting table without Lob segment. Download |
| DOC_112 | TDE_MOVE_TABLE | KNOWLEDGE | TDE tablespace without Lob data via moving table method. Download |
| DOC_113 | TDE_DATA_PUMP | KNOWLEDGE | TDE tablespace with table cotains LONG data type via data pump. |
| DOC_114 | SYSTEM_BOOT_VOLUME | KNOWLEDGE | Knowledge of system and boot volume. |
| DOC_115 | LINUX_VERSION | COMMAND | Knowledge of checking Linux kernel version and OS release. |
| DOC_116 | PUTTY_PUTTYGEN | KNOWLEDGE | Download of Putty and PuttyGen executable file. Download |
| DOC_117 | DISK_MOUNT_POINT | COMMAND | Knowledge of checking Linux disk and mount point. |
| DOC_118 | SYSTEM_OBJECT_PRIVILEGE | SQL | Knowledge of queryng Oracle user system and object privilege. |
| DOC_119 | SOLUTION_ARCHITECT | AWS | Knowledge of AWS solution architect associate certificate exam. |
| DOC_120 | BATCH_DELETE_TIME | COMMAND | Windows batch command to delete files by time for cleanup purpose. |
| DOC_121 | BATCH_SCRIPTING_TIPS | KNOWLEDGE | Windows batch scripting tips. |
| DOC_122 | SAN_NAS | KNOWLEDGE | Knowledge of Storage Area Network[SAN], and Network Attached Storage[NAS]. |
| DOC_123 | NAS_DRIVE_MAP | COMMAND | Command of mapping NAS as Windows drive. |
| DOC_124 | PEOPLESOFT_MONITORING_SCRIPTS | BATCH | Scripts of monitoring PeopleSoft process scheduler, and app process. Download |
| DOC_125 | SESSION_MEMORY | SQL | SQL for quering memory usage by each database session. |
| DOC_126 | REMOTE_DESKTOP_LOGIN | KNOWLEDGE | Knowledge of creating user on Windows, and authorize remote login via VDI/RDP. |
| DOC_127 | STANDBY_ARCHIVEDLOG_CLEANUP | BATCH | Script of wipe out applied archived logs on Windows standby server. Download |
| DOC_128 | LINUX_INTEGRATED_FIREWALL | KNOWLEDGE | RHEL integrated firewall causing Oracle database connection timeout. |
| DOC_129 | TABLE_PERCENT_ANALYZED | SQL | Checking percent of rows applied with insert/update/delete and last analyzed time. |
| DOC_130 | FINE_GRAINED_AUDITING | SQL | Enable Oracle Fine-Grained Auditing[FGA]. |
| DOC_131 | REPLICATE_ROLE_PASSWORD | SQL | Retrieve Oracle db user's password and role, and replicate between databases. |
| DOC_132 | ALERT_LOG_LOCATION | SQL | Command of finding Oracle database alert log location. |
| DOC_133 | TERMINATE_RMAN_SESSION | SQL | Method of terminating RMAN hung session. |
| DOC_134 | ORACLE_PRICE_LIST | KNOWLEDGE | Oracle product globel price list. View |
| DOC_135 | ORACLE_DATA_APPLIANCE | KNOWLEDGE | Oracle Data Appliance[ODA] X6-2M machine configuration and Deployment. |
| DOC_136 | ORACLE_MAINTENANCE_WINDOWS | SQL | SQL for quering Oracle database statistics gathering maintenance windows. |
| DOC_137 | ORACLE_DATAGUARD | KNOWLEDGE | Knowledge of setting up Oracle physical standby via DataGuard. |
| DOC_138 | LAST_LOGIN_TIME | COMMAND | Linux command of checking last login time for OS users. |
| DOC_139 | LINUX_SERVER_UPTIME | COMMAND | Linux command of checking server uptime. |
| DOC_140 | MSWIN_7ZIP | COMMAND | Command and installer of 7-zip/zip utility based on Windows platform. Download |
| DOC_141 | LINUX_CHANGE_TIMEZONE | KNOWLEDGE | Knowledge of changing timezone on Linux platform. |
| DOC_142 | HTTPS_SSL_CERTIFICATE | NETWORK | Renewal HTTPS SSL Certificate for Oracle WebLogic Fusion Middleware. |
| DOC_143 | SYSTEM_STARTUP_TRIGGER | LINUX | Executing script on crontab when Linux system starts up. |
| DOC_144 | SERVICE_ACCOUNT_TYPE | KNOWLEDGE | Knowledge of Windows service user account type detail. |
| DOC_145 | CRONTAB_COMMENT_OUT | LINUX | Comment out and enable certain task on crontab by Linux shell script. |
| DOC_146 | PUTTY_EXPORT_IMPORT | KNOWLEDGE | Putty export/import setting and session info via Windows registry. |
| DOC_147 | AWS_CLI_SSM | AWS | Send command from MSWIN AWS CLI to Linux server on cloud via SSM. Download |
| DOC_148 | RDP_DRIVE_REDIRECTION | KNOWLEDGE | Redirecting Windows drive to remote server via Remote Desktop Connection [RDP]. |
| DOC_149 | RDP_BLANK_SCREEN | KNOWLEDGE | Changing password and resolve blank screen when accessing Windows via RDP. |
| DOC_150 | CONNECTION_SESSION_PROCESS | ORACLE | Knowledge of Oracle database connection, session, and process concepts. |
| DOC_151 | TRACE_SYSTEM_CALL | LINUX | Troubleshoot SQL*Plus login hanging via truss on AIX platform. |
| DOC_152 | OEM_DBCONSOLE | KNOWLEDGE | Oracle Enterprise Manager[OEM] family, and dbconsole installation. |
| DOC_153 | ORACLE_SESSION_TRACING | ORACLE | Oracle session tracing via client identifier. |
| DOC_154 | LINUX_SVN_INSTALLATION | KNOWLEDGE | Install SVN server and repository on RHEL server. |
| DOC_155 | SQL_PLAN_BASELINE | ORACLE | Creating an Oracle SQL plan baseline, and export/import into different database. |
| DOC_156 | MSWIN_BATCH_REFRESH | BATCH | Windows batch scripts of Oracle data pump auto refresh. Download |
| DOC_157 | OS_X86_64 | KNOWLEDGE | Difference between OS 64-bit [x86_64] and 32-bit [x86]. |
| DOC_158 | SQL_TUNING_SET | KNOWLEDGE | Knowledge of Oracle SQL Tuing Set [STS]. |
| DOC_159 | AWR_REPORT_TERMINOLOGY | KNOWLEDGE | Knowledge of Oracle AWR report terminologies. |
| DOC_160 | TABLE_DATA_GROWTH | SQL | SQL of querying how much data growth for individual table. |
| DOC_161 | SHELL_SCRIPTING_TIPS | KNOWLEDGE | Linux shell scripting tips. |
| DOC_162 | UTL_MAIL_ACL | ORACLE | Config Oracle UTL_MAIL package, and access control list [ACL]. |
| DOC_163 | WINDOWS_PAGING_FILE | KNOWLEDGE | Hidden paging file growth gets Windows drive full detected by Cygwin. Download |
| DOC_164 | DATA_PUMP_TRACE | ORACLE | Tracing Data Pump API. |
| DOC_165 | LINUX_DB_AUTO_STARTUP | SHELL | Linux shell script to bring up Oracle database automatically. Download |
| DOC_166 | OLTP_OLAP_DATABASE | KNOWLEDGE | Knowledge of OLTP and OLAP database. |
| DOC_167 | OHS_UPGRADE | KNOWLEDGE | Oracle FMW Web Tier [OHS] upgrade from 11.1.1.7 to 11.1.1.9 to enable TLS 1.2. |
| DOC_168 | ANSIBLE_AWS_EC2 | KNOWLEDGE | Ansible installation on Linux, and create AWS EC2 instance. |
| DOC_169 | FMW_OID_MIGRATION | KNOWLEDGE | FMW installation with OID 12.2.1.3.0 migration. |
| DOC_170 | JRE_JDK_DIFFERENCE | KNOWLEDGE | Difference between Java Development Kit [JDK] & Runtime Environment [JRE]. |
| DOC_171 | STATSPACK_REPORT | ORACLE | Oracle Stats Pack Report implementation and configuration. |
| DOC_172 | CHANGING_LISTENER_PORT | ORACLE | Changing Oracle database listener port. |
| DOC_173 | WEBLOGIC_PATCHING | ORACLE | Apply PSU patch on WebLogic version 12.2.1.3.0. |
| DOC_174 | RAC_RESPONSE_FILE | ORACLE | Oracle RAC 12.2.0.1 installation with response file. Download |
| DOC_175 | LINUX_UNLOCK_USER | KNOWLEDGE | Linux unlock user when access denied caused by multiple password trials. |
| DOC_176 | APACHE_WEBLOGIC_MODULE | KNOWLEDGE | Config Apache mod_wl_ohs module for Oracle WebLogic server proxing. |
| DOC_177 | OS_PASSWORD_EXPIRY | PYTHON | Python script checks OS user password expiry date, and auto reset. Download |
| DOC_178 | WEBLOGIC_SERVER_STATUS | PYTHON | Python script monitors domain and managed server status. Download |
| DOC_179 | SQLPLUS_SESSION_ID | ORACLE | Find session id when starting an Oracle database session. |
| DOC_180 | ARCHIVELOG_LOCATION | ORACLE | Find Oracle database archive log location. |
| DOC_181 | ORACLE_FLASHBACK | ORACLE | Knowledge of Oracle Flashback Technology, such as flashback query, restore point. |
| DOC_182 | JAVA_UPGRADE | KNOWLEDGE | JDK upgrade on Linux with Fusion Middleware, Forms, and Internet Directory. |
| DOC_183 | KEYTOOL_IMPORT_CERTIFICATE | ORACLE | Oracle KEYTOOL to insert trust certificate. |
| DOC_184 | DATAGUARD_CONCEPT | ORACLE | Oracle Data Guard concepts, standby redo log, and 3 protection mode. |
| DOC_185 | GOLDENGATE_INSTALLATION | ORACLE | Oracle GoldenGate 19c configuration with 19c database on RHEL 8. |
| DOC_186 | SUPPLEMENTAL_LOGMINING | ORACLE | Oracle GoldenGate supplemental LogMiner with table ROWID. |
| DOC_187 | PORT_LISTENING | LINUX | Check each port is being listened by which process. |
| DOC_188 | MBEAN_SSL | ORACLE | Disable SSL of OID collocated service HTTPS port via Fusion Middleware OEM MBean. |
| DOC_189 | SELF_SIGNED_CERTIFICATE | WEBLOGIC | Created self-signed certificate for WebLogic managed server. |
| DOC_190 | LINUX_SWAP_SCRIPT | LINUX | Linux shell script to check swap utilization by session. Download |
| DOC_191 | WEBLOGIC_DECRYPT_KEY_PASSWORD | WEBLOGIC | Python script to decrypt priviate key password in WebLogic keystore. Download |