EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that the apps is […]
How to generate tkprof in EBS in 19c Read More »
Here in this post, I would be giving the basics on the RSYNC command and how to use it effectively to sync the directories/code Introduction I have to sync up the two directories many times on Unix boxes. The simple steps would be to delete the directory from the destination and take a backup of
RSYNC command – sync the data between two directories Read More »
sed command is a powerful Linux command and it is useful in many cases while dealing with data, and inputs in the Unix operating system. In this post, we will be looking at the sed command in the Unix example, the sed replace command, how to delete with sed command and other few cases. Introduction
Histograms are generated in Oracle by using the method_opt parameter in the dbms_stats procedure method_opt syntax FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause] FOR COLUMNS [column_clause] [size_clause] size_clause is defined as size_clause := SIZE {integer | REPEAT | AUTO | SKEWONLY} column_clause is defined as column_clause := column_name | extension name | extension – integer :
How are the histograms generated in Oracle Read More »
In this post, we will discuss, what is a restore point in Oracle, how to check a restore point in Oracle What is a Restore Point in Oracle? Guaranteed restore points Normal Restore Points How to check the restore point in Oracle You can check the restore point in the Oracle database using the below
How to check the restore point in Oracle Read More »
The concept of a “Recycle Bin” plays a crucial role in data recovery and management. This feature, introduced in Oracle 10g, is akin to the recycle bin in Windows or the trash in macOS, providing a safety net for data that has been deleted. In this article, we will discuss the recycle bin in Oracle,
How to check recycle bin in Oracle: Purge, enable/disable Read More »
