To get the LOGFILES INFORMATION from the database
col member for a65
select
lf.MEMBER,l.GROUP#,THREAD#,SEQUENCE#,MEMBERS,bytes/1024/1024 “BYTES IN
MB”,ARCHIVED,l.status from v$log l,v$logfile lf where l.GROUP#=lf.GROUP#
Related blogs
Database Blog
Query to Identify Initial and Latest Login Sessions in Oracle Database
Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…
Database Blog
Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)
Please follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…
Database Blog
How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…