Welcome to alphageek369

Be persistent in what you do !

D

Latest from the Blog

WHEN DO WE USE GV$SESSION_LONPOPS?

DBA’s confuse to use longops view for long running operations due to misunderstanding. This view cannot be used to monitor all long running operations but only for large resource intensive operations. There are two main criteria for the records Scenarios during which oracle consider things as long running sessions x$ksulop is the internal table which … Continue reading “WHEN DO WE USE GV$SESSION_LONPOPS?”

HOW TO GENERATE SQL TUNING ADVISOR REPORT IN ORACLE DATABASE

Choose the sql to be tuned Create the tuning task using the below procedure Check teh advisor parameters that can be used for configuration of the tuning task Execute the tuning task which was created earlier Typical views which are related to tuning tasks Check the advisor log, if the tuning task is completed Generate … Continue reading “HOW TO GENERATE SQL TUNING ADVISOR REPORT IN ORACLE DATABASE”

VARIABLES IN PYTHON

Variables are buckets or holders which holds or contains the objects which are assigned to them during declaration Every programming language has a variable concept which is essential for storing different types of objects in the heap memory In below example, Variable x is declared first and y is assigned to x. In this case, … Continue reading “VARIABLES IN PYTHON”