Performance

Yesterday I visited a customer who is facing performance problems in their Oracle environment. I have to go back next week, because I had to examine some solutions.
Their environment exists of an Oracle 10gR2 database, and they are running discoverer and an a application on the same database. That's what causing the performance problems....Now I have to look for the best options to solve this, and present them to the customer. Together we will have to solve this problem.

Huh ?

This morning I was searching Metalink for another FNDLOAD issue, when I ran into the following note 37689.1 ,dated 14-JUL-2006....

It seems Oracle has its own FNDLOAD config file for an Alert !!!
This note is very recent, when I started te work on the config file there was no documentation on Metalink on this subject.
But I don't understand...
Why is the Alert not mentioned is the documentation of FNDLOAD (note 274667.1) ?
Why is the Alert config file not in the $FND_TOP/patch/115/import directory, just like all the other config files ???

Well, it seems I have done a lot of work for nothing. At least now I know how FNDLOAD works in detail.

I suggest everyone who wants to transfer Alerts via FNDLOAD, uses the Oraclce config file..

Services in Windows XP

I always face the same problem when deleting/uninstall an Oracle database from my laptop. I don't know why, but I have always some Oracle services left. After a while you have an large list of services, you no longer need to see...Since you cannot delete them from the services screen, I found a way to delete them from the command line.

In the command prompt use the following :

to delete a service you no longer use : sc delete 'service name'
After refreshing the screen, you will notice the service is no longer in the list....

Unix commands on windows

Today I have installed cygwin on my laptop. With cygwin, you create an unix environment to work with your local databases. Otherwise you only have the command prompt, with cygwin you get an unix like screen and all the unix commands seem to work. I love using 'ls' instead of 'dir'.....

I have also started to read the "Oracle Applications Dba field guide". As far as I can see, it's a nice book with all the tasks a Oapps dba should perform or must know. When I have finished the book, I will tell you more about it.

Oracle rocker......

I participated a OTN forum on '10g Enterprise Manager' and got the following reply...
The problem Dele is facing, is a typical windows problem when using the Enterprise Manager..


DELE
Posts: 9 Registered: 7/13/06
backup with enterprise manager Posted: Jul 19, 2006 1:43 AM

Reply
Dear Folks,I have oracle 10g running on windows 2003 server. I want to use enterprise manager to schedule backup. I tried testing the backup but I receive an error message that user name or password is not correct. I am very sure the password is correct.I contacted my Network administrator who granted me backup operator privileges on the host of the database. To my surprise the error message persists.I installed oracle on windows xp standalone and tried to schedule the backup again with enterprise manager i get the same error again.Please anyone with a solution kindly contact me. This is very urgent pleasesss.

Bas Klaassen
Posts: 40 From: NetherlandsRegistered: 7/22/05
Re: backup with enterprise manager Posted: Jul 19, 2006 1:54 AM in response to: DELE


Reply
Be sure that the os user has the 'Logon as a batch job' privilege.

DELE
Posts: 9 Registered: 7/13/06
Re: backup with enterprise manager Posted: Jul 19, 2006 2:45 AM in response to: Bas Klaassen


Reply
Cheers mate,Your solution works fine. U are a cool oracle rocker.

Import status

Today a colleague started an import, approximately 9 gb (one scheme).
At a certain moment the import was running for three hours and I wanted to know what was happening.
I found the following sql script, which shows you the current table in which the import is inserting rows. It seemed our import was inserting over more then 18 million rows.

SELECT
SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name
, rows_processed
, ROUND( (sysdate-TO_DATE(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes
, TRUNC(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute
FROM sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;

The script was published by Nasir Mahmood.
Here is an example output of the script....

TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "ICE_CVS_FAC_TUSSEN_TAB" 3626392 1436 2525

Especially the table sys.v _$sqlarea is very interesting, I am going to find out more about this table.

Internet

Because of the moving project, I was offline for a few days.
unfortunately, the I also had to cancel the Oracle meeting because of I had to work on the house..I hope there will be a next time. Tuesday I am at work again, so hopefully I have more DBA news then..

Database special

tomorrow evening I will be joining an OGH meeting in Holland.
The meeting is called 'Database special' and will cover the following subjects :
1. Sleepy cat
2. SQL Developer
3. Times ten
4. Oracle database vault

John Abrahams from Oracle will tell us more about these subjects
And I will let you know...

Work....

Todat the second day in our new house....there's a lot of work ot be done.
I'll hope to post some real dba stuff later..