hi kids industry and going to a discuss
about how to check the status of Oracle
processes so at here first I'm going to
write at a select statement
adelson actor it's drawn from so
selecting right here first G and so
dollar symbol and your we need to write
the process now it off to the next row
thing is the dollar the next is citizen
now it off tooth next is the dollar and
here that skill area
now I still to this theory
so at here it's a displaying eight D D
art that is address PID is SPID be name
and here this all those tanks and here
there are three columns all there now
here off to the next to think is so
let's so so at him I am NOT going to
include at your extra so at your first
I'm going to create an tiem so there's
so many nulls or those are there so I
don't want add your learned rows so for
this we need to do add your filter so I
don't here first I'm going to cared area
or Helios so out here we underscore
closet sorry all dollar process
advocating else p1 and for session
creating the elapsed s1 and here
hitting the alehouse v1 no here after
the next is variety of t1 t1 and here
dot so going to use at a user
name username and you're giving RTO
column alias here underscore user now
here after the next is s 1 dot Artyom
user name and here giving X's understood
user no here follow comma and here it's
1 and here adding status and in double
quote writing test now for moe
and yeah it's 1 dot and here going to
use video and here interval for giving
at your serial numbers now here after
next is t1 and here dot is the ID is the
ID so idea interval called writing
process ID now let's use sub test your
function and here p1 the base t of
function and you v1 dot here going to
use SQL underscore text and yeah this
will start from 1 and it will go eight
nine nine and you this is LDLs at your
text long
our tale so select a bomb and here after
let's use their cloth and here even
thought a deep our city can find a
double D are equal to this one dot k TT
earth now if after words use and
operator
now after s1 dot user name username
slider is not know and the after let's
use an operator no a after going to use
s1 and your dot SQL underscore address
address Fulton v1 dot C double D or you
don't have a dress and you let's use
plus symbol now yeah after and operator
once again and the after let's use as
one hello and here s Q and s 1 dot SQL
underscore act as underscore body valdon
Colton v1 dot has underscored value
and yell plus know if the let us
practice theory and execute that side I
am getting somewhere here from
keyboardist north phone so let's so
rectify this whistle so aren't you so I
attend we need to give homo and the rest
on once again
saya s18 tt are invalid identifiers so
Adam we need to include a TT our status
of process address of a doctor let's try
once again
so idea is one serious identifier now
the idea with cereal we need to include
agile as the idea Syrian and Europe to
include have no let's execute again
so this term added her unyielding output
so are you forced to this select a new
username your user and your guess when
you sell and here after status and your
serial number and a after serial number
and here loss hiding and here after this
the text and here plom the B dollar
process and the hundred dollar assassin
and V dollar a skill area and here after
this is anivia p1 dot address even
taught idea so p1 is the allows powerful
be process and here s 1 is the and
layoffs offseason so active in this to
condition is match and here s 1 dot
username is not done and you so address
of s1 SQL address of s1 and the
addressed mostly equal then it self
disciplined slider P underscore user
activates all our system because Adria
and login with system and ESS underscore
user so added edge and here you can find
D P has an empty and here of Troop so
this the F status so after this is the
active status and here so this is ad
your serial number 5 and your process ID
and you know here after H also this the
inactive here serial number and her
process ante and register query officer
actor or yes from TV table layer no
longer equal to one now here after so
RTO
so total numbers of oh I do so those are
displaying trap so this for me we can
all take an tiem or a status of Oracle
process silent here the status is active
here to active and yes with no system
and his system this is the serial number
and it is the process ID and here the
system theory
so select o antipas society text this
all those things so added is the active
status so if you write this kitty you
here didn't you get the active status of
process so I hope test the sweetest
actor for you so now in this widgets
powers the tanks watching stay next to
it thank you