VirtualBox: Expand fixed disk
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
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
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
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…
Oracle DB: Add/Drop/Rename objects
Some sample commands for Add/Drop/Rename objects:--Dropping the primary key:ALTER TABLE "VAG"."TEST_TABLE" drop primary key;drop index "VAG"."TEST_TABLE_PK";--Adding primary key:CREATE UNIQUE INDEX "VAG"."TEST_TABLE_PK" ON "VAG"."TEST_TABLE" ("TEST_TABLE_ID");ALTER TABLE "VAG"."TEST_TABLE" ADD CONSTRAINT "TEST_TABLE_PK" PRIMARY…
Oracle PL/SQL: Autonomous Transaction for logging
Here is an example how to use autonomous_transaction for logging purposes.In case of rollback only the main transaction is affected.declare l_categories_count varchar2(100); process_error Exception; procedure log(p_message varchar2) is …
Oracle DB: Extract DDL without storage specifications
For exporting the DDL of data objects without the storage specifications, this is what we should do:EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);select DBMS_METADATA.GET_DDL('TABLE','PROJECTS') from DUAL;EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'DEFAULT');
Oracle DB: Get BLOB field size in sql query
This is how to get the size of a BLOB in SQL query:select file_id, doc_xml, dbms_lob.getlength(doc_xml) from my_files order by dbms_lob.getlength(doc_xml) desc
Java: Ping application
Here is a code to call ping command on windows using java. The question would be, why not to ping directly from ms-dos window? :)The answer is because this application…
Java: XPath: Read series of attributes from xml files
The following piece of code is an example of extraction of specific attribute from an xml file.The xml looks like this:<?xml version="1.0" ?><xliff xmlns="urn:oasis:names:tc:xliff:document:1.2" xmlns:fn="http://www.w3.org/2005/02/xpath-functions" xmlns:xft-xliff="http://www.xfa.org/schema/xfa-xliff/1.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.1" xsi:schemaLocation="urn:oasis:names:tc:xliff:document:1.2 xliff-core-1.2-transitional.xsd"><file…