SQL Macros was initially introduced in 19C and have been continuing its way to new releases of Oracle and gaining some attention. They are coming for great usage for analysis and easy data transformation especially for Data Analyst/Developers.Macros are way for encapsulation of complicated logic within the SQL. The “macro” can then be used within …
RMAN or Recovery Manager is database client which is used for tasks related to backup, restore and recovery. It can automate backup strategies as per requirements. Basic RMAN commands We can check the current configuration using “show all” command after connecting to RMAN. Whatever is the default configuration of the parameter will have “# default” …
Issue: When trying to login via SQLPLUS, getting ORA-09925 ERROR:ORA-09925: Unable to create audit trail fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 9925ORA-01075: you are currently logged on Cause of Error: Error message indicates that either Oracle is not able to find audit directory or it is not able to write/create file there.It …
Situation: We need to delete the files older than 30 days To delete the files in directory older than certain number of days (30 in this case) we can use find command in combination with rm. To delete files having certain pattern (*txt in this case) in the name we can use below: As precautionary …
Oracle is known for its tuning, reliability, and robustness. But unlike any complex setup, it can face blocking session issue which directly impacts on its performance for SQL statements. Blocking session occurs when one session holds the resources which are requested by another session. Another session has no option other than to wait for the …
Ahoy, fellow data explorers! Welcome to a realm where Oracle Database takes center stage, showcasing a variety of editions like characters in an epic saga. Just like choosing the right tool for a specific task, selecting the perfect Oracle Database edition is key to a successful data-driven adventure. So, gather ’round as we unravel the …
Oracle Database Editions: Choosing the Right Fit Read More »
Welcome to the Database world, the backend of everything. Today, we have software solutions, websites, bots etc. Performance and accuracy of everything is dependent on the data which must be stored somewhere. This is where Database has been showing the magic for decades. In this short guide we will be informing you the basics of …
