Oracle Autonomous Database An autonomous database is a cloud database that uses ML to automate database optimization, security, backup, updates, and other routine administrative tasks traditionally performed by database administrators. Unlike traditional databases, autonomous databases perform all of these tasks but do not require human intervention. user can define backup buckets and staging buckets (storage), …
What is Oracle Autonomous Database Read More »
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 »
A schema in Oracle consists of tables, index, Log segments, Lob Index, table partition and index partition. The schema size in Oracle depends on the size of all these objects. Let’s check how to find the size of the schema in Oracle How to find the size of schema in Oracle The below query will …
We will be discussing Oracle indexes, types of indexes in oracle with example, and how to create index in oracle in this post. I will through light on all the options on how to create an index in oracle. I hope you will like this post. I will be looking forward to feedback on this …
Oracle Indexes and types of indexes in oracle with example Read More »
About Java keytool command Let’s see various useful Keytool Command How to generate the Public/Private key pair using Keytool cd $JAVA_TOP\jre\bin keytool -genkeypair -keyalg RSA -alias <key alias> -keysize 2048 -keystore <jks location> -storepass <store password> -keypass <key password> -genkeypair command is used to generate a key pair: UserA’s private key and UserA’s public key.-keyalg …
Most Useful keytool command for Linux And Windows Read More »
Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on …
How to delete the archive logs in Oracle Read More »
