These days we had a little argument with a colleague. His statement was: host file on OS level has always priority over DNS, NIS, etc.

Hmmm … I did not agree. Why? Because I know from some Linux distributions there is an option to set this during the installation phase. Because here we speak for HP-UX I started to read the documentation for this OS. What I found is the same that is relevant for the other *nixa and it is the following.

Really the default sequence is first to check in host file, after that in resolve.conf. However, there is a third file named nsswitch.conf which can be used to change the sequence. If you would like to use DNS servers for name resolving first instead of host file (that is obsolete method by itself) then you should amend the line for hosts like this below:

hosts: dns [NOTFOUND=continue] files

Useful information:

Here: http://www.docs.hp.com/en/B3921-90010/nsswitch.conf.4.html

and here: http://docs.hp.com/en/5992-0715/ch06s01.html

Posted by admin | No Comments »

Actually that means: Search and Classification.

SAP NetWeaver Search and Classification (TREX) finds information in both structured and unstructured data. TREX provides SAP applications with services for searching and classifying large collections of documents and for searching and aggregating business objects.

The Search Engine Service (SES) enables users to search for business objects. SES is part of the SAP NetWeaver Application Server and accesses TREX functions through the TREX ABAP client.

I started with checking all settings of TREX in our Knowledge Warehouse system. It seems to me not all settings have been done in the past, because there is very slow performance when try to load pdf files from KWH system.

I will put documentation what I found and what should be checked.

Posted by admin | 2 Comments »

An ABAP developer asked me: Is it possible to determine the usage of an index on database level?

Hmm … interesting question, I have never checked this before. So, I rolled up my sleeves and started with the investigations.

What I found are similar scripts from Mr. Burleson here

http://www.dba-oracle.com/oracle_tips_unused_indexes.htm

and from a guy soumen here

http://soumen.wordpress.com/my-work-2/how-many-indexes-which-are-in-use-and-which-are-abusive-to-your-sap/

Thanks to both!

Actually I changed a script a little bit and below is what I used, because I mainly interested in VBEP!Z01 index and my SAPR3 user is SAPASE:

select p.object_name, p.operation, p.options, count(1) ind_use_count

from dba_hist_sql_plan p, dba_hist_sqlstat s

where p.object_owner = ‘SAPASE’

and p.operation like ‘%INDEX%’

and p.sql_id = s.sql_id

and p.object_name = ‘VBEP~Z01′

group by p.object_name, p.operation, p.options

order by p.object_name, p.operation, p.options;

The result was:

What does it mean? That means 53 INDEX RANGE SCAN operations on index VBEP~Z01.

Happy tuning!

Posted by admin | No Comments »

When you would like to create a new OSS user who could access SAP Marketplace you must perform some simple steps.

First of all the S-user account which you will use have to have the appropriate authorizations to maintain user data. You must log in Marketplace with this user account.

The navigation is Data Administration -> User Data -> Request New Users.

On the next window you must fill all necessary fields out. You have to have Customer ID (it is erased on the screenshot below).

When you fill all the fields out you could choose the button Authorizations. There is an opportunity to set the authorizations by your own or to copy from the existing user with similar responsibilities.

On the next screenshot you can see the result.

After that choose button Done and the button Save.

That is all.

Posted by admin | No Comments »

You would like to change the operation mode emergency.

Choose Exception operation option and press Change button.

This screen will appear.

Double-click on the time period you would like the operation mode to be changed. Pay attention it could not be the current time period (in this case 12:00-13:00). Double click on the end period if it is bigger than one hour. After that choose button Assign. From the window that appears choose the desirable operation mode. it should be predefined in RZ04 transaction.

Choose Green tick (OK) and the operation mode would be assigned.

Posted by admin | 6 Comments »

This script has been taken from the Oracle Metalink. Thanks to the authors for this!

All rights reserved!

Statements Version: 4

Created on: November 13, 2008 5:25 PM by Helmut

Last Modified: February 2, 2009 11:44 PM by Marianne

You would like to identify some long running statements in an Oracle database.

At SQL*Plus level you could use it as it is.

rem LONGOPS.SQL
rem Long Running Statements
rem Helmut Pfau, Oracle Deutschland GmbH
set linesize 120
col opname format a20
col target format a15
col units format a10
col time_remaining format 99990 heading Remaining[s]
col bps format 9990.99 heading [Units/s]
col fertig format 90.99 heading “complete[%]”
select sid,
opname,
target,
sofar,
totalwork,
units,
(totalwork-sofar)/time_remaining bps,
time_remaining,
sofar/totalwork*100 fertig
from v$session_longops
where time_remaining > 0
/

However, in case you are an SAP Administrator without access at OS level to SQL*Plus, then you could use the following excerpt from this SQL script (actually the remaining is for formating):

select sid,
opname,
target,
sofar,
totalwork,
units,
(totalwork-sofar)/time_remaining bps,
time_remaining,
sofar/totalwork*100 fertig
from v$session_longops
where time_remaining > 0;

Happy SQL-ing and tunning!

Posted by admin | No Comments »

I did not till today …

Somebody sent to me a request: Please check this include!

What I found really confirmed my conviction that to be serious does not mean to be gloomy all the time.

So, SAP also have its own jesters.

Below is the beginning of this include:

*———————————————————————-
* INCLUDE LV61BMES
*———————————————————————-
* This INCLUDE contains all generated access routines. Never change it
* manually.
* Whoever disturbs the silence in this INCLUDE will be hunted by 1000
* crying devils!!!
*———————————————————————-
*———————————————————————*
* FORM COND_ACCESS_ME *
*———————————————————————*
* This is a generic form routine which is a template for real *
* condition access routines. *
*———————————————————————*
FORM COND_ACCESS_ME USING APPLIKATION
SCHEMA.
MOVE-CORRESPONDING KOMKBME TO KOMK.
PERFORM KONDITIONSVORSTEP(SAPLV61B)
USING ‘X’
KOMKBME
KOMPBME
APPLIKATION.

………………………………..

The version management shows:

Version Cat Fla SAP Rel. Arch Request Project Date Time Author

Version(s) in the development database:

activ X 620 22.06.2004 15:34:14 SAP

There are no versions in the version database.

Posted by admin | 1 Comment »

Till now I haven’t found enough time to investigate this SAP tool in-depth, but I still have this intention. My quick look on this tool has been very satisfied. In my unpretending opinion it is a powerful tool in the SAP Oracle Database Administrator’s hands.

Coming soon …

Posted by admin | 2 Comments »

The colleagues ask me: How to find the history of the statistics in Oracle?

My answer is: well, it is not very difficult, just see the instructions below.

You could find this with the following SQL:

SELECT *

FROM DBA_TAB_STATISTICS

WHERE TABLE_NAME = ‘ My_Table_Name ‘;

My_Table_Name is the name of the table which you would like to check whether the statistics are locked.

There are three views you could use depends on your desire:

• DBA_TAB_STATISTICS displays optimizer statistics for all tables in the database.
• USER_TAB_STATISTICS displays optimizer statistics for the tables owned by the current user. This view does not display the OWNER column.
• ALL_TAB_STATISTICS displays optimizer statistics for the tables accessible to the current user.

In an SAP system you can use the report RSORADJV for this purpose or use SQL Plus at OS level.

From SAP system it could be checked with a transaction DB20.

Posted by admin | No Comments »

The colleagues ask me: How to find the history of the statistics in Oracle?

My answer is: well, it is not very difficult, just see the instructions below.

You could find this with the following SQL:

SELECT *

FROM USER_TAB_STATS_HISTORY

WHERE TABLE_NAME = ‘My_Table_Name‘;

My_Table_Name is the name of the table which you would like to check the history of the statistics for.

There are dictionary views that display the time of statistics modifications. These views are useful in determining the time stamp to be used for statistics restoration.

• Catalog view DBA_OPTSTAT_OPERATIONS contain history of statistics operations performed at schema and database level using DBMS_STATS.
• The views *_TAB_STATS_HISTORY views (ALL, DBA, or USER) contain a history of table statistics modifications.

In an SAP system you can use the report RSORADJV for this purpose or use SQL Plus at OS level.

Posted by admin | No Comments »