process which lock himself??

Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
Jerome
Have you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/defaul...v_04222005.asp
Paul
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>
|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>
|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jj" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>
|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>
|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>

process which lock himself??

Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_04222005.asp
Paul
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>> Hi
>> At a guess you are locking another process by the same user and not
>> locking the process that is doing the shrink, in that respect the locked
>> process is no different to any other!
>> If you posted your SQL Server version and the output of your sp_who2 it
>> would have been more informative.
>> John
>>
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have some strange behaviors.
>> Sometimes my processes are locked... by themself!
>> I have executed a shrink command through a DBCC command, and the process
>> is locked by himself. (sp_who2 result)
>> this behavior appeared not only during DBCC commands but also during
>> select or other simple commands.
>> any idea?
>> thanks
>> Jerome
>>
>>
>

process which lock himself??

Hi,
I have some strange behaviors.
Sometimes my processes are locked... by themself!
I have executed a shrink command through a DBCC command, and the process is
locked by himself. (sp_who2 result)
this behavior appeared not only during DBCC commands but also during select
or other simple commands.
any idea?
thanks
JeromeHave you intalled sp4?
We are seeing this too.
Maybe nothing to worry about. It appears to be part of the new "stuck I/O"
reporting.
It makes it hard to get a quick view of what is really going on.
See what wait type is shown for the spid
http://www.sqldev.net/articles/WaitTypes.htm
http://msdn.microsoft.com/sql/defau...
v_04222005.asp
Paul
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||Hi
At a guess you are locking another process by the same user and not locking
the process that is doing the shrink, in that respect the locked process is
no different to any other!
If you posted your SQL Server version and the output of your sp_who2 it
would have been more informative.
John
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have some strange behaviors.
> Sometimes my processes are locked... by themself!
> I have executed a shrink command through a DBCC command, and the process
> is locked by himself. (sp_who2 result)
> this behavior appeared not only during DBCC commands but also during
> select or other simple commands.
> any idea?
> thanks
> Jerome
>|||SP4 is installed
I don't have the result of the SP_who2 command, but next time the problem
appear, I'll send it to you.
its the second server with the problem and only after SP4 applied.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
> Hi
> At a guess you are locking another process by the same user and not
> locking the process that is doing the shrink, in that respect the locked
> process is no different to any other!
> If you posted your SQL Server version and the output of your sp_who2 it
> would have been more informative.
> John
>
> "Jj" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OiryhqQdFHA.3808@.TK2MSFTNGP14.phx.gbl...
>|||I had a google and others are reporting this too.
eg "Blocked by own spid" etc.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>|||have you checked to ensure that you do not have a disk bottleneck?
(disk fragmentation /cache conroller problem etc . .)
appears to be the same spid with different execution context..
blocks itself during the execution of a query using a parallel QEP.
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23b7vM8QdFHA.3828@.TK2MSFTNGP10.phx.gbl...
> SP4 is installed
> I don't have the result of the SP_who2 command, but next time the problem
> appear, I'll send it to you.
> its the second server with the problem and only after SP4 applied.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23t0y4zQdFHA.1684@.TK2MSFTNGP09.phx.gbl...
>

Process Detail (T-SQL)

Hello there :-)
Just want know where can we find the last T-SQL being executed on a process. This is the one that pops-up when we double-clik a process on the Process Info List. Thank You in Advance :-)dbcc inputbuffer (@.spid)

procedures inside a package

I have 48 procedures sitting in a PL/SQL package. when I execute the package I have to select one procedure at a time to get it executed. What could I do to execute the package once and get all the procedures executed at the same time sequencially.A package is just a bag of routines and stuff, somewhat like a library. You cannot execute a package, only the procedures within it.

You need to write another procedure, or anonymous PL/SQL block, like this:

BEGIN
pkg.proc1;
pkg.proc2;
...
pkg.proc48;
END;
/|||Thank you very much

procedure to create log and error files

Hi,

I have a procedure, containing 10 tables, whenever my procedure is executed, i what to know the start and end time of each table and this should be stored in a separate file known as log file and all the error info. should be stored in error file, and then i want to run this procedure through unix shell script(.ksh), can u plz.. help me out in this regard.

Thanks in advance.
mahe.For your loggin problem in oracle database you can use the log4plsql tools
see : http://log4plsql.sourceforge.net/

with this tools you can log in a lot off device.

G.