Database Blog

Steps to scp file from one server to another server in oracle cloud

INTRODUCTION: The below steps shows us how to enable the scp for file transfers in oracle cloud. Open the puttygen Import the target server ppk file It will ask for the target server ppk file we are going to scp Select the file and click open The ssh keys will be generated. Select the Export OpenSSH Key Save the File with ssh extension move the file to source server in /etc/ssh folder Now we are able to move the pfile to target server.

Read More

Moving Table from one tablespace to another tablespace

    The alter table  move command moves rows down into un-used space and adjusts the HWM but does not adjust the segments extents, and the table size remains the same. …

Read More

RMAN – Backup Based Clone

RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server…

Read More

Recycle Bin in Oracle

  Oracle database has the recycle bin which is a data dictionary table and contains information about dropped objects.  Until we don’t use the purge option, all dropped tables and…

Read More

Useful TFACTL Commands

1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl:…

Read More

PDB Lockdown Profiles In Oracle 12.2

ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create a…

Read More

SGA TARGET ADVISORY IN ORACLE

The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for  SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…

Read More

Query To Find Dependent Objects Of An Invalid Object

SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘<INVALID_OBJECT_NAME>’);

Read More

Query to Check locks on a table

Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;

Read More

Support date for Oracle WebLogic Server versions

The following table provides the date each version was released and its end of Grace Period. These are dependent on a Patch Set released in order for the Grace Period…

Read More