Oracle DBA

To identify the reasons for the increasing TEMP tablespace usage in Oracle 19c, you can use various SQL queries and commands to gather information about the current state of the database. SQL query for assessing both used and available space within the temporary tablespace:  SQL>SELECT *FROM(SELECT a.tablespace_name,SUM(a.bytes/1024/1024) allocated_mbFROM dba_temp_files aWHERE a.tablespace_name = ‘TEMP’GROUP BY a.tablespace_name) […]

Create below procedure and use to drop database links Details for using this script is given here CREATE OR REPLACE PROCEDURE DROP_DBLINKS(SCHEMANAME VARCHAR2, DBLINK VARCHAR2) IS PLSQL VARCHAR2(1000), CUR NUMBER, U_ID NUMBER, RC NUMBER; BEGIN SELECT U.USER_ID INTO U_ID FROM DBA_USERS U WHERE U.USERNAME=SCHEMANAME; PLSQL := ‘DROP DATABASE LINK ‘ || DBLINK; CUR := SYS.DBMS_SYS_SQL.OPEN_CURSOR; […]