Category: ORACLE

18 Nov by dbtut

“Not enough database memory” On GoldenGate

  If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of 400. PROCESS ABENDING. Solution: Set the parameters for streams_pool_size and shared_pool_size. streams_pool_size must be greater than the size specified in the error (400 in the example above). Then restart the […]
15 Nov by dbtut

Who is Running the Queries in Your Database On Oracle

  You can find the queries that are run in the database from v$sql, v$sql_text views, and who are running from sys.all_users. You can create queries by associating v$sql, v$sql_text views and sys.all_users. The sample query is as follows. [crayon-5bf194d1f28a5660627358/]
14 Nov by dbtut

Oracle 12c IDENTITY Columns & Default SEQUENCES

  I will try to explain the identity feature, which is my favorite innovation in Oracle 12c. MS SQL and MYSQL users know the Identitiy feature. It is now also available in Oracle databases. We used SEQUENCE when this feature wasn’t available. While adding records to the table, we would take the new value of […]
13 Nov by dbtut

Step By Step Oracle Apex Installation

  I tried to explain the apex installation step by step. Ensure that the Oracle Text component is also installed before you begin the installation. APEX needs this component. First, tablespaces are created: [crayon-5bf194d1f2ca6980681276/]   Then, creating the APEX_IMAGES virtual directory. If the database is RAC, the physical directory is being created on all servers. […]
12 Nov by dbtut

How To Enable Archive Log Mode In Oracle RAC Database

Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac database by following the steps below. [crayon-5bf194d1f2f14941615329/] As above, Automatic archival Enabled means everything is OK.
6 Nov by dbtut

DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports

The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the following script to examine the related AWRs in more detail.   [crayon-5bf194d1f32eb692606016/] This script was tested in 11gR1 and 11gR2. Please test the scripts on your test servers before running […]
30 Oct by Avinav Chadha Tags: ,

Materialized Views in Oracle Database

A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. Collectively these objects are called master tables (a replication term) or detail tables (a data warehousing term). This reference uses “master tables” for consistency. The databases containing […]