With the article “Query to view the remaining time of REBALANCE,” we have the opportunity to see the status of the REBALANCE, the minutes remaining until the balancing of disks in an ASM Disk Group is completed, and the assigned parallelism. When we add or remove a new LUN to Read more…
With the article “Query to extract long statements from a subsequent SQL_ID EXPLAIN PLAN FOR the statement,” we provide a small PL/SQL procedure that allows you to extract the running statement from a SQL_ID. Additionally, there is the script provided by Oracle that allows you to view the previously explained Read more…
With the article Query size datafiles of a tablespace, we will explain how to identify the sizes of each individual data file in a tablespace. With this query, it is possible to understand if a data file has reached its maximum size or if it still has extents available. Let’s Read more…
With the article “Query to retrieve disk space allocated by DATAFILES but not used”, we provide a statement that allows you to recover disk space, so in case of emergency, we can try to recover some unused GB from the TABLESPACE. Before we start with the article “Query to retrieve Read more…
With the article “Query Oracle sessions processes transactions cursors”, we have the possibility to identify the maximum number of sessions or processes or transactions or cursors, their usage and percentage. Several times I have been contacted by the monitoring group due to the increase in the number of sessions. If Read more…
In the article “Query Oracle LOCK and number of sessions” will be of great help. Especially when the application group is stuck due to database errors and the manager is bombarding you with questions just to make you waste more time. In highly accessed databases, it may happen that, among Read more…
In the article “Query Oracle sessions to date and time”, we can control Oracle sessions before a certain date or time using a specific query. Sometimes, it can be difficult to locate the oldest sessions in the database due to the high number of sessions. The article provides a solution Read more…
With the article “Query sessions holding LOCK,” we can identify the session that is blocking access to other sessions on the contested object. We have already discussed in previous articles about disputes in the Oracle database: Query LOCK and number of Oracle sessions and… The main cause of disputes within Read more…
With the article “Query to see the RMAN sessions”, we have the possibility to verify if the RMAN backup is running or not. In case potential backup issues are reported, we can check if the backup schedule time matches the access time of the RMAN sessions on the database. If Read more…
With the article “Oracle User Sessions Query”, we retrieve information about the LOGON, STATUS, SID, software, and machine of all Oracle sessions for a particular user. The first lines of the query concern the formatting of the columns and will help us have a better visualization of the output as Read more…