Below section I have tried to present all the important features in Oracle Database management
Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on …
How to delete the archive logs in Oracle Read More »
Types of Corruption in Oracle There are two types of corruption. a. Physical corruption: This happens generally due to media corruption. In this case, the block does have an invalid checksum. It may contain zero. This is generally the result of infrastructure issues like media, network, and memory. RMAN block recovery can be used to …
How to check block corruption in Oracle database and Fix it Read More »
We already know about standby databases i.e. dataguard. Here we will learn about snapshot standby database in Oracle What is the snapshot standby database in Oracle? With 11gR, we can convert the physical standby database into a read-write database for some time and later again convert it back into physical standby mode using the snapshot …
A schema in Oracle consists of tables, index, Log segments, Lob Index, table partition and index partition. The schema size in Oracle depends on the size of all these objects. Let’s check how to find the size of the schema in Oracle How to find the segment_type for a particular schema select segment_type,count(*) from dba_segments …
We all know Google Translate which can help translate from one language to another. We will explore the option to use Google functionality in Oracle plsql in the Oracle database to get the translation done. BEGINDBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => ‘google_translatorapi.xml’,description => ‘Google Translator Access’,principal => ‘SCOTT’,is_grant => true,privilege => ‘connect’);DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => ‘google_translatorapi.xml’,principal => ‘SCOTT’,is_grant => true,privilege => …
Oracle 23c is the latest Release of Oracle Database. Oracle has introduced lot of new features in it. Here are the Top Features Developer-Friendly Features Oracle has been adding features to make developers’ lives easier, such as SQL and PL/SQL enhancements, JSON improvements, REST interfaces, etc. SELECT without FROM clause You can now run SELECT …
Oracle 23c Database New Features Read More »
