GandzyTM
GandzyTM
/ function.py
Created
April 28, 2023 09:33
— forked from petrprikryl/function.py
Django table function
This file contains 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
| ############################# | |
| # Table Functions | |
| ############################# | |
| ''' | |
| CREATE OR REPLACE FUNCTION get_user(INTEGER DEFAULT NULL, VARCHAR DEFAULT NULL) | |
| RETURNS TABLE( | |
| id INTEGER, | |
| user_id INTEGER, | |
| one_id INTEGER, | |
| username VARCHAR, |
GandzyTM
/ dbdailychk.sh
Created
December 22, 2020 05:05
— forked from travelliu/dbdailychk.sh
Oracle Database Health Check Script
This file contains 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
| # ############################################################################################## | |
| # DAILY HEALTH CHECK MONITORING SCRIPT | |
| # | |
| # ========================================================= | |
| # BECAUSE OF THE PERFORMANCE IMPACT THIS SCRIPT CAN CAUSE, | |
| # I STRONGLY RECOMMEND TO SCHEDULE IT TO RUN IN NON PEAK HOURS | |
| # E.G. SCHEDULE IT TO RUN ONE TIME BETWEEN 12:00AM to 5:00AM | |
| # ========================================================= | |
| # | |
| # FEATURES: |