How to Kill My Own SQLPLUS Session

Here I am giving you tip to kill your own sqlplus session connected to the oracle database.

How to Check When was the Table Insert, Update, Delete Done on Oracle Tables or Partitions

This is done with the help of the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO package. This package flushes in-memory monitoring information for all the tables to the dictionary.

SQL Query to Check Last Modified Time for an Oracle Object

select        to_char(last_ddl_time,'DD-MON-YYYY HH24:MI:SS')
from         dba_objects
where       owner='&user'

How Check Hardware type In Linux / Unix

uname -M  /   prtconf

cat /sys/devices/virtual/dmi/id/*

ORA-01103: database name 'TEST' in control file is not 'CDB'

Problem Description:
Alter database mount failed with following error after the dbname change using DBNEWID – NID utility.
SQL> startup mount

DBNEWID – NID Utility – Change DBNAME and DBID

Using this command line utility we can make following 3 changes to the oracle database.

   1.  Only the DBID of a database

Flush SQLID or SQL Statement, Object from Shared Pool - DBMS_SHARED_POOL.PURGE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NAME                           VARCHAR2                IN
FLAG                           CHAR                    IN     DEFAULT
HEAPS                          NUMBER                  IN     DEFAULT

How to Delete Table, Index, Schema Statistics?

Here are the commands to delete the statistics.
       EXEC dbms_stats.delete_table_stats('<TALE OWNER>', '<TABLE NAME>');

EXEC dbms_stats.delete_table_stats(OWNNAME=>'<TALE OWNER>', TABNAME=>'<TABLE NAME>');

DataPump EXPDP Estimate [ BLOCKS | STATISTICS ]Option

This parameter is used to estimate the amount of disk space used by each table in the export. This would be an approximate value. There are two options for this parameter.

How to Check User Quota on Oracle Tablespace-DBA_TS_QUOTAS

The base dictionary view is DBA_TS_QUOTAS to fetch the specific tablespace user quota details. 
MAX_BYTES column value -1 means unlimited quota for the user for the particular tablespace.

DataPump Expdp KEEP_MASTER Option

Master Table:- Master table is the key table for the data pump jobs. It keep track of the respective datapump jobs. The table name is same as the job name of the export or import job.

Oracle 12c 18c 19c: How to find out the Listener.log file location?

In latest versions of Oracle the listener.log file placed under the ADR_BASE/diag folder.
cd $ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/alert

DataPump Expdp ORA-39071: Value for EXCLUDE is badly formed

Problem Description:
Datapump export command failed with following error.


This parameter determines the algorithm to compress the dump file data.

DataPump Expdp ABORT_STEP Option

ABORT_STEP is the option with the DataPump export utility (expdp) to stop the job after the initialization. This is available from

Answers Amazon Daily Quiz today 20 September 2019

Tags:- Amazon quiz of the day, Amazon todays quiz, Amazon Quiz 20 September, Amazon Quiz 20th September, Amazon 20 September Quiz Answers,

Answers Amazon Daily Quiz today 19 September 2019

How to Play the Quiz:
Step 1:- Install the amazon app from the play store or apple store
Step 2:- Open the app and tap search bar and type for contest or quiz time

Oracle CDB PDB: ORA-65096: invalid common user or role name; Create user Command failed

Problem Description:

SQL> create user "mytest" identified by mytest;
create user "mytest" identified by mytest
ERROR at line 1:
ORA-65096: invalid common user or role name

Oracle SQL Query/Script: Find out Current Running Active, Inactive Sessions Connected to the Database.

This is the one of the most useful query which is used by the DBAs on daily basis. Here I have provided multiple queries which can be used for finding out Active,

Answers Amazon Daily Quiz today 18 September 2019

Tags:- Amazon quiz of the day, Amazon todays quiz, Amazon Quiz 18 September, Amazon Quiz 18th September, Amazon 18 September Quiz Answers,

Answers Amazon Daily Quiz: 17 Sep 2019 Win Hidesign women’s handbag

Q1:- Which is the smallest state in India in terms of area?
Ans:- Goa

How to Remove / Delete / Drop a Machine from Oracle VM Virtual Box?

Step 1.
Stop /power off the running VM by right clicking the running virtual Machine.

Answers Amazon Emi Quiz: Win Rs.20000 Amazon Pay Balance September-2019

Q1:- ‘No Cost EMI’ Is An EMI Offer In Which You Pay Just The Product Price, Equally Divided Over Monthly Installments. Using Which Of These Payment Method You Can NOT Avail ‘No Cost EMI’ During The Great Indian Festival Sale?

Answers Amazon APP ONLY Bose Quiz – Win Bose Frames -September 2019

Q1: Bose Recently Launched ‘Bose Frames’ Also Known As ‘Sunglasses With A Soundtrack’ Because These Sunglasses Come With ______. Fill In The Blanks.

iPhone - How to Call Non-emergency Number from Locked iPhone Without Knowing Password?

I hope this would be an interesting feature to know. Suppose you lost your iPhone and somebody might have found it or in some emergency your friends or colleagues wanted to contact your family member, Copyright 2011-19 All Rights Reserved | Site Map | Contact | Disclaimer | Google