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.…
Author: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
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