Techgoeasy

adopscanlog log analyzer utility in R12.2

How to check logs in adop The adop log files are located on the non-editioned file system (fs_ne), under: s_ne_base/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log For example, if s_ne_base was /u00/app/TECHGO/fs_ne, the session ID was 10, and the <CONTEXT_NAME> was techgo_server, the path to the adop log files from 1th May 2016 would resemble this: /u00/app/TECHGO/fs_ne/EBSapps/log/adop/10/apply_20160501_101121/techgo_server Each cycle of adop …

adopscanlog log analyzer utility in R12.2 Read More »

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 »

Incremental Statistics Gathering

Oracle, Oracle Database

How Incremental statistics works Incremental global statistics work by storing a synopsis for each partition in the table. A synopsis is a statistical metadata for that partition and the columns in the partition. Each synopsis is stored in the SYSAUX tablespace. Global statistics are then generated by aggregating the partition level statistics and the synopses …

Incremental Statistics Gathering Read More »

7 easy and powerful feature of Microsoft excel you may not know about

General

Microsoft Excel is used by almost everybody. Here are some of the cool Excel features that everybody should be aware Excel has a powerful list of functions to solve various problems and tasks. You can use sum, concatenate, average, if. The list goes on 2) Auto Filter This is one of the best functions to use …

7 easy and powerful feature of Microsoft excel you may not know about Read More »

basic unix commands pdf

Unix command and scripts

We have touched upon many unix commands before in the previous article. Here are some more commands with downloadable basic unix commands pdf mv – move files(s) /dirs Options: – -f mv will move the file(s) without prompting even if it is writing over an existing target. -i mv will prompt for confirmation whenever …

basic unix commands pdf Read More »