Unlock Table in Oracle (Kill Session)

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
filipe009
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Mon, 28 Jan 2008 6:42 pm
Location: Niterói - RJ

How do I pair a table in Oracle?
diegoleite
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 115
Joined: Sat, 10 Nov 2007 2:54 pm
Location: rio de janeiro
Att,


Diego Leite
DBA ORACLE

Filipe,


Scroll table ?? like this?? Move to another Owner ?? Move to another tablespace ??? It facilitates aí .. you were very short with your problem !! :(
filipe009
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 19
Joined: Mon, 28 Jan 2008 6:42 pm
Location: Niterói - RJ

I have a process in Killed state, this process is with a table and lock. I wonder if there is any way to desalcate this table.
diegoleite
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 115
Joined: Sat, 10 Nov 2007 2:54 pm
Location: rio de janeiro
Att,


Diego Leite
DBA ORACLE

Filipe

What is the only UNIX? !!?! = S known as zombie process.

Note: I'm just trying to help. How are the most experienced DBAs have not yet manifested? Carnival NE !! You know how é ..
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

filipe009 wrote: I have a process in Killed state, this process is with a table and lock. I would like to know if there is any way to discourage this table.
Check this discussion: http://en.glufke.net/oracle/viewtopic.p ... er+session

Try the suggested command and Report if there are problems.

Gilberto
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest