Alright, getting somewhere now.

I have the Oracle Management Server up and running, can connect using Oracle EM.

However, when I try to click on my database, I get a login screen....

Thanks for the response.

These services are running under local system accounts.

OracleOraHome92Agent

OracleOraHome92TNSListener

That's a start, I guess.

I can't find the strings "service name", or "service name" in any .ORA file on...

And furthermore, assuming we can switch to app.sec., can we still determine their login name (SUSER_SNAME()) at the server?'

The auditing requires that we know who's done what.

Thanks for the quick replies.

OK, more info:

These same users are members of an Active Directory group (IMS_Live), which is granted DB access.

They are to use only one application (IMS) to...

Done with nested cursors (curses!)

Does not significantly hinder perf -- in dev.

Now, let's try running 30 times a minute, with 250 users!

mwah-ah-ah-ah-ah-ah

BTW: Rows 7 and 8 should be as follows (I forgot to increment the nLevels).

INSERT tmp_list VALUES (7, 3, 'SubSubHeading1')

INSERT tmp_list VALUES (8, 4, 'DetailA')

What I'm trying to do is...

There were also NINJA loans: No Income, No Job, No Assets (collateral).

Really now, who in their right mind could think these would ever be repaid, regardless of what the models...

It comes down to the first acronym I ever learned having to do with computers and computing: GIGO -- Garbage In, Garbage Out.

True for both data and code, which always...

re: Definitions

In my mind, the data model *is* business logic incarnate. The objects and relationships expressed though the model's design are nothing if not business logic. (I'm not saying that...

John,

Looks like you hit it with the SET options. Closer inspection revealed that SET ANSI_WARNINGS was ON for QA, OFF from app.

Changing that made the difference.

Steve,

Running everything...

This weekend, I came upon the definition of kludge. The following is from Wikipedia: In modern computing terminology, a kludge (or often a "Hack") is a 'solution' to a problem,...

Indexes rebuilt for the second time in 2 hours.

What took 20 minutes earlier today -- but after the same index rebuild 2 hours ago -- now returns in...29 seconds!!!!!

My head...

Only difference in SET options is Quoted Identifiers on for QA, off for app.

All others identical.

Now, running same reports, but for a shorter time period: 20 minutes and counting both...

How do I see the query plans?

"It (always) depends", and I've found it's poor performance and complaints from users that tends to focus the DBA's mind.

After a few episodes, thinking begins.

P