XTIVIA, Inc.’s Post

OK well, but if we want to use "NID" command for it? How to change Oracle Database Name Using “NID” Command? https://lnkd.in/dWnsjtJQ

Oracle 19c : Backup & Recovery 1)     We cannot manage the flashback logs in FRA directly other than by using flashback retention target or using guaranteed restore point. From Oracle 19c onwards, flashback logs which are older as compare to retention period are automatically deleted. To use this feature, COMPATIBLE should be set to 19.0.0 or higher. 2)     From 19c, we can connect to recovery catalog when the target database is PDB ( Pluggable database) 3)     From 19c onwards, Data recovery advisor (DRA) feature is depreciated, including few Oracle RMAN commands : List failure, Advise failure, Repaid Failure and Change Failure. Data Recovery Advisor is a tool which helps reduce database recovery time by determining best available repair option for database failure. #Oracle #19c #backup #recovery

How to purge audit trail records from audit table sys.aud$ in Oracle database 12c ? Purging audit trail records from the SYS.AUD$ table in Oracle Database 12c is an essential maintenance task for database administrators. The SYS.AUD$ table stores all audit trail records, including login attempts, executed #SQL statements, and other user activities within the database. Over time, this table can grow significantly, potentially impacting database performance and storage. Read more: https://zurl.co/MAKq #database #oracle #admin #data #ssquaresystems #ssquare

Looking for a reliable platform to compare the features of Oracle Database 23ai and 19c, and even version back to 11.2? Look no further than the "Features and Licensing Application". This platform is written in APEX and allows you to easily compare and contrast the features of different versions of Oracle Database. Check it out here: https://lnkd.in/d4SuNna6 #Oracle #Database #APEX #licensing Dominic Giles

Oracle 23c introducing a new feature "Lock free Reservations" that can be used on frequently updated columns. I am very excited about this feature, and waiting to use it. I still did not work with 23c, so I did not have a first hand experience yet. Below are two links that explains how "Reservable" columns work. I am wondering how this reservations work on columns where we need to decrease the value of that column (for example: Quantity on hand) especially when there is a business rule such as Quantity on hand cannot be a negative number and the transactions may resulting a negative value (because of the transaction application happens at the time of committing the record). What error Oracle throws and what happens to the updates that have already been applied for the other columns (I assume it is rolling back the changes with an error) Below are two links that explain how "reservable" columns work in action, and considerations/limitations on what operations can be done on those columns. Thanks to Connor McDonald, and Tim Hall for taking time to explain the feature. https://lnkd.in/gEF7BDn6 https://lnkd.in/gv6hfmxh.

Today, I was asked to provide all the patches applied on the Oracle databases for a specific customer for audit purposes and, I used #OEMCC as my best friend to provide this information. Here is the query and I added one sample output with part of the information. col target_name form a65 col host_name form a40 col home_name form a20 col home_location form a60 col patch_id form a20 col patch_upi form a20 col install_time form a32 col opatch_version form a15  select    target_name   , host_name   , home_name   , home_location   , patch_id   , patch_upi   , patch_lang   , install_time   --, BUGS_FIXED   , installer_version opatch_version from sysman.MGMT$OH_PATCH where lower(home_name) not like '%agent%' order by 2,1; https://lnkd.in/ekgGxM7a #kyndryl #heartofprogress #oracle #dbalife

TLS and Wallet Enhancements in Oracle Database 23c https://lnkd.in/ec-t3TX3 @OracleDatabase #oracle #database #23c

Ever wondered how the transition from Oracle 12c to 19c can streamline database management? 🚀 Recently, I navigated this upgrade, enhancing database performance and security. Here's what I learned: Planning is Key: Detailed assessment and planning ensured a smooth transition. Backup is Non-Negotiable: Utilizing Rman for thorough backups saved us from potential data loss. Testing is Essential: Rigorous testing post-upgrade revealed critical adjustments needed for optimization. This journey underscored the importance of adaptation in the ever-evolving field of database management. Have you experienced similar transitions? Share your stories below! #OracleDBA #DatabaseManagement #TechInsights

#Database monitoring scripts to enhance the performance and ensure smooth operations

Experiencing delays in your Oracle database? It might be due to the Log File Switch (Checkpoint Incomplete) Waits Event. Learn how to identify and address this issue to optimize database performance. Stay ahead with #OraclePerformance #LogFileSwitch #DatabaseManagement #OracleTips