SQL statements to get quick information about database state and get daily things done. Statements were tested on 12c Release 1 and 2 environments, but most of them also apply to 11g.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import logging | |
import os | |
import time | |
class Logger: | |
FORMATSTR = '%(asctime)s\t| %(levelname)-6s | %(message)s' | |
TIMESTR = time.strftime("%Y%m%d") | |
def __init__(self, log_folder, log_file): | |
self.log_file = log_file |