Let it be more efficient, more wealthy and more healthy for all of us.

Posted by admin | 4 Comments »

I wish you a Marry Christmas and a Happy New Year!!!

Posted by admin | 3 Comments »

You can find a lot of useful information in the section Resources, in the section Useful Links and also in the section Useful Books, that I personally think all SAP and Oracle Administrators must read one day.

Posted by admin | 2 Comments »

And again back …

Posted by admin | 5 Comments »

It is great … sea, sun, breeze, dreams …

Posted by admin | 3 Comments »

Task

You would like to change the ABAP program package from $TMP to a z* package.

Solution

You could do this with the following steps:

In SE38, enter your program name. Then use the menu option “goto -> object directory entry”. Click on “Change”, and you can enter the new package. You’ll be prompted for a workbench request number also. The same technique can be used to change packages in other objects.

You can also use transaction SE03 (or the tools option from SE09/SE10), but access is sometimes restricted.

Posted by admin | No Comments »

You would like to find the indexes for a table in Oracle database.

You could find this with the following SQL using user_ind_columns view:
Select table_name, index_name, column_name,

FROM user_ind_columns

WHERE table_name= ‘My_Table_Name’;

If you want to find Column position then add column_position column in the query.

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

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

Posted by admin | 4 Comments »

It is a little bit late for some countries, but for other it is still valid – 31 July is a SysAdmin Day this year.
I would like to wish all the best to all colleagues – Sys Admins and they to be as always very professional and good in all their activities in computer’s areas.

Posted by admin | 4 Comments »

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 »

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 »