How to find optimizer and database underscore/hidden parameter in Oracle

Last updated on May 28th, 2019 at 03:45 amThis article is part of Oracle database administration tutorials and has query,explanation and examples on how to find the  underscore/hidden parameters for Optimizer and in general any oracle database underscore parameters Query to list all the underscore parameter with Description set lines 132 column name format a45 column description format a50 select ksppinm name, ksppdesc description from … Continue reading How to find optimizer and database underscore/hidden parameter in Oracle »

Useful Oracle 12c pluggable database commands

Last updated on May 19th, 2019 at 06:06 pmHere are very useful Oracle 12c pluggable database commands Query to check if the database is CDB or non-CDB SELECT NAME, CDB, CON_ID FROM V$DATABASE; NAME CDB CON_ID ————————— ——— ———- CDB01 YES 0 Query to check containers in the CDB database. Each PDB and root is a container SQL> alter session set container=CDB$ROOT; Session altered. SQL> … Continue reading Useful Oracle 12c pluggable database commands »

Oracle password file Utility :ORAPWD

Last updated on May 11th, 2019 at 06:40 amIntroduction to ORAPWD orapwd is a oracle password file utility and it allows the remote connection to the database with administrative privilege i.e. if you want to connect a remote database with sysdba privilege ,then password file need to be present in the remote database You can create a password file using orapwd utility. Users are added … Continue reading Oracle password file Utility :ORAPWD »

41 Useful SSH Putty commands to help you manage the VPS /Dedicated Server

These are 41 Most Useful SSH Putty commands to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on  the server.  I have included command for all major Linux distribution like Cent-OS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS or dedicated server b) Choose SSH … Continue reading 41 Useful SSH Putty commands to help you manage the VPS /Dedicated Server »

31 Useful adop (AD online patching ) command line for R12.2

Last updated on May 31st, 2019 at 03:26 amAD online patching is a new feature in EBS R12.2. We have a different command line then adpatch for that feature. Here in this article,I have given a very common and useful  31 adop command line for R12.2 Get examples about adop adop -examples Get help about command line option for adop adop -help Typical online patching … Continue reading 31 Useful adop (AD online patching ) command line for R12.2 »

Oracle Performance tuning Glossary

Here is the glossary on Oracle Performance tuning. It is quite complex and interesting topics. Oracle performance tuning need through analysis  and knowledge of all the aspect of Oracle database Oracle Parser It performs syntax analysis as well as semantic analysis of SQL statements for execution, expands views referenced in the query into separate query blocks, optimizing it and building (or locating) an executable form of … Continue reading Oracle Performance tuning Glossary »

Top Oracle 12c New Features for developers

Last updated on May 16th, 2019 at 04:37 amOracle has released 12c with lot of new features. Here in this article,I would presenting the top Oracle 12c New Features for developers I have categorized the features in the broad category to make it easier to understand and use SELECT IMPROVEMENTS 1) Top-N feature A Top-N query allows us to retrieve the top or bottom N … Continue reading Top Oracle 12c New Features for developers »

LEAD and LAG : Oracle Analytic Functions

Last updated on May 1st, 2019 at 04:37 pmLead Function LEAD has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER (<analytic_clause>) <expr> is the expression to compute from the leading row. <offset> … Continue reading LEAD and LAG : Oracle Analytic Functions »

RANK, DENSE_RANK and ROW_NUMBER :Oracle Analytic functions

Oracle Analytic functions compute an aggregate value based on a group of rows called window which determines the range of rows used to perform the calculations for the current row. Following are most used Analytic functions. – RANK, DENSE_RANK and ROW_NUMBER – LAG and LEAD – FIRST_VALUE and LAST_VALUE I would be discussing about RANK, DENSE_RANK and ROW_NUMBER analytics functions Here is the general syntax … Continue reading RANK, DENSE_RANK and ROW_NUMBER :Oracle Analytic functions »

How to apply the technology patches to EBS R12.2

We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches  to the R12.2 tech stack. We can apply the same online patching cycle for the below technology patches a. Weblogic … Continue reading How to apply the technology patches to EBS R12.2 »

5 Tests Your Dissertation Must Pass to Be Submitted Finally.

The dissertation is a serious and voluminous scientific work. The list of key requirements for it is very long. And even when you cope with all the questions in the content of the work, it is very easy to get lost in the formatting requirements. So, after you have written everything in your final paper, test it thoroughly. Check once again fit corresponds to all … Continue reading 5 Tests Your Dissertation Must Pass to Be Submitted Finally. »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »