|
||||
|
DBA’s often kill the blocking sessions and from 19c (not sure which patch set) we have new parameter called MAX_IDLE_BLOCKER_TIME parameter which helps to specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. A session is considered to be a blocking […] How many you know this structure at first glance, I am sure the old DBA junkies will say what this called immediately, but for those who does not know this diagram is called Network OSI diagram for Oracle and layers between client and database servers and how oracle connects. Oracle uses different methods […] Going through the documentation and found the following were deprecated which we have may used in our environments. The following tns parameters have been deprecated, When you process a query that involves a connected database link, the server acts as a client to the target database of the database link. For example, suppose you have […] Often, when the global temporary tables are in use in batch processing, we have lot of problems regarding plan stability. For example A session inserting 1 row in a global temporary table based on some other table joins Another session which were apparently doing the same insert but will try to insert 1000 rows […] Previous to 12c, when you want to perform an monitoring the Session you will have to turn the trace etc or trace with application/module/program/sql_id etc. But, what if you want to monitor specific operation for that session not whole or application. Kind of set of operations you want to peform not all with in that […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!