ORA-27154 is a quite a common error which many DBA face in day to day activites.I am trying to share what i have learned to resolve it .We are starting the Oracle database and We receive below error while starting up the database SQL> startup ORA-24323: value not allowed ORA-24323: value not allowed SQL> startup; …
ORA-27154 / ORA-27146 Read More »
What is Nested Loop Join in Oracle -For each row in the first row source access all the rows from the second row source.-The NESTED LOOPS Join is a join operation that selects a row from the selected beginning row source and uses the values of this row source to drive into or select from the …
What is hash Join in Oracle? Hash joins are used when the joining large tables or when the joins requires most of the joined tables rows. This is used for equality joins only Algorithm for Oracle Hash Join 1) The optimizer uses smaller of the 2 tables to build a hash table in memory.Small table …
What is request set in Concurrent Manager? Request set provides the user to submit the same set of requests regularly using a single transaction. User can use the Request Set window to create and edit request sets. Request sets are divided into one or more “stages” which are linked to determine the sequence in which …
Question 1. Which two are valid modes for a process requesting latches? A. Scheduled B. Deferred C. Immediate D. Pre- Emptive E. Willing- to- Wait Solution C, E. Question 2. Which three SQL statements can use the NOLOGGING mode to reduce redo operations? A. UPDATE B. CREATE INDEX C. ALTER INDEX …REBUILD D. Conventional Path …
If condition Unix Shell scripting like other languages have the conditional statement processing also.if condition in unix shell script (Conditional statement) add intelligence to our scripts. This gives us the functionality to perform various command based on various conditions We will be working on if condition in shell script (if/then/else statement) in this post The …
if condition in shell script Read More »
