no way to compare when less than two revisions
Différences
Ci-dessous, les différences entre deux révisions de la page.
— | informatique:base_de_donnees:identifier_une_session_qui_pose_probleme [2010/10/06 21:36] (Version actuelle) – créée - modification externe 127.0.0.1 | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
+ | * On check les process les plus consommateurs : | ||
+ | oracle@machine:: | ||
+ | 9486516 | ||
+ | |||
+ | |||
+ | * Une session SQL Plus permet d' | ||
+ | |||
+ | oracle@machine: | ||
+ | oracle@machine: | ||
+ | oracle@machine: | ||
+ | | ||
+ | SQL*Plus: Release 9.2.0.6.0 - Production on Tue Jul 24 10:42:59 2007 | ||
+ | | ||
+ | Copyright (c) 1982, 2002, Oracle Corporation. | ||
+ | | ||
+ | | ||
+ | Connected to: | ||
+ | Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production | ||
+ | JServer Release 9.2.0.6.0 - Production | ||
+ | | ||
+ | SQL> set linesize 300 | ||
+ | SQL> col machine format A10 | ||
+ | SQL> select a.username, a.osuser, | ||
+ | 2 from v$session a, v$process b | ||
+ | 3 where a.paddr = b.addr and b.spid=9486516; | ||
+ | | ||
+ | USERNAME | ||
+ | ------------------------------ ------------------------------ ---------- ------------ ---------- | ||
+ | SADMIN | ||
+ | SERVER | ||
+ | |||
+ | * On vérifie que ça concorde : | ||
+ | |||
+ | oracle@machine: | ||
+ | COMMAND | ||
+ | oracle | ||
+ | |||
+ | * On va faire un tour sur la machine distante (ici un Windows) : | ||
+ | |||
+ | netstat -an | ||
+ | |||
+ | * Et on détermine le process incriminé : | ||
+ | |||
+ | [TCP] D: | ||
+ | PID: 6496 | ||
+ | State: | ||
+ | Local: | ||
+ | Remote: |