SCRIPTS

The last 10 startup times of the database along with timezone in Oracle Sometimes we have to find when the database is started with which timezone especially when the database…

How to Find Sessions in RAC Oracle All in One 5 (3)

How to Find Sessions In RAC Oracle All in One To find sessions in databases will be helpful to evaluate interim growth in sessions,  to tune the database’s performance, to…

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…

How to find Privileges on Directory in Oracle 5 (1)

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…

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…

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…

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 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…

Add datafile into tablespace in Oracle Most of the time due to the application’s DML operation, tablespace crosses their threshold. As everyone knows it’s a critical scenario, if we ignore/skipped…

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

To Check the Object count of a Schema in Oracle Oracle object types are user-defined data types that make it possible to shape real-world entities such as customers and supply…