In Oracle Cloud, sometimes you add a lot of Block Volumes to a Linux Server. This is especially true for Database Servers running Oracle ASM.…
Expert Oracle Posts
If you are trying to increase your disk partition in the Linux Server and you are getting below error then you are hitting the 2TB…
Leave a CommentThe “ORA-30036: unable to extend segment by 8 in undo tablespace” error message in Oracle databases indicates that the undo tablespace has run out of…
Leave a CommentIn Oracle Database, an invisible index is a type of index that is not used by the optimizer by default but can still be used…
Leave a CommentTo fetch the DDL of a table: SELECT DBMS_METADATA.GET_DDL(‘TABLE’, ‘table_name’) FROM DUAL; To fetch the DDL of a view: SELECT DBMS_METADATA.GET_DDL(‘VIEW’, ‘view_name’) FROM DUAL; To…
2 CommentsMost Oracle DBA & Oracle Apps DBAs are already aware that the technology world is moving fast and that is a fact that no one…
Leave a CommentThe parallel hint in Oracle Database is used to specify that a particular query or operation should be executed in parallel mode, using multiple parallel…
1 CommentThe below script can be utilized to find if any UNIX process has a database session linked to it and if yes, provide all the…
Leave a CommentWhat is Oracle Cloud Infrastructure (OCI) Monitoring service and why is it important? OCI Monitoring is a service that enables you to monitor your cloud…
Leave a CommentHere are a few scripts that can help you find the number of executions of a specific SQL_ID in an Oracle database: Scripts based on…
Leave a Comment