Re: Oracle process timeslice,setting priority

From: Telemachus <tollg_at_tendwa.rns.net>
Date: Sat, 14 Dec 2002 14:20:14 -0000
Message-ID: <y6HK9.35185$zX3.78730@news.indigo.ie>

Perhaps the Resource Manager may help .

http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96524/c10rsmgr .htm#24583

though some testing would be advisable.
As Sybrand righly says the alteration of process priority is a bad thing. "David" <dfairman16_at_hotmail.com> wrote in message news:b4cefdce.0212140148.44d94509_at_posting.google.com...
> As I mentioned in a previous posting, fortunately this is a one-off
> scenario and being used to create metadata for legacy data to
> facilitate efficient searching/indexing from now on. The data has
> always been in the database and my approach, given the volume of
> information, was to simply to use database functionality to extract
> all necessary information.
>
> > Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message
> > Yes you can, but Oracle advises expressly against it.
> > You would also better resolve the cause than introduce 'workarounds'
> > aggravating your situation.
>
> Point taken. I am considering taking the processing out of the
> database; exporting the minimal amount of data necessary to achieve
> metadata construction, processing on a speedy local client, and
> importing the resultant metadata back into the database. A few
> testruns I've done in the past few hours suggest I should have opted
> for this route from the beginning :(
>
> David
Received on Sat Dec 14 2002 - 08:20:14 CST