SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE9.2.0.8.0 Production
TNS for 32-bit Windows: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
SQL> select sid,username,paddr,server,status,logon_time,program from v$session where status='INACTIVE';
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
51 DSOA
1366F048 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
60 DSOA
1366DCC0 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
68 DSOA
1366E490 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
70 DSOA
136703D0 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
80 DSOA
1366D4F0 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
83 DSOA
1366B1C8 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
94 DSOA
1366E878 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
95 SYSTEM
1366F430 DEDICATED INACTIVE 02-9月 -08 sqlplusw.exe
98 DSOA
1366E0A8 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
99 SYS
1366B998 DEDICATED INACTIVE 02-9月 -08 sqlplus.exe
110 DSOA
1366FC00 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
111 DSOA
1366F818 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
123 DSOA
1366C168 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
125 DSOA
1368F7D0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
127 DSOA
13686F18 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
129 SYSTEM
1366C938 DEDICATED INACTIVE 02-9月 -08 sqlplusw.exe
131 DSOA
1366B5B0 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
136 DSOA
1366D108 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
139 DSOA
1366BD80 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
150 DSOA
1366CD20 DEDICATED INACTIVE 02-9月 -08 aspnet_wp.exe
151 DSOA
1368CCD8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
156 DSOA
1368D4A8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
303 DSOA
136B1E98 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
304 DSOA
136AFB70 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
305 DSOA
136B2668 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
306 DSOA
136B1AB0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
307 DSOA
136B2E38 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
308 DSOA
136B3220 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
309 DSOA
136B3608 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
310 DSOA
136B39F0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
311 DSOA
136B6CB8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
312 DSOA
136B41C0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
313 DSOA
136B45A8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
略去部分内容..................................
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
314 DSOA
136B3DD8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
316 DSOA
136B5160 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
317 DSOA
136B4990 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
318 DSOA
136B5930 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
319 DSOA
136B5D18 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
320 DSOA
136B6100 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
321 DSOA
136B70A0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
322 DSOA
136B68D0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
323 DSOA
136B4D78 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
324 DSOA
136B64E8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
325 DSOA
136B7488 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
326 DSOA
136B8040 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
327 DSOA
136B7C58 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
328 DSOA
136BAF20 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
329 DSOA
136B8428 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
330 DSOA
136B8810 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
331 DSOA
136B8BF8 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
332 DSOA
136B8FE0 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
333 DSOA
136B9F80 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
334 DSOA
136B7870 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
335 DSOA
136B9B98 DEDICATED INACTIVE 29-8月 -08 aspnet_wp.exe
336 DSOA
136B93C8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
337 DSOA
136BA368 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
338 DSOA
136BA750 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
339 DSOA
136BAB38 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
340 DSOA
136B97B0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
341 DSOA
136BB308 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
342 DSOA
136BD630 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
343 DSOA
136BBAD8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
344 DSOA
136BC690 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
345 DSOA
136BBEC0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
346 DSOA
136BC2A8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
347 DSOA
136BCE60 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
348 DSOA
136BB6F0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
349 DSOA
136BD248 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
350 DSOA
136BCA78 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
351 DSOA
136BEDA0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
352 DSOA
136BDE00 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
353 DSOA
136BE1E8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
354 DSOA
136BDA18 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
355 DSOA
136BE9B8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
356 DSOA
136BE5D0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
357 DSOA
136BF188 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
358 DSOA
136BF570 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
359 DSOA
136BF958 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
360 DSOA
136BFD40 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
361 DSOA
136C0128 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
362 DSOA
136C0510 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
363 DSOA
136C0CE0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
364 DSOA
136C08F8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
365 DSOA
136C10C8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
366 DSOA
136C14B0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
367 DSOA
136C1898 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
368 DSOA
136C2C20 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
369 DSOA
136C2068 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
370 DSOA
136C3008 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
371 DSOA
136C2450 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
372 DSOA
136C2838 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
373 DSOA
136C4B60 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
374 DSOA
136C1C80 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
375 DSOA
136C37D8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
376 DSOA
136C3BC0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
377 DSOA
136C3FA8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
378 DSOA
136C4390 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
379 DSOA
136C33F0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
380 DSOA
136C4778 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
381 DSOA
136C4F48 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
382 DSOA
136C5718 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
383 DSOA
136C5B00 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
384 DSOA
136C5330 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
385 DSOA
136C5EE8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
386 DSOA
136C62D0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
387 DSOA
136C66B8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
388 DSOA
136C6AA0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
389 DSOA
136C6E88 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
390 DSOA
136C7270 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
391 DSOA
136C85F8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
392 DSOA
136C7A40 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
393 DSOA
136C7658 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
394 DSOA
136C89E0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
395 DSOA
136CA920 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
396 DSOA
136C7E28 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
397 DSOA
136C8DC8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
398 DSOA
136C91B0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
399 DSOA
136C9598 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
400 DSOA
136C9980 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
401 DSOA
136CAD08 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
402 DSOA
136CA150 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
403 DSOA
136CA538 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
404 DSOA
136C8210 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
405 DSOA
136C9D68 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
406 DSOA
136CB4D8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
407 DSOA
136CB0F0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
408 DSOA
136CCC48 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
409 DSOA
136CB8C0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
410 DSOA
136CC090 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
411 DSOA
136CBCA8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
412 DSOA
136CC860 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
413 DSOA
136CC478 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
414 DSOA
136D31D8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
415 DSOA
136CD418 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
416 DSOA
136CD800 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
417 DSOA
136CDBE8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
418 DSOA
136CDFD0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
419 DSOA
136CE3B8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
420 DSOA
136CE7A0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
421 DSOA
136CEB88 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
422 DSOA
136CEF70 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
423 DSOA
136CF358 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
424 DSOA
136CFB28 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
425 DSOA
136CF740 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
426 DSOA
136CFF10 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
427 DSOA
136D02F8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
428 DSOA
136D0AC8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
429 DSOA
136D06E0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
430 DSOA
136D0EB0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
431 DSOA
136D1298 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
433 DSOA
136D1A68 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
434 DSOA
136D1E50 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
435 DSOA
136D2238 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
436 DSOA
136CD030 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
459 DSOA
136D7C10 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
460 DSOA
136D6888 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
461 DSOA
136D87C8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
463 DSOA
136D8F98 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
465 DSOA
136D9768 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
466 DSOA
136D9B50 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
467 DSOA
136D9F38 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
469 DSOA
136DA708 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
471 DSOA
136DAED8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
472 DSOA
136DB2C0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
473 DSOA
136DB6A8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
475 DSOA
136DBE78 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
477 DSOA
136DC648 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
479 DSOA
136DCE18 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
480 DSOA
136DD200 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
482 DSOA
136DD9D0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
483 DSOA
136DDDB8 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
486 DSOA
136DE970 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
488 DSOA
136DF140 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
490 DSOA
136DF910 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
491 DSOA
136E1468 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
492 DSOA
136E00E0 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
SID USERNAME
PADDRSERVERSTATUS LOGON_TIME PROGRAM
---------- -------------------- -------- --------- -------- ---------- ------------------------------
496 DSOA
136E1080 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
497 DSOA
136E0C98 DEDICATED INACTIVE 30-8月 -08 aspnet_wp.exe
已选择277行。
|
