甲骨文中国区高层

《世界计算机》ICXO.COM ( 日期：2005-09-29)

昨日（28日），《第一财经日报》从甲骨文（中国）公司获悉，公司华东、华西区董事总经理李绍唐将于10月16日正式离开甲骨文公司。这是自去年甲骨文大中华区原总经理陆纯初离职之后，再一次的公司高层变动。

甲骨文亚太区区域高级副总裁Keith Budge在负责其本职工作同时，将担任过渡时期甲骨文华东、华西区董事总经理。

“李绍唐将继续在中国一家非竞争性的公司追求他的事业。”甲骨文公司相关负责人表示，将会在晚些时候公布正式继任者名单，不过他没有透露，李绍唐具体会去哪家公司。

据了解，李绍唐于2000年5月加入甲骨文，担任甲骨文台湾区董事总经理，并于2003年7月被任命为甲骨文华东、华西区董事总经理。

去年中，甲骨文调整了大中华区的组织结构，甲骨文大中华区原总经理陆纯初离职。这让李绍唐、李翰璋（甲骨文中国公司北方区董事总经理及大中国区电信行业总经理）和潘应麟（甲骨文中国公司华南和香港区董事总经理）三人组成了甲骨文中国最高层管理团队。李绍唐的离职则意味着三人团队的开始松动。

根据甲骨文2005财年报告，中国新许可证销售收入第一次在公司所在亚太市场中名列第一，全球名次也从3年前的第10位上升为第6位。作为甲骨文在中国最重要的三个区域之一，华东、华西地区对甲骨文中国整体业绩的增长作出了重要贡献。

Interview questions for aspiring Oracle apps DBAs

Naveen Nahata

08.28.2005



[With the IT job market so tight, every available position is typically met with an avalanche of applicants. Naveen Nahata offers this list of technical interview questions for Oracle E-Business Suite DBA applicants that helps him quickly weed out the poseurs. If you hiring managers have any similar questions, email me and I'll add them to the list. --Ed.]

Questions

1. What happens if the ICM goes down?
2. How will you speed up the patching process?
3. How will you handle an error during patching?
4. Provide a high-level overview of the cloning process and post-clone manual steps.
5. Provide an introduction to AutoConfig. How does AutoConfig know which value from the XML file needs to be put in which file?
6. Can you tell me a few tests you will do to troubleshoot self-service login problems? Which profile options and files will you check?
7. What could be wrong if you are unable to view concurrent manager log and output files?
8. How will you change the location of concurrent manager log and output files?
9. If the user is experiencing performance issues, how will you go about finding the cause?
10. How will you change the apps password?
11. Provide the location of the DBC file and explain its significance and how applications know the name of the DBC file.

Answers

1. All the other managers will keep working. ICM only takes care of the queue control requests, which means starting up and shutting down other concurrent managers.


2. You can merge multiple patches.
You can create a response file for non-interactive patching.
You can apply patches with options (nocompiledb, nomaintainmrc, nocompilejsp) and run these once after applying all the patches.

3. Look at the log of the failed worker, identify and rectify the error and restart the worker using adctrl utility.

4. Run pre-clone on the source (all tiers), duplicate the DB using RMAN (or restore the DB from a hot or cold backup), copy the file systems and then run post-clone on the target (all tiers).
Manual steps (there can be many more):

Change all non-site profile option values (RapidClone only changes site-level profile options).
Modify workflow and concurrent manager tables.
Change printers.

5. AutoConfig uses a context file to maintain key configuration files. A context file is an XML file in the $APPL_TOP/admin directory and is the centralized repository.
When you run AutoConfig it reads the XML files and creates all the AutoConfig managed configuration files.

For each configuration file maintained by AutoConfig, there exists a template file which determines which values to pick from the XML file.

6. Check guest user/password in the DBC file, profile option guest user/password, the DB.
Check whether apache/jserv is up.
Run IsItWorking, FND_WEB.PING, aoljtest, etc.

7. Most likely the FNDFS listener is down. Look at the value of OUTFILE_NODE_NAME and LOGFILE_NODE_NAME in the FND_CONCURRENT_REQUESTS table. Look at the FND_NODES table. Look at the FNDFS_ entry in tnsnames.ora.

8. The location of log files is determined by parameter $APPLCSF/$APPLLOG and that of output files by $APPLCSF/$APPLOUT.

9. Trace his session (with waits) and use tkprof to analyze the trace file.
Take a statspack report and analyze it.
O/s monitoring using top/iostat/sar/vmstat.
Check for any network bottleneck by using basic tests like ping results.


10. Use FNDCPASS to change APPS password.
Manually modify wdbsvr.app/cgiCMD.dat files.
Change any DB links pointing from other instances.


11. Location: $FND_TOP/secure directory.
Significance: Points to the DB server amongst other things.
The application knows the name of the DBC file by using profile option "Applications Database Id."

Tracking the progress of long-running queries

Manish Upadhyay

09.14.2005 SearchOracle.com


Sometimes there are batch jobs or long-running queries in the database that may take a while to complete. This query will show the status of the query -- how much of it is completed. In other words, this may be viewed as a "progress bar" for the query. It has been tested on v. 9.2.0.4 on Tru64 and Windows. (Note: This tip is a modified version of a tip from Oracle documentation.)

SELECT * FROM (select
username,opname,sid,serial#,context,sofar,totalwork
,round(sofar/totalwork*100,2) "% Complete"
from v$session_longops)
WHERE "% Complete" != 100
/

Resource-intensive SQL

Vasan Srinivasan

09.14.2005 SearchOracle.com


Here is a simple script to find the most resource-intensive SQL in the database. It has been of immense help to me several times. It has been used on 8.1.7.4 and 9.2.0.5. However, there may be a better way of doing this in 9i that I have yet to learn.

In the SQL below, I am ordering the results by the descending number of executions, but by changing the order to refer to the dre or bge columns, you can find the SQLs with the most disk reads or buffer gets respectively.

select a.executions,
a.disk_reads,
a.disk_reads/a.executions dre,
a.buffer_gets,
a.buffer_gets/a.executions bge,
b.username,
a.first_load_time,
a.sql_text
from v$sql a, all_users b
where a.executions > 0
and a.parsing_user_id = b.user_id
order by 1 desc;

Monitoring rollback progress

QIANGHUA MA
09.14.2005 SearchOracle.com

When a large transaction takes a long time to rollback, it is good to know how much of the rollback is done and estimate how long it is going to take. Given the session's sid, it can be done with the simple statement below, tested on Oracle9i. When a transaction is rolling back, the t.used_ublk and t.used_urec will decrease until they become 0. By sampling the two measures at different points of time, you can calculate how fast the rollback is and when it is going to complete.

SELECT t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr=t.addr
and s.SID =:sid;