sysprocesses

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

spid

smallint

2

No

2

kpid

int

4

No

3

enginenum

int

4

No

4

status

char

12

No

5

suid

int

4

No

6

hostname

varchar

30

Yes

7

program_name

varchar

30

Yes

8

hostprocess

varchar

30

Yes

9

cmd

varchar

30

Yes

10

cpu

int

4

No

11

physical_io

int

4

No

12

memusage

int

4

No

13

blocked

smallint

2

No

14

dbid

smallint

2

No

15

uid

int

4

No

16

gid

int

4

No

17

tran_name

varchar

64

Yes

18

time_blocked

int

4

Yes

19

network_pktsz

int

4

Yes

20

fid

smallint

2

Yes

21

execlass

varchar

30

Yes

22

priority

varchar

10

Yes

23

affinity

varchar

30

Yes

24

id

int

4

Yes

25

stmtnum

int

4

Yes

26

linenum

int

4

Yes

27

origsuid

int

4

Yes

28

block_xloid

int

4

Yes

29

clientname

varchar

30

Yes

30

clienthostname

varchar

30

Yes

31

clientapplname

varchar

30

Yes

32

sys_id

smallint

2

Yes

33

ses_id

int

4

Yes

34

loggedindatetime

datetime

8

Yes

35

ipaddr

varchar

64

Yes

36

nodeid

tinyint

1

Yes