|
||||
|
ADRCI: Automatic diagnostic repository command interface, used to manage the diagnostic, health monitor, or incident packaging solutions for Oracle databases. This is the small adrci automatic purge script rather to rely on traditional log purging or housekeeping scripts. This script will check in /etc/oratab and list down all oracle homes and then set those Oracle […]
Housekeeping of logs , traces, diag directories is every DBA’s job and some may write their own , some adopt from others which is common. Often we found in our environments similar sort of scripts placed, which I found mostly were Non Pluggable to any new environments You cannot port it to others or […]
When I was working for a tool in Apex some time back, need some scripts on automatic date generation, after some googling and changing the modified ones, here are some scripts that useful to generate a date in sequence etc.
Generating dates for a month =================== select to_date(’01 2010′,’MM YYYY’)-1 + level as […] Want to know new features in 12c, 18c, 19c, 20c ??? Follow this More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/ More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/ More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/ Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/ Hello The following code snippets are collected from various sources and updating here, (not sure even about […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!