ORACLE

  Indexes are usually not maintained in Oracle databases. But indexes need to be checked regularly. If an index is created and not checked, it …

  When a sequence is queried, the NEXTVAL value is generated from the seq$ table if it is not cached. If it is cacheed, it …

  Application developers may want to kill long-running queries. However, since application developers do not have ALTER SYSTEM privileges, they cannot execute the kill session …

If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the …

  When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp …

  When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in …

  Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in …

  When a database completely crashes, you need to do is to setup from scratch and return from backup. If you have a Rman backup …

  Exadata installation is done with standard user name and password unless you specify otherwise. All standard passwords must be changed. The standard user name …

  In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …