Putty is a wonderful client to connect to Linux or Unix servers easily. It has the option to connect using both telnet or ssh protocol. It has the option of RAW, serial, RLogin also It is available for Windows 95, 98, XP, Vista, and 7,10 and It can downloaded from the below link Download Putty …
How to use Putty for SSH Read More »
Why Multitenant Architecture introduced with 12c? Many Oracle customers have large numbers of applications built on Oracle RDBMS. They do not use a significant percentage of the hardware on which they are deployed.Customers have instance and storage overhead preventing large numbers of databases from being placed on the same physical and storage server. They are not …
Understand Oracle Database 12c/18c/19c – Multitenant Architecture Read More »
Parallel execution is a important aspect of increasing throughput in oracle database.So often use Parallel execution in Oracle database. In this post, i will touch upon Important Parallel processing data dictionary views and How to monitor parallel queries in oracle database Parallel Processing Data Dictionary views In this section we are trying to give a …
How to monitor parallel queries in oracle database Read More »
What is Unique Key Unique key in Oracle Uniquely identifies every row in the database. It basically enforces uniqueness on the column definedImportant things There can be more than one Unique key per table It can be defined on one or more columns Columns comprising Unique key may be null-able How to create the Unique …
Patches can be downloaded using command line download manager utility such as wget. 1.First we need to check if we have wget installed in the system You can use below command which wget or locate wget 2. Make sure it is compiled with SSL option $ wget –help (Below output shows that wget is compiled …
How to Login to Oracle Cloud Database on port 1521 using SSH tunnel with Linux client $ ssh -i private-key-file -L local-port:target-ip-address:target-port opc@target-ip-address private-key-file is the path to the SSH private key file. local-port is the number of an available port on your Linux system. Specify a port number greater than 1023 and less than …
