This page will showing how to check out the last login details into oracle database there are several view like SYS.AUD$ , SYS.AUDIT_ACTIONS with the help of that you can easily find out the last login session information. And also you can use the dba_audit_session view to check out the logon and logoff time of … Read more
How to EXPDP and IMPDP from Higher version to Lower version in oracle database. In this Blog I have explain how to take export from one database which have the higher version 12c and import it in other database server where we are using lower version 11g. Some time we need this type of scenario … Read more
Take a logical backup of your main production server We can perform the export and import from higher version to lower version in oracle database. Oracle gives VERSION parameter which you can specify during the export and you can pass the lower version of database where you want to do import. Like if your source … Read more
Its very helpful for everyone to understand the RAC ADMINISTRATION COMMANDS in Oracle database. RAC stands for Real Application Cluster which help to manage the high availability of database in case of any disaster. There are some useful command which are using in daily routine to stop and start the services of RAC. Oracle Real … Read more
This page will help to everyone to Get metadata DDL details about any schema objects which include the (tables,packages,db_link)etc. DBMS_METADATA The DBMS_METADATA package provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object. Object Types are: TABLE DB_LINK TABLESPACE … Read more
This blog will help you to find out the user password expiration and changed details in brief. You can check out the when the user password is going to expire or need to change before expiration. You can find details about users which are created in Oracle. By running a query from a command prompt, … Read more
To Check Failed login attempts count in oracle database for security purpose. It helps you to identify the username and what action has been performed by it. There are some other details which you can check from DBA_AUDIT_SESSION view. To find invalid logins by users who has return error code=1017 in oracle database you can fire the … Read more
In this blog I am going to showing to everyone how we can easily check the whole database size in oracle using simple SQL queries there are different ways to calculates the database size and showing to user what is the exact size of db’s. In the first ways you can check the database size … Read more