With the article Query EXTENT TABLE Oracle, we provide a dynamic query to manage the extents of Oracle objects. Additionally, if an object does not have the possibility to extend, we will verify if increasing the number of extents is necessary. The smallest unit of measurement within the database is Read more…
With the article Query Oracle objects with few EXTENTS, we provide a query to display information about objects with less than 100 EXTENTS. As explained in the article Query EXTENT TABLE Oracle,the EXTENTS of a table have a well-defined number. Once this limit is reached, the following error message is Read more…
With the article Query EXTENT Oracle number and size, we have the opportunity to view many useful pieces of information for managing the extents of a table. The retrieved information includes the table size, extent size, the current number of extents, and the maximum number that extents can reach. As Read more…
With the article “Oracle Table LOB Query,” we provide a query that allows you to see the size of LOBs in a table. In the Oracle database, LOBs are large object objects. LOBs are divided into 2 categories: CLOB and BLOB: CLOB – Character Large Object BLOB – Binary Large Read more…
With the article “LOB Segment Oracle Query,” we provide a query that allows you to see the size of the LOB segment of a table. As explained in the article Query Oracle Table LOB Query, LOBs are large objects that are divided into CLOB and BLOB. These objects can reach enormous Read more…
Dynamic query for generating the compilation command for INVALID Objects With the article “Query for Compiling INVALID Objects,” we have the opportunity to identify invalid objects and perform compilation. In the Oracle database, all tables, partitions, indexes, views, packages, procedures, triggers, etc., are identified as objects. All database objects are Read more…
Query to identify invalid objects: With the article “Query for INVALID Objects,” we have the ability to quickly identify objects that have, for some reason, changed status from VALID to INVALID. If a code change is made on a DDL, it’s possible for the object to become invalid, which can Read more…
Query to identify the 10 largest objects in the Oracle database. With the article Oracle Objects Query, we can quickly identify the objects that occupy the most space. As explained in the article, Query compilazione OGGETTI INVALIDI, the objects in the database include all application structures, such as tables, indexes, etc. Read more…
With the Query article to check if the data access plan has changed – PLAN_HASH_VALUE, we have the ability to identify the SQL_ID, the PLAN_HASH_VALUE, and the usage of machine resources with timing and the number of executions of a specific SQL_ID. Furthermore, if we observe that the PLAN_HASH_VALUE has Read more…
With the article “Query to extract the statement from SQL_ID”, you can extract the running statement from SQL_ID Well, before diving into the article “Query statement from SQL_ID” I would like to introduce this site to you, especially if you’re seeing it for the first time! Scriptdba is the first Read more…