Debugging Oracle Berkeley DB

Troubleshooting common Berkeley DB problems

The following are some common problems that applications encounter in the link given below

https://docs.huihoo.com/berkeley/db-4.2.52/docs/ref/debug/common.html

How to Debug an Oracle ADF Application

Oracle ADF is an end-to-end Java EE framework that simplifies application development by providing out-of-the-box infrastructure services and a visual and declarative development experience.
Please find the below article for debugging the Oracle ADF Application

how-to-debug-adf-application/

How to setup remote debug with WebLogic Server and Eclipse

There is a nice blog on how to remote debug Weblogic server using Eclipse in the below link

how-to-setup-remote-debug-with-weblogic.html

Debugging Oracle Big Data Analytics using BigSift

BigSift combines insights from automated fault isolation in software engineering and data provenance in database systems to find a minimum set of failure-inducing inputs. It redefines data provenance for the purpose of debugging using a test oracle function and implements several unique optimizations, specifically geared towards the iterative nature of automated debugging workloads.

BigSift exposes an interactive web interface where a user can monitor a big data analytics job running remotely on the cloud, write a user-defined test oracle function, and then trigger the automated debugging process.

BigSift also provides a set of predefined test oracle functions, which can be used for explaining common types of anomalies in big data analytics

More on Bigdata from Oracle at the below link

https://blogs.oracle.com/datawarehousing/big-data-8

Insert data in Table containing Long column in Oracle database(OFF TOPIC)

We can use the copy command in sqlplus to insert data in table containing a long column in the database. This will only work for long column and will not work for long raws.

First, we need to login to the database using sqlplus


> SQLPLUS tkyte/tkyte@aria 


we have the below table with the long column


create table foo
( The_Whole_View   varchar2(65),
  TextLength       number,
  TheText          Long )
/


Next, we can set the below set commands to define the parameters for the copy command to be used to insert into the table which has the long column

• set arraysize N -- the number of rows the copy command will copy with each fetch
• set long N -- the size of your longest long
• set copycommit M -- the number of fetches to do before commit (N*M rows!!)

Then we can use the copy command to insert data into the table which has the long column

SQL> copy from tkyte/tkyte@aria insert foo (the_whole_view, textlength, thetext ) using select owner||'.'||view_name, text_length, text from all_views;

This article is also available in the link Moving LONGS Around

Good concept of Islamic banking

Oracle database tables,functions,procedures can be named in Arabic for Islamic banking

Easy implementation of Foreign language in Oracle database

As per my understanding oracle database is difficult to use in Arabic

The implementation can be done by using google translate 

For example dba_views

The simple implementation is

dba_views can be translated with below steps

1. Translate views into الآراء
2.Translate dba into دبا
3.Translate dba_views  as دبا _ الآراء
4.Build a different dictionary from a to z and translate in verse order in database.
Korean Language implementation

1.Convert Korean characters into dba_views

2.For example 

i.d into 디 
ii.b into 비 
iii.a into 에이
iv.dba can be converted into  디 비에이
v.view can be converted into 전망
vii.s can be converted into 에스
vi.디 비에이 _전망에스
Viii.build a dictionary with vowels in oracle database. Banks with oracle database in Tamil Nadu can use translate Tamil using the following link from wikipedia

Regards,
P Santhiagu