0 Comments

Solution for Error ORA-29289 Directory Access Denied in Oracle 5 (1)

Error ORA-29289 Directory Access Denied in Oracle Sometimes application users have DIRECTORY details like name of DIRECTORY of a database but not having proper privileges (READ, WRITE) on DIRECTORY and received error “ORA-29289″ directory access denied”. Thanks to one of my application users who did the same mistake yesterday and encourage to me elaborate here […]

 535 total views,  1 views today

0 Comments

How to find Privileges on Directory in Oracle 0 (0)

Find Privileges on Directory in Oracle Oracle has introduced the concept of DIRECTORY which is a type of object and introduced in Oracle version 8.0. DIRECTORY is a logical structure that presents a physical directory on the database server’s file system.DIRECTORY  can be used in DATAPUMP, PL/SQL block, UTL_FILE packages, etc In Oracle. Below is […]

 164 total views,  2 views today

4 Comments

ADD-DROP Redo log files in Oracle Database 5 (4)

ADD-DROP Redo Log Files In Oracle Database In the real world, we may encounter scenarios where we need to or asked to increase/decrease the size of redo log files as log switches creating contentions at the database. For example, by increasing the redo log file size, the number of log switches can be decreased which […]

 725 total views,  5 views today

0 Comments

Starting and stopping an Oracle ASM instance for Noncluster Databases 0 (0)

Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called Oracle Instance.  The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and   background processes. […]

 400 total views,  1 views today

0 Comments

How to find table’s statistics are LOCKED or UNLOCKED in Oracle 5 (1)

Find table’s statistics are LOCKED or UNLOCKED in Oracle Table’s statistics is a key role in terms of performance along with the execution plan of SQL’s statements. Here we demonstrate how to find the table’s statistics are LOCKED or UNLOCKED in Oracle. Some time due to performance issues or on-demand business impact or auto enable […]

 155 total views

4 Comments

How to Find Last Successful Login Date in Oracle 5 (1)

Find Last Successful Login Date in Oracle Oracle12c new features To find the last successful login date in oracle is now easy to retrieve from supporting version 12c onwards i.e this is a new feature of Oracle 12c. The question comes to mind why we require the user’s last successful login date, it may be […]

 292 total views,  1 views today

0 Comments

How to add datafile into tablespace 5 (1)

Add datafile into tablespace Most of the time due to applications DML operation, tablespace crosses their threshold. As everyone knows it’s a critical scenario, if we ignore/skipped adding space into tablespace it may cause the application at a hung state or the database to a hung or down. To avoid this cause below is the […]

 95 total views,  1 views today

Spread the love

0 Comments

Schema Refresh Using EXPDP-IMPDP command 5 (2)

Step by Step guide for Schema Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a schema refresh activity using Datapump: PARAMETERS SOURCE TARGET DATABASE […]

 1,012 total views,  2 views today

0 Comments

How to check object count in a schema 5 (1)

To Check the Object count in a Schema   Oracle object types are user-defined data types that make it possible to shape real-world entities such as customers and supply orders as objects in the database.Underneath the object layer, data is stored in a tabular format, that is in rows and columns but we can work […]

 279 total views,  1 views today

0 Comments

Connected Sessions along with Network Authentication in Oracle 5 (2)

To check Connected Sessions along with Network Authentication in Oracle Here we are going to share SQL code to check connected sessions along with network authentications which show additionally network-related stuff like client connections, client version, client driver, network service banner, etc. In day-by-day usage as a DBA, we have to validate connected sessions, network-related […]

 341 total views,  1 views today