Find Last Analyzed date on Tables, Partitions, and Subpartitions in Oracle Here we are going to demonstrate how to find the last analyzed date on tables in Oracle. Some time due to performance issues, statistics locked on the table, disable statistics in the database, before/after manual analyze on tables or gather statistics, before/after migration, etc.
Step by Step manually creation of an Oracle 19c Database on Linux 7 In the previous article, we have demonstrated Step by step silent installation of oracle 19c on Linux 7, now here we are going to create Oracle 19c standalone database. We can create an Oracle database by using the below methods. 1. DBCA(GUI) 2.
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 is getting rebooted unknowingly in Oracle. The below query gives the output of the last 10 start times of the database along with the timezone
Step by step silent installation of Oracle 19c on Linux 7 As everyone is aware of the oracle database installation. oracle database installation can be done through 2 methods. Here we are going to illustrate step by step how to install the Oracle 19c database using silent installation. Below are the steps which we followed
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
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
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
Step by Step installation of Oracle Client As most of us already know oracle client is installed on the application server to execute SQL command or compile script related to the application. Below is the step by step installation of Oracle client on UNIX. Step1: Created users and group Below we are creating groups and
Step By Step Table Shrinking and Data File Resize in Oracle Due to less budget sometimes the client asks to shrink the mount point space where our datafiles exist and if developers said that the table size is getting high and due to that our database size is increasing so, in both scenarios we can
Demonstration on how to increase processes, sessions, and transactions parameters in Oracle. Whenever DB processes are utilized 100% then it’s NOT allowed any new sessions/connections to DB’s instances and we get the below error:ORA-00020: No more process state objects availableORA-20 errors will not be written to the alert log forthe ORA-20 errors. Cause: All process state
