jp_vijaykumar's blog
Submitted by jp_vijaykumar on Sun, 2020-03-08 11:02
TIME SERIES ANALYSIS IN SQL AND PL/SQL
Written JP Vijaykumar
Date Mar 8th 2020
Submitted by jp_vijaykumar on Fri, 2020-01-10 17:20
DISKSPACE MONITORING
Written JP Vijaykumar
Date Jan 4th 2020
Modified Jan 5th 2020
**************************************************************
This article/script is provided for educational purpose ONLY.
The readers are advised to make necessary changes to the script as may be required for their use in their respective environments.
Pls test these scripts thoroughly in a lower environment, ONLY if you are satisfied with the tests' results, then ONLY use in any
Submitted by jp_vijaykumar on Sun, 2019-09-22 16:16
Decision Tree Algorithm in pl/sql
Author JP Vijaykumar
Date Sept 14th 2019
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:13
Tablespace Capacity Planning Report
Author JP Vijaykumar
Written Sep 14 2017
Modified Mar 08 2019
***************************************************************************************************************
This script is provided for enducational purpose only.
The readers are advised to make necessary changes to the script as may be required for their use in their repective environments.
Pls test this script thoroughly in a lower environment, before using in any production db.
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:11
********************************************************************************
APRIORI ALGORITHM
********************************************************************************
Modified March 08 2019
Submitted by jp_vijaykumar on Fri, 2019-03-08 20:09
********************************************************************************
--LINEAR REGRESSION ALGORITHM IN PL/SQL
--------------------------------------------------------------------------------
Modified Mar 8th 2019
Using Linear Regression algorithm, find the weight of a studen, whose is 71 inches tall.
Given the height and weight of 8 students.
Submitted by jp_vijaykumar on Sat, 2019-01-05 18:03
--NAIVE BAYES ALGORITHM WITH SQL & PL/SQL
---------------------------------------------------------------------------------
--Written JP Vijaykumar
--Date Jan 4th 2019
--This script is provided for educational purpose only.
--The readers are advised to make necessary changes as may be required for their use.
--I love data mining algorithms for their complexity and number crunching toughest logic.
--Academically, I want to generate Naive Bayes algorythm in pl/sql to predict the outcome.
Submitted by jp_vijaykumar on Wed, 2010-04-14 22:56
KILLING USERS SESSIONS IN ORACLE
Author JP Vijaykumar Oracle DBA
Date Apr 14th 2010
A detailed discussion on redo, undo and Oracle's read consistency are
beyond the scope of this document.
A detailed discussion on setup, troubleshooting of user connections
in MTS environment is beyond the scope of this document.
Before embarking on a killing spree of Oracle sessions, let us explore
the options, limitations, dos and don'ts.
Submitted by jp_vijaykumar on Mon, 2009-12-14 18:36
KILLING SESSIONS IN ORACLE
--------------------------
Author JP Vijaykumar
Date Jan 27th 2009
Modified Jan 29th 2009
/*
One of my procedure is taking long time to complete. I want to kill my job and
re-run the procedure after incorporating HINTS.
Let us explore the options to kill long running jobs.
From the v$session, I found that my session is active.
*/
select username, osuser,sid,serial#,status from v$session where sid=57;
Submitted by jp_vijaykumar on Sat, 2009-11-14 20:23
Many a time, developers ask for procedures to kill there own sessions in the oracle db.
Many of our developers are scattered around the globe in different time zones.
During on-call rotation, developers will be calling me, round the clock, to kill their sessions.
|
