Oracle DBA by Example. Code samples, Scripts, Reference.
Pages
(Move to ...)
Home
▼
Wednesday, September 13, 2023
Rebuild database by export import
›
Rebuild database by export import SELECT username FROM ALL_USERS ORDER BY username; COL_SPARX IND_MOCOQ IPN_STRESS SELECT DISTINCT owner ...
Monday, September 11, 2023
MTTR Finding - use fast_start_mttr_target instead of log_checkpoint_timeout
›
When running AWR, the ADDM recommendation section suggest below findings: Finding 3: Checkpoints Due to MTTR Impact is .07 active sessions, ...
Wednesday, August 16, 2023
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
›
Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor tnsping is working tnsping igt TNS Ping Ut...
Thursday, August 10, 2023
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
›
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. df -hP Archive destination /oracle_db/db2 is 100% full Need to delete some...
Monday, July 10, 2023
How to generate AWR, ADDM, STATSPACK reports.
›
================================ General ================================ AWR, ADDM, STATSPACK, AWRDDRPT reports. gen_awr.sh #! /bin/ba...
Thursday, July 6, 2023
Oracle Supplemental Logging. How to see current status, add logging to a table, remove logging from a Table
›
=========================== General =========================== Oracle Supplemental Logging, for Oracle 11.2 Oracle GoldenGate depends on...
‹
›
Home
View web version