Hi all,
I have a following problem. I have a MetaFrame
-environment where I need to support to different
character sets.
Database is UTF8 format.
Now I need to support for some users Russian Character
Set and some users West European Character set.
How I can define in
My point wasn't to pick any particular detail
of any particular example . I was merely making
the point that whilst the concept of DDL without
commits seems to be straightforward, the requirement
for designing something that could analyse and handle
all the consequent errors that might be a
Hi list ,
i have 8.1.7 database with 10 users ,from time to time aim iam faced with
error TNS :packet writer failure .,so
i have to retart dbase again .what is the cause of this error ? can I
avoid it ?.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
-
Hi list ,
i have 8.1.7 database with 10 users ,from time to time aim iam faced with
error TNS :packet writer failure .,so
i have to retart dbase again .what is the cause of this error ? can I
avoid it ?.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
[EMAIL PROTECTED] wrote:
Yes, the only problem is that doing a join with the dba_extents
query makes this run rather long.
Jared
Because the join is done BEFORE the HAVING filtering. I would push the
HAVING to an online view, and join on the output. And use sys.uet$,
sys.seg$, sys.obj$ and
Terry,
RMAN should be always be at, or newer than, the version of any target
database being backed up. So, yes, you need to upgrade your recovery
catalog prior to any other databases.
-Ron-
-Original Message-
Terry
Sent: Friday, January 24, 2003 10:34 PM
To: Multiple recipients of list
2 ;
Starting restore at
25-JAN-03
allocated channel:
ORA_DISK_1
channel ORA_DISK_1: sid=9
devtype=DISK
channel ORA_DISK_1: looking for
autobackup on day: 20030125
channel ORA_DISK_1: looking for
autobackup on day: 20030124
channel ORA_DISK_1: autobackup found:
c-1370501721-20030124-06
channel
Michael,
Somewhere along the line, I mis-interpreted your
note and thought you were saying that CBO was
ignoring the hint - hence the irrelevant comments.
RBO uses the index for this query because
that's one of the rules.
The CBO under ALL_ROWS optimisation is going
to compare figures (in
Title: RE: Configuring back up in Oracle 9i
look in your configuration-preferences-preferred credentials.
you not only have to have the sys password set for 'target type=database' but you also have to have the proper password set for 'target type=node' (machine where your database is.
chris
Having the same problem of inconsistent output from ls (and other Unix
commands!), I grabbed els from http://www.sourceforge.net. I use els -p
+Gmsn +TMDY3, aliased of course, to produce consistent listings everytime.
For an ls -l equivalent, I use els -l +TMDY3.
HTH! GL! :)
Rich
Rich Jesse
The solution Larry suggested is quite
a bit easier to take. :)
...
It also performs better.
Jared
Issue of performance is something I didn't go into detail in the original
response since it was already so long. I said they, analytics, *can* make a
big difference in performance, not
Another common problem is that in Windows environments that the user on the
node must be granted the "log on as batch" privilege . This is true even
if they are
in the admin group.
John
[EMAIL PROTECTED] wrote:
RE: Configuring back up in Oracle 9i
look in your
Can somebody tells me the MUST hardware
requirement forOracle 9iAS installation.
We are planning to useWin 2000
thanks
Unique opportunity with a great company in Austin, Texas who needs an Oracle
DBA
who also has solid Unix C++ Server programmer skills.
*MUST have both skillsets to be considered.
Base salary is in the 70-95K range and depends on experience.
Relocation Assistance is provided.
PLEASE Do Not
And don't forget to use a no_merge hint in the
in-line view. Oracle is getting far too smart
about simplifying complex queries these days.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
An odd thing, though. Sometimes the query that
is (a little) slower when run stand-alone is the
better bet when run in a highly concurrent environment
because of latching issues.
Converting self-joins to analytics can, on occasion,
increase CPU usage but reduce latching - a strategy
that seems
I agree, I will probably crank up some concurrent tests later on the test I
built.
I created a pretty simple test case (starting with a small sort and hash
area size) where the correlated history type of query wins over a
non-correlated approach (using a hash join) and an analytical approach and
set optimizer_index_cost_adj to value that is less than (cost without hint
* 100 / cost with hint).
Waleed
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 24, 2003 7:34 PM
Lower the settings for optimizer_index_cost_adj.
set
Larry,
A good way to demonstrate the scalability if SQL is to use
Tom Kyte's test harness.
http://govt.oracle.com/~tkyte/runstats.html
This is a very simple but very effective demonstration of the
difference in scalability of 2 pieces of SQL.
I used it in a post a few weeks ago to
Though I know nothing about MetaFrame, I do
know that an NLS_LANG env variable will
override the registry setting.
I'm assuming that these users must somewhere login
to Windows, even if they don't do so directly. Set
the env var NLS_LANG='my char set' for them.
HTH
Jared
On Saturday 25
Interesting utility, though you need to navigate to the CVS
browser to actually get the file.
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/els/els/
Jared
On Saturday 25 January 2003 07:23, Jesse, Rich wrote:
Having the same problem of inconsistent output from ls (and other Unix
Thanks Stephen, but I'm just not ambitious enough
for that today. :)
Jared
On Saturday 25 January 2003 05:20, Stephane Faroult wrote:
[EMAIL PROTECTED] wrote:
Yes, the only problem is that doing a join with the dba_extents
query makes this run rather long.
Jared
Because the join is
Is this on NT?
It is usually a network error that Oracle
is complaining about.
Jared
On Saturday 25 January 2003 01:31, Walid Alkaakati wrote:
Hi list ,
i have 8.1.7 database with 10 users ,from time to time aim iam faced with
error TNS :packet writer failure .,so
i have to retart
If you're in Arizona and are interested, the Arizona Oracle User Group
(AZORA) is holding it's next meeting on 2/6/2003 from 12:30 to 5:00 PM.
The agenda is:
1:00 PM - Michelle Mol (Veritas) No Time for Downtime: Architecting
High Availability for Oracle Databases
1:00 PM - Stephen Andert
Im doing an upgrade from 8.1.6. to 8.1.7.4.
Is there any benfit of doing the upgrade from 8.1.6 to 8.1.7, using
ODMA then patching to 8.1.7.4
or
installing 8.1.7, patch it to 8.1.7.4, then ODMA the database from
8.1.6.
any other comments on this upgrade path are welcomed
thanks
Sam
--
Hi all,
I have a following problem I hope you could help me:
I have an UNIX box (Solaris8) where I have installed 9iRel2 64 bit software, also I have created two instances using that 64 bit version.
Now we are also having an application which needs 32 bit 9i client software on the same server. The
What I would do is create a separate 8.1.7.4 OH. I'd then start the 8.1.6
database under 8.1.7.4 and apply the upgrade scripts. Of course, I'd backup
my 8.1.6 database before I did any of this.
Cheers!
RF
-Original Message-
[EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 10:39 PM
To:
bytes
Database Buffers 50331648
bytes
Redo Buffers 798720 bytes
RMAN restore spfile from
autobackup
2 ;
Starting restore at
25-JAN-03
allocated channel:
ORA_DISK_1
channel ORA_DISK_1: sid=9
devtype=DISK
channel ORA_DISK_1: looking for
autobackup on day: 20030125
28 matches
Mail list logo