Oracle Database Commands and Practical Examples
HOME
(Move to ...)
Home
RMAN
PATCHING
UPGRADE
RAC
EXPDP
Oracle Cloud
MS SQL
POSTGRES SQL
PHP XAMPP
AWS
DATAGUARD
DATABASE TROUBLESHOOTING
PERFORMANCE TUNNING
SIEMENS PLM
Basic German Language
MATLAB
MULTITENANT CDB
GOLDENGATE
SCRIPTS
OEM 13c
Self Learn
▼
Sunday, 25 December 2022
Examples sessions commands
›
Check session level details : set lines 200 pages 1000 col USERNAME for a20 col MACHINE for a20 col PROGRAM for a30 col MODULE for a30 col A...
Db Troubleshooting : Tips to Check alert log file error using command
›
locate <file name> [oracle@srv6 trace]$ locate alert_primary19c.log /u01/app/oracle/diag/rdbms/primary19c/primary19c/trace/alert_pri...
Thursday, 15 December 2022
PT : Load plan hash value from particular sql_id
›
PT : Load plan hash value from particular sql_id Check plan hash value of SQL ID cptjnrc8v4v78 Query : set lines 155 col execs for 999,9...
›
Home
View web version