What is FND_OAM_CONTEXT_FILES used for? Context Files are also stored in the database.. The table that store the context files( historically) is “FND_OAM_CONTEXT_FILES” Context files in this table is stored in a huge clob column named TEXT.. In TEXT column the context file is stored as is, that is in xml format So by quering …
What is FND_OAM_CONTEXT_FILES used for? All about it Read More »
Very Useful Oracle ASM queries for day to day activities for Oracle database administrator HOW TO CLEAR ASM DISKS The below dd command can be used to zero the disk dd if=/dev/zero of= path of the disk bs= block size count=10000 QUERY TO FIND THE FILES IN USE BY AN ASM INSTANCE col full_path format a50 col …
15 Awesome Oracle ASM Queries every DBA must know Read More »
What is Local NVMe Storage NVMe stands for non-volatile memory express. It is a storage protocol created to fasten the transfer of data between enterprise and client systems and solid-state drives (SSDs) over a computer’s high-speed Peripheral Component Interconnect Express bus Local NVMe is NVMe SSD-based temporary storage. It is the locally-attached NVMe devices to the OCI compute instance It is used …
Oracle cloud storage : Local NVMe & Block Volume Read More »
Today in this post, I will explain how to rebuild the oracle tables or move the different types of oracle tables using the “alter table move” command. we may want to rebuild the table for various reasons like fragmentation removal, moving to a different tablespace, etc. General Steps for rebuilding the Oracle table is Rebuild …
How to rebuild the table in oracle using alter table move Read More »
We often get confused between CPU vs Core Vs Socket and How to find that in Windows. Here is my attempt at explaining those terms and how we can find them in Windows Physical CPU It is the physical Processor on the server. Each CPU is assigned to one socket Core Each Physical CPU consist …
In this post, we will discuss the Difference between v$system_parameter and v$parameter and other parameter view available in Oracle database. Lets first start with the definition of each of them V$PARAMETERIt displays the information about initialization parameters that are currently in effect for the session. V$SYSTEM_PARAMETERis the view which shows instance level parameters (and these are …
Difference between v$system_parameter and v$parameter Read More »
