I am presenting here some of the good queries on timezone settings How to check the timezone version in the oracle database/how to check the…
I have worked on Oracle Apps Version 11i, R12.0, R12.1, and R12.2. Each of these has a fixed location for log files.Apps DBA is supposed to…
Triggers are an important construct in oracle. These are the codes that are fired when a row is updated, inserted, or deleted in the oracle…
High water mark in oracle is a term used in oracle table to show the blocks which have been ever used in the life cycle of the…
This article contains the Top 49 Oracle Interview questions and answers: Basics, Oracle SQL asked in various interviews. I hope it should help in interviews Question 1. What…
We will be discussing WebLogic Node manager and managed server start/stop in this article. How to stop/start Node Manager in Weblogic The Node Manager is…
Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform…
ORA-00257 is one of the commonest errors in Oracle DBA life. He/She often has to deal with it. Oracle Database almost got frozen because of it and all transactions…
We will be posting information on User access and security in the oracle database. This post will give good information on Create User in Oracle,…
We often come across the error ORA-28002 the password will expire in day-to-day activities. This can happen with developers and DBA both. ORA-28002: the password will expire…