18 Nov
by dbtut
You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from the command line. First, the adump directory needs to be created. You can create a directory on all nodes as follows. [crayon-5bf194d1f2008411414181/] With DBCA, you can create your rac database […]
18 Nov
by dbtut
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 […]
16 Nov
by dbtut
If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on explain” before running the query. [crayon-5bf194d1f26e0227964058/]
15 Nov
by dbtut
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
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
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
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.
11 Nov
by dbtut
You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-5bf194d1f30fd314321127/] If your Oracle database is not RAC, you can use the following query. [crayon-5bf194d1f3105779558091/] Especially when you examine the TOP SQLs, you can instantly catch the PROCESS ID over the operating […]
6 Nov
by dbtut
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, mviews
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 […]
