Hallo...
Gunakan SQL command berikut untuk melihat object yang ter-lock dan
session yang nge-lockt:
SELECT p.spid,a.session_id, b.serial#, b.status, a.oracle_username,
a.os_user_name,
a.process, c.name,b.event, b.SECONDS_IN_WAIT "Wait(Seconds)"
FROM sys.obj$ c, v$session b, v$locked_object a, v$process p
WHERE a.session_id=b.sid
AND b.paddr = p.addr
AND c.obj#=a.object_id order by b.SECONDS_IN_WAIT desc
;
Kadang-kadang info dari v$lock saja tidak cukup.
Setelah session di-kill, lihat lagi status di v$session; kalao masih
ada dengan status "KILLED", kill saja dari OS.
Referensi:
http://oracleku.blogspot.com/2008/04/kill-hung-session.html
Salam,
Rohmad
--- In [email protected], "Andes Febrian" <[EMAIL PROTECTED]>
wrote:
>
> Dear gurus,
>
> Need help, ketika export satu schema di database 10.1.0.2.0, terdapat
> message eror dibawah ini :
>
> *Code:*
> C:\>exp vpndb/[EMAIL PROTECTED] file=e:\dailybackup\vpnbak010808.dmp
>
> Export: Release 10.1.0.2.0 - Production on Fri Aug 1 09:31:48 2008
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to: Oracle Database 10g Enterprise Edition Release
10.1.0.2.0 -
> Produc
> tion
> With the Partitioning, OLAP and Data Mining options
> Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
character set
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user VPNDB
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions for user VPNDB
> About to export VPNDB's objects ...
> . exporting database links
> . exporting sequence numbers
> . exporting cluster definitions
> EXP-00056: ORACLE error 4021 encountered
> ORA-04021: timeout occurred while waiting to lock object
> ORA-06512: at "SYS.DBMS_METADATA", line 1511
> ORA-06512: at "SYS.DBMS_METADATA", line 1548
> ORA-06512: at "SYS.DBMS_METADATA", line 1864
> ORA-06512: at "SYS.DBMS_METADATA", line 3707
> ORA-06512: at "SYS.DBMS_METADATA", line 3689
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
>
> sepertinya ada yg ke-lock, tp sudah saya liat di v$lock, kemudian
saya kill,
> masih aja ga bisa. mohon pencerahannya, thanks
>
> --
> Cheers,
> ^_^ Andes ^_^
>
>
> [Non-text portions of this message have been removed]
>
