Analytic functions in oracle

Last updated on May 19th, 2019 at 06:01 pmThis post is part of SQL tutorial and we would be discussing Analytic functions in oracle with examples, detailed explanation . We have already studied about Aggregate function like avg ,sum ,count. Lets take an example select count(*) from EMP; select sum (bytes) from dba_segments where tablespace_name=’TOOLS’; select deptno ,count(*) from emp group by deptno; SQL> desc … Continue reading Analytic functions in oracle »

How to login to Linux with SSH private key from window client

Last updated on May 19th, 2019 at 06:03 pmIn the previous we learn about how to generate ssh key pair from puttygen. Now we can use that ssh key pair to login to Linux with the putty client First we need to make sure ,the public keys is the copied to the Linux box user $home/.ssh/authorized_keys. If you are doing this for cloud instance, cloud … Continue reading How to login to Linux with SSH private key from window client »

How to generate ssh key pair on Unix using ssh-keygen

Last updated on May 19th, 2019 at 06:05 pmWe can generate ssh key pair on Unix using ssh-keygen utility. This comes under openssh in all Unix flavour Run the ssh-keygen ssh-keygen -b 2048 -t rsa rsa : it is the algorithm for generating the public -private key pair 2048 : it is bit size ssh-keygen -b 2048 -t rsa Generating public/private rsa key pair. Enter file in … Continue reading How to generate ssh key pair on Unix using ssh-keygen »

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

Get examples about adop adop -examples Get help about command line option for adop adop -help Typical online patching cycle: source <ebs_root>/EBSapps.env run adop phase=prepare adop phase=apply patches=123456 adop phase=finalize adop phase=cutover source <ebs_root>/EBSapps.env run adop phase=cleanup Run prepare phase adop phase=prepare Run apply phase adop phase=apply patches=12797970 Run Finalize phase adop phase=finalize Run Cutover phase adop phase=cutover Run Cleanup phase adop phase=cleanup Run fs_clone … 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 »