Query to Check Installed component in the oracle database?

Here are the two queries to find out the installed components in the oracle database. 

set pages 1000 lines 120 
col comp_name for a40 
1. select comp_name, version, status , modified from dba_registry; 
2. select parameter from v$option where value = 'TRUE' order by parameter; 

Purge AWR Snapshots Manually from Oracle Database

Query to find AWR snapshot retention period using below query.

SQL> select dbms_stats.get_stats_history_retention from dual;


SQL Query to Find Out the Locked Objects and Type of Lock

Here is the query to find the locked object, mode of locks etc. 

Providing 2 different queries. 

SQL Query

Script to Get the Most CPU Consuming Sessions from Oracle Database

SQL Script 

This SQL query gives you output of 10 most CPU consuming oracle sessions.

SQL Query to Find Out Hourly Redo Log Generation

This query will give you the hourly redo log generation for each day. 

SQL Query

Fix Dell Latitude Laptop Speaker Volume is Very low for zoom, skype etc

I got a new dell latitude laptop, and everything looks good. But when I use speaker for the zoom call the volume is very feeble. This is not happening with any other programs like video or YouTube. The headset is giving better output with the volume. 

Sql Query to Check Different Client Character Set, Client Version and Client Driver or Software Connected to The Database

In this post provides you queries to find out the different client connection details like character set, the client software or driver etc. with their count. 


Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer