In today’s article we will be learning how to Drop Redo Log Group In Oracle. Before dropping a group, note that it is “INACTIVE”. [crayon-6629a1d6027ad878864974/] …

In today’s article, we will be learning how to Delete Redo Log Member in oracle. When deleting a member from a group, we must check …

In today’s article we will be learning how to Move Redo Log File in oracle database. Moving Redo Log files with the database open is …

In today’s article, I will make important explanations about Password File in Oracle. The password file is an optional file. When is the password file …

In today’s article we will be explaining how to do IP Filtering for Application users. If we want application users to come from a single …

In today’s article, we will explain using Grant to authorize the user or roles and Revoke to revoke authorizations. System and Object privileges cannot be …

In today’s article, we will be explaining how to Changing Parameters at Session Level. Only the connected session will change. ALTER SESSION SET command is …

In today’s article we will be explaining how to do Instance Level Parameter Change. This change applies to all user sessions. ALTER SYSTEM SET command …

In today’s article, we will be learning how to customize the name of the trace file to be created for a session. 1. We determine …

In today’s article, we will be learning how to find the trace file of a session. We can do this in 3 different ways. 1. …