Why Local Undo is required We have global or shared undo for the entire CDB till 12c R1. With shared undo, before performing operations such as (cold) clone or unplug, it is necessary for the database to check for any uncommitted transactions in the source PDB. This is to avoid problems with transactional consistency in …
Local Undo in Oracle Database 12c R2(12.2)/19c and above Read More »
In this post, we will see the Script to check locks in oracle database, how to check locks in oracle, how to check lock on table in oracle Locks is a process in the Oracle database through which it maintains consistency and concurrency. So they keep coming and going. We generally don’t need to worry …
The telnet client is used to connect to the MWA server in EBS. Windows has telnet installed by default but it is often disabled. If you use Start > Run > telnet and the program is not found, then telnet is disabled. In this post, we will check how we can enable it How to …
We can change the column datatype in a table using alter table modify column in oracle ALTER TABLE table_name MODIFY column_name <action>; Action can be many things like(a) change the data type(b) Shorten or widen the data type(c) Change the default value(d) Change to allow null or not nulls(e) Column Visibility(d) Virtual Column ModificationLet’s start …
What is Supplemental Logging in Oracle Oracle Redo log file has the record of all the operations performed in the database by default or automatically. So Redo log files are generally used for instance recovery and media recovery. They are also used for Physical standby or physical replication. But by default Oracle redo logs files …
This Find command article is part of Linux tutorials and it has detailed explanations, examples Find command in Unix is an extremely useful command. you can search for any file anywhere using this command provided that file and directory you are searching has read-write attributes set to you, your, group, or all. Find descends directory …
