Oracle DBA by Example. Code samples, Scripts, Reference.
Pages
(Move to ...)
Home
▼
Thursday, November 24, 2016
Code Example. crontab task to TRUNCATE table on ongoing basis
›
==================================== General ==================================== Due to a bad application design, debug tables are const...
Wednesday, November 16, 2016
Code example: plsql block in loop, and writing to file
›
======================== General ======================== Example of bash file calling sql file, which is executing a plsql block. The p...
Monday, November 14, 2016
Code example: batch files in Windows
›
=============================== General =============================== Code examples for batch files 1. Batch file to delete files olde...
Thursday, November 10, 2016
Oracle by Example: Investigating locks in V$ACTIVE_SESSION_HISTORY
›
========================= General ========================= For some reason, response time from database was very slow. From several mil...
Sunday, November 6, 2016
Oracle by Example: Move Indexes from one tablespace to another
›
======================================== General ======================================== The tablespace which is storing indexes has gro...
‹
›
Home
View web version