Here in this article, we will check how to check datafiles in the Oracle database, data file size How to check datafiles in Oracle select file_name, bytes/1024/1024 from dba_data_files ; With CDB Databases, you need to connect to individual PDB and execute the query to check the tablespace. If you want to gather all the […]
How to Drop the index in Oracle
You can drop an index in oracle using the DROP INDEX command. It removes the named index. The general Syntax is drop index <schema name>.<index name> ; Here schema name is the owner of the index and index name is the index name. If you don’t provide the schema name, then it is assumed the […]
How to delete the manage server in R12.2
I was working on the R12.2 Test env and I was supposed to decrease the JVM for the oacore(delete the managed server) The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms, and forms-c4ws services were deployed as applications on OC4J instances and […]
How to check Tablespace in Oracle -Size,Free space,datafiles ,growth
Here in this article, we will check how to check tablespace in Oracle database, tablespace free space, tablespace growth information, tablespace size, associated datafiles with tablespace, checking highest allocated extent in the tablespace how to check tablespace in oracle To list the names and various other of all tablespace in a database, use the following […]
How to delete a row in oracle
This SQL tutorial provides explanations, examples for Delete from the table in Oracle Delete from table is used in Oracle Sql to delete the rows in the table. It is a DML (Data Manipulation Language) statement. It is used to delete the subset of existing rows or all existing rows from the table. Here is […]
Supplemental Logging in Oracle
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 […]
