Archive log Generation detail
select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'m…
- Home
- Recent
- Scripts
- _Option Pack Script
- _DB Info Script
- Pyspark
- _Big-Data
- _HDFS Architecture
- _Distributed Processing
- _Core_API
- _DataFrame and Spark SQL
- _DataFrames Transformation in Spark
- _Caching and Persist
- _YARN Architecture
- _Spark Internal Workflow
- _Spark Optimization
- _Memory Optimization in Spark
- Databricks
- _Cloud Fundamental
- _Databricks Fundamental
- _Azure Storage, managing secrets, and working with Delta Lake
- _Delta Architecture
- _Lakehouse Architecture
- _Unity Catalog
- ADF
- _ADF Overview
- _Pipeline and Triggers
- _Azure Synapse
- Additional
- _Git and Github
- _Hive
- _Data Modeling
- _Data Processing-Batch vs Stream
- _Autoloader
- _Structure Streaming
- _Apache Kafka
- DBA
- _RMAN-list-backup-summary
- _Hostname from /etc/hostname & DNS domain name
- _When-to-rebuild-indexes
- _ctxddlsyncindex-fails-with-drg-50857
- _Too many inactive sessions
- _CDB or Non-CDB
- _Sessions Generating Lots of Redo or Archive logs
- _Redo-log-size-switch-frequency
- _Maintain and/or Add Redo Logs
- _Kill-inactive-sessions
- _Home processes Application issue causing MAX PROCESSES to be exceeded
- _Clean-inactive-oracle-sessions
- _Directories that have been modified today
- _Check-status-enable-and-disable-audit
- _Archive log Destination is full, DB is hung due to FRA is full
- _Maximum Number of Processes Exceeded
- _Auto Start Database in Linux
- _Transfer file on Linux - rsync
- _tar and untar the files
- _User Role Privilege: Unlock and Change Password
- _Advance-compression-diagonostic-pack
- _Database-information-script
- _Instance-details
- _Network access denied by access control list (ACL)
- _Tablespace-monitoring
- _RMAN-backup-script-on-windows-server
- _Archive-log-generation-detail
- _Session-login-detail
- _Non-CDB Oracle Database vs Single/Multitenant (CDB/PDB) Oracle Database and how to identify