May 2014 – SWKB.NET

Here is how to expand the space of a fixed disk in VirtualBox:First, the disk should be cloned with the flag --variant Standard, so to be converted into dynamic. Then…

Oracle DB: Locked objects

Post author:admin
Post published:May 4, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

Find out which objects are locked using the following query: select substr(a.os_user_name,1,15) "OS User", substr(a.oracle_username,1,8) "DB User", substr(b.owner,1,8) "Schema", substr(b.object_name,1,20) "Object Name", substr(b.object_type,1,10) "Type", substr(c.segment_name,1,15) "RBS", substr(d.used_urec,1,12) "# of Records", …

Oracle DB: Uncommited transactions

Post author:admin
Post published:May 4, 2014
Post category:Oracle DB: How To Examples
Post comments:0 Comments

You can find the number of uncommited transactions using the following query:SELECT ROWS_PROCESSED,sql_textFROM v$sqlareaWHERE (address, hash_value) IN(SELECT sql_address, sql_hash_valueFROM v$sessionWHERE sid in (select sid from v$session where schemaname='VAG'))or using v$transaction…

WebLogic Server 12c – ADF: Preparation for ADF on Windows

Post author:admin
Post published:May 1, 2014
Post category:WebLogic
Post comments:0 Comments

Here are the steps needed to prepare the Weblogic Server 12c for running ADF applications on Windows:Prerequisite: Use Java Standard Edition JDK installed on a directory, which does not have…