Home » Oracle » Oracle Database » Page 3

Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

Oracle Exadata: Oracle Exadata architecture, ExaCS, ExaCC

Oracle, Oracle Database

What is Oracle Exadata ? Oracle Exadata Architecture It consists of a Database server, storage server, InfiniBand switches used for intra-system servers to server communication, Administrative Ethernet switch for remote management Oracle Exadata Database Servers or Compute Nodes(1)It is a System that includes all the hardware necessary to run the Oracle Database(2)Database Servers Run Linux …

Oracle Exadata: Oracle Exadata architecture, ExaCS, ExaCC Read More »

How to clean up duplicate objects in SYS/SYSTEM

Oracle, Oracle Database

Sometimes we have different errors in the Oracle system because of duplicate objects in SYS/SYSTEM. This can happen as catalog.sql and catproc.sql were mistakenly run while connected as both users. In most cases, the only objects which should exist are those owned by SYS. The output can help determine which objects should be dropped from the SYSTEM schema. The …

How to clean up duplicate objects in SYS/SYSTEM Read More »

How to check Tablespace in Oracle -Size,Free space,datafiles ,growth

Oracle, Oracle Database, Oracle Sql

How to check tablespace in Oracle To list the names and various other parameters of all tablespace in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”, EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENTFROM DBA_TABLESPACES; With CDB Databases, you need to connect to individual PDB and execute the query to check the tablespace. If you want to …

How to check Tablespace in Oracle -Size,Free space,datafiles ,growth Read More »

How to check Stale statistics in Oracle Database

Oracle, Oracle Database

Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table …

How to check Stale statistics in Oracle Database Read More »

Scroll to Top