;) |
|
|
In this Issue |
|
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
A few weeks ago, I called upon you loyal SearchDatabase
readers to submit your toughest questions to stump our
site
experts. We received over a
hundred questions -- I knew the modern DBMS was complex, but
wow!
The experts' responses ranged from a confident "None of
them really posed a challenge" to "I don't have the
slightest clue how to answer that one." In order to pick the
contest "winners," we first discounted questions that
couldn't be answered because they were incoherent or didn't
include enough background information or were just plain
silly -- one questioner wanted our expert to fix his SQL
code that had decodes four deep and 17-way outer joins! We
narrowed down the remainder to these three brain-teasers:
- Regan Galbraith asked: "I need to determine
when SQL Server does lock escalation. I currently have a
stored procedure that determines who is locking which
resources by joining data from sysprocesses and syslockinfo,
with a bit of data from the sysobjects table. My problem is
that I report that the duration of a lock being held isn't
accurate, in the sense that I report the duration from when
a process acquired a lock on an object until the time of
reporting, but I can't determine at which points during that
period the lock escalates from a RID to a PAGE etc. I need
to understand the criteria it uses, or else be able to track
the actual escalation event. B.O.L. doesn't help. Any
thoughts?"
- Emmad Kareem asked: "I am using Oracle 8 under
HP-UNIX and I have a problem with PL/SQL procedure that
uses UTL_FILE.GET_LINE. When the line contains nothing but a
line feed character, it raises the NO DATA FOUND and the
file handle is initialized (probably indicating end of
file). How can I make it continue reading past the blank
line until the real EOF?"
- Kevin Naidoo asked: "I recently performed an
upgrade from Oracle 8.0.5 (64-bit) to 8.1.7 (64-bit) on an
HP-UX 11.00 (64-bit) L3000 server using the Oracle migration
assistant (ODMA). The application is SAP. The migration runs
approx. 50% on the progress bar before stopping with the
following error: 'ORA-00600 internal error code, arguments
[koxsihread1], [0], [0], [4], [], [], []'. Even Oracle
support can't figure this one out! Any thoughts?"
If you can answer any of these questions, e-mail
me and I'll officially
declare you a database god! Thanks again everyone for your
participation, and don't forget to check out the
hundreds of SQL, design, data warehousing,
Oracle, DB2, and SQL Server questions already answered. It's
a great knowledgebase -- use it!
Till next time, Tim
|
|
|
Featured Topic: |
|
The Database Top Ten
by Tim DiChiara, Site Editor
We analyzed traffic stats, ratings, and
feedback and came up with a list of your favorite
SearchDatabase content so far this year. Inside you'll find
the best of the best tech tips, news analysis, and Ask the
Expert advice...
Read more about this topic
|
|
|
Expert Technical Advice: |
|
Featured Expert Ian Abramson, CTO, Ian Abramson Systems Inc.
Category: Data Warehousing
Ian is the founder of IAS, Inc, which has built
a fourteen-year reputation for delivering high quality data
warehouse and Oracle systems to clients around the world.
Ian is also the co-author of several Oracle books and is
currently the Director of Education Programming for the
International Oracle User Group. Ask Ian your toughest data
warehousing questions!
View all Ian's answers
|
|
This Week: In the forums
|
| >> |
DBA vs. developer: Can't we all just get along?
We received many interesting thoughts about the
perennial conflict between DBA's and developers. Click on
over to our "DBA Water Cooler" forum and add your proverbial two cents! |
| >> |
Oracle backup hangs
Member "CoolWool" is running an Oracle
8/Win2000 backup but it hangs after 30 runs. Can anybody
check over his code and find the mistake? If so, go to our "DBA Water Cooler" forum. |
| Tip of the Week: |
| Here is a simple suite of (hidden) Oracle SQL
scripts which enables the user to insert the odd few rows
into any table in the users schema without the labor of
having to construct the usual SQL insert statement. The
script automatically constructs the full syntax for a SQL
insert statement for the table name provided by the user, by
repeated reference to the Oracle data dictionary. |
| >> |
An alternative to INSERT statements |
|
|
Site Highlights |
|
|
|
| Attend IOUG Live! |
| IOUG Live! 2002, April 14 - 18 in San Diego is THE Education Conference for Oracle Users by Oracle Users. Visit the IOUG web site to review session abstracts and register. |
|
Register Today
|
|
| Oracle 8i PL/SQL |
| Free CDROM training. You pay the shipping. We send the disk. |
|
Click for detai
|
|
| Automate IT |
| Access this Audio archive today to learn how to eliminate downtime & operational headaches & how to increase your quality & cost savings through an automated infrastructure. |
|
Click Here
|
|
|
|
