Let me throw in my 2 cents worth on this topic. There are two problems with
SHUTDOWN ABORT that I have experienced in the past.
1. Before 9i (it appears to be fixed in 9i) if you inserted data in a table,
then did a shutdown abort, if after restarting the database, you tried to
truncate the table
Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and
Let me
throw in my 2 cents worth on this topic. There are two problems with SHUTDOWN
ABORT that I have experienced in the past.
1.
Before 9i (it appears to be fixed in 9i) if you inserted data in a table, then
did a
Oops... didn't catch the disk backup bit. Backing up 1TB to disk?? Wow!
Still, the same rules would apply. lots of disks to spread the backup IO
over :-)
RF
-Original Message-
Brian
Sent: Thursday, February 06, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
This is ok fo
Hi,
u can use Platinum Erwin for this.
www.platinum.com
u can easily build data models, reverse engineer an existing
schema from an oracle database, forward engineer the changes made
in the data model so as to reflect back the same schema structure
at the back-end.
it is a very useful t
On certain platforms, Cron quitely fails when there is a error. Eyeball your
crontab file and make a small change - insert and delete a blank line - to
kick start it. Also check the daemon as others have indicated.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
What would you
gmei,ÄúºÃ£¡
hi, you can look into v$mystat or v$sesstat to get those status value.
Good luck.
=== 2003-02-05 07:59:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
>Hi:
>
>I am trying to understand why sqlplus did not display stats when I run
>"analyze table ..." and "create index ..."?
>
>TIA.
>
Dennis,
We did use LoadRunner for testing out 'static' functions for a 11i load
test, with limited success. Be aware that the scripting will take a while
and will have to be carefully done to make sure that you are simulating your
real environment. The load is pretty real, but you need to decide i
Hi All,
If I create a backup user, what is the minimum requirements to connect as
that user and do hot backups?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Hi Waseem,
When you decide to use 'group by' in your query, I can just suggest you to
not use 'order by' clause, my reason is, it will makes your query running
slow. Try to just use 'group by' clause without 'order by' clause, your
query will running faster than when you include 'order by' clause.
v$open_cursor doesn't reflect all cursors counting towards the max open
cursor limit. To see truly how many cursor each session is consuming
you need to associate v$sesstat with v$session and look at statistics#=3.
Richard Ji
-Original Message-
Sent: Thursday, February 06, 2003 7:39 PM
T
Lisa,
Be aware that AIX uses the memory for File system caching, and as much as it
can. So don't be surprised by low values in 'fremem' in vmstat. What you do
need to watch out is the 'pi' (page in) column which can indicate paging
in.. Large values in 'po', when you are seeing lots of physical f
Dennis,
ask your developer to enable simple tracing (in case there is
no trace file on the server), figure out what statement fails,
run it locally on the server using sqlplus/srvmgrl -- you can
expect some more meaningful error message that is probably not
handled properly. Another idea is to ena
Hello All,
I have a question about db linking between 2 Oracle 8.1.7 databases.
A little background. Our logical database spans 2 physical databases
(in separate organizations), which are currently connected over
database links. Local db is 8.0.6; remote db is 7.3.
User accounts are external
Dennis
Is there an sqlnet.log file tossed up on the VB client that has a
TNS-12203 (unable to connect to destination) error?
If so, make sure that the switch port the Alpha is plugged into
has been hard-coded to 100Mb/s full duplex.
"Friends don't let friends auto-negotiate"
Known problem with
The max open cursors include necessary cursors to run direct sql submitted
by user and the cursors needed to run recursive sql by the system.
Regards,
Waleed
-Original Message-
Sent: Thursday, February 06, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
Hi,
We're currently getti
Hi to all,
Thanks for the comments, but none of them worked for me,
I tried putting a comment in the init.ora file to the rollback segments line
to recreate the controlfile. No success.
I did get a message telling me that there was a 'MISSING000' datafile in
$ORACLE_HOME/dbs, and tried to do a of
You'll want to ensure that any other files that used
in conjunction with the database are backed up with
their locations well-noted.
- listener config files
- parameter files
- stored parameter file
- oracle password files
etc etc
hth
connor
--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: >
We'
Ron,
Trunacte is DDL not DML. The easiest was around this is to wrap it in an
execute immediate command:
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE LOT837_GLOBAL_TBL_KMG';
END;
/
Note that the semi-colon is outside the quotes - don't place a semi-colon
inside the quotes.
Regards,
Mark.
Hi,
We're currently getting a lot of ORA-1000 errors (max open cursors
exceeded) on Oracle 8.1.7.4.
I tried looking at v$open_cursor and saw the following:
1* select sid, count(*) from v$open_cursor group by sid order by count(*)
desc
SQL> /
SID COUNT(*)
-- --
Dennis:
I have had some experience with developers using ADO. First, are they
using ODBC or OLE for the database connectivity between ADO and the
database.
If they are using ODBC, determine if it is Microsoft 's or Oracle's ODBC.
The version of Microsoft's ODBC the developers were using did not
Sounds like a
network problem, beware of the network outages during off hours. Re-write
in perl and run on the db server :). Change the times it runs and see
if you can recreate the problem.>>> [EMAIL PROTECTED] 02/06/03
05:14PM >>>Dennis, I have been plagued by
a similar problem and ha
There is a product on the market that dramatically
reduces the cost of RAc to almost nothing. Its
called:
LF ver 1.0
where LF = "license fraud". Of course, to get it, you
will need to send me a license fee for LF, plus
ongoing maintenance costs.
:-)
Cheers
Connor
--- Mogens_Nørgaard <[EMAIL
truncate is a sqlplus command(and DDL), so to do it, you need to use the
dbms_sql(or execute immediate) command, i think.
joe
Smith, Ron L. wrote:
I am not a coder but I received this from one of our developers. I
can't find anything about this anywhere. Can someone tell me how to
make the
Look up info on using "execute immediate"
This will let you put non-DML-type statements in a PL/SQL block.
-Original Message-
I am not a coder but I received this from one of our developers. I can't
find anything about this anywhere. Can someone tell me how to make the
truncate work?
T
Title: RE: Help with a truncate command in a procedure
(pant pant)
Will I be the first to say that you need to use dynamic SQL?
dbms_sql package in Oracle version < 8.1
execute immediate in Oracle version >= 8.1
-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
I am
I know our company did some trials with WinRunner and the general
consensus amongst the people testing of which two were our development
dba's thought it a very good product.
We however didn't buy due to the decision to purchase some other products
from one of there competitors and so I believe
Title: Help with a truncate command in a procedure
Truncate is a DDL. So you can't just do
"truncate" like you would with delete which is a DML.
You
didn't say which version of Oracle you are running. If it's 8i,
do
execute immediate "truncate table
.";
Otherwise, look into DBM
That's what I was looking for, thanks. I understood that state
information was preserved (after all, one could fetch one row an hour),
but I didn't know how/where. I guess the cursor contains information
on the last step executed of the optimizer plan.
--- Richard Ji <[EMAIL PROTECTED]> wrote:
Normally there is some stuff in the platform-specific
installation manual or in the migration manual. In
any event, you pretty much stick 8i under one
directory / filesystem and 9i under another and use
oratab (in conjunction with oraenv/coraenv) to toggle
between them
hth
connor
--- Ray Stell
cursor_sharing = force
can cause it. Bug.
> -Original Message-
> night, and sometimes receives an ORA-03113 end-of-file on
> communication
> channel. Not consistently, just sporadically, and at varying
> amounts of
> time. I have been unable to find anything in the server logs.
> We
Title: RE: RAC on linux?
Uncle Larry is probably thinking, "Since you're saving so much money on the O/S and the hardware you have more to spend on Oracle so don't complain."
I'm actually hoping open source PostgreSQL/MySQL start to compete and force Oracle to lower their pricing... I can dre
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say
flashcopy works the same if not better than EMC BCVs. Question, is this
pure marketin
Hi this is a pretty trivial question. I have executed
a set of sql scripts. The scripts included a set
ofSELECT command followed by exit. While the scripts
have been running, I was checking the number of
sessions open
and their status. I have noticed that at any time I
had a number of sessions with
I believe it's meant for personal use:
1. two 1-cpu intel box: $1000
2. Linux: $0.50
3. Oracle RAC for free.
Waleed
-Original Message-
Sent: Thursday, February 06, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
I'm a bitter, old, twisted man. And I feel like it when I read this
Mogens,
Thank you kindly for forwarding my questions to the head honcho. I would
be extremely pleased if he responded but not offended if he didn't.
Funny enough, we are currently using Lite with Intermec 700 handhelds
(StrongARM chipset) running Pocket PC (Windows CE) in hospitals to
manage supp
Nice tool but the major draw back that I find it it only monitors the
applications you kick off. It would be nice if it would monitor like the
TOAD monitor does. I like the fact that it scrolls the previous command
and you can look back and see what happens that you did not know or
understand. This
I'm a bitter, old, twisted man. And I feel like it when I read this thread.
Here's why.
A lot of good people are celebrating the fact that Oracle RAC can run on
a two-node Intel cluster with Linux on top. Very cost-efficient, they say.
Well, here's my small calculation:
1. Two 4-cpu Intel boxe
Hello Lads,
Thanks a lot for useful answers.
--
Best regards,
Alexmailto:[EMAIL PROTECTED]
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.c
Title: Help with a truncate command in a procedure
I am not a coder but I received this from one of our developers. I can't find anything about this anywhere. Can someone tell me how to make the truncate work?
Thanks!
R.Smith
In a DB procedure, I wanted to include the following SQL:
BEG
Dennis,
I have been plagued by a similar problem and have a fix if it fits. Check
the statements where the 3113 is coming from. Are they going to a remote
database? And if so, are the tables on the remote database analyzed while the
local tables are not? Then the fix is to delete the stati
We are in the process of creating a 9.2 RAC database. And we are being
forced to follow a standard whereby, all files are to be in a directory
structure, say /local. No standards have yet been defined, if one were
using raw volumes. And since we will be using raw volumes for the
datafiles, to enfor
Title: RE: Maximum enabled roles
Huh. In the Oracle 8.1 documentation (Oracle8i Reference - Release 2 (8.1.6) - Part Number A76961-01) I see a default value for MAX_ENABLED_ROLES of 20. However in the 8.1.7 database I'm running on my PC max_enabled_roles is not mentioned in the init.ora, and t
OMG
are you KIDDING
Do you
know when?? I just found out (as you may remember from my "Just Shoot Me"
post) that IBM's version of desupport is "don't even ask us".
Thank
you so much Ruth for pointing this out.
Have a
great day.
Lisa
-Original Message-From: Ruth Gramoli
Ray - Since I don't see where anyone replied, I think the problem is your
stress on "well documented". Might have scared people off. The basic
procedure is to use separate ORACLE_HOME for each version. Make sure each
version doesn't share anything you don't want them to. Most Unix systems
require c
I have a developer that wrote a VB program using ADO, connecting to Oracle
8.1.6 on a Compaq Tru64 server. One program of his runs for hours each
night, and sometimes receives an ORA-03113 end-of-file on communication
channel. Not consistently, just sporadically, and at varying amounts of
time. I h
OK. And about the Oracle compatible.
Only create a new windows 2000 service is necessary, any upgrade of
database is require. Is it Correct ?
--
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
Thursday, February 06, 2003, 4:39:17 PM, you wrot
Bob,
They switched to a different list server provider and there were numerous problems.
They may have unsubscribed you. Here's a quick list of email addresses for the
OAUGNet-DBA list. I assume the OAUGNet list email addresses would be similar.
To unsubscribe, E-mail to: <[EMAIL PROTECTED]>
http://news.lycos.com/news/photo.asp?from=mylycosphoto§ion=BreakingPhoto
s&photoId=amdf319368
Or for the full "story"
:http://news.lycos.com/news/story.asp?section=Breaking&pitem=ODD%2DLIFE%2DJA
PAN%2DDOG%2DDC&rev=20030206&pub_tag=REUTG&from=photodetail
--
Please
Does the max_enabled_roles initialization parameter have to be set for
an instance?
If it is not set is the limit the default of 20 or do you have
unlimited enabled roles. I have looked through the docs and I only find
the upper limit for max_enabled_roles is 148.
Thanks
Don Bricker
Database
Title: RE: Looking for simple monitor script dbup.bat
If I understand you correctly, the problem is that you don't get an ERRORLEVEL set when you are unable to connect to a database. Have you tried sqlplus/nolog? (Ignore the french text, I have Oracle installed in french on my PC)
D:\>sqlplu
I agree with Jared and Scott that's the best way to do it.
-Original Message-
Scott
Sent: Thursday, February 06, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
First off I am an NT/Win2k admin and I fully agree with you Jared. Blow
the partition and start from zero, you'll be happ
And the teachers at the Madison G&R training center are frequently either
Oracle contractors or ex-oracle employees.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent: Thursday, February 06, 2
Kirti,
Just took another look at our kproc processes. What is weird is that we have
26 of them, 9 are owned by oracle the rest are root (huh?). All of them
started at system boot. Also, almost all of the CPU is used by the top four
(current %CPU and total over the life of the process) with the res
I am not currently working in an AIX environment; but when I did (and it was
4.3 with 8.1.6/7) we always set timed_statistics=true with no adverse
effects.
-Original Message-
Sent: Thursday, February 06, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Good morning everyone -
Qui
Yet another choice:
www.thinkspark.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
By the way, Lisa. AIX 4.3.3 is being desupported.
We are testing 9i on AIX5.2 as I write this. I could not get the powers
that be to move away from 8.0.x and now we are jumping right to 9i. I did
install 8.1.7 and use OEM2.2, but that won't support a 9i database. I will
install the new
Sorry
to contact u of list.
Do
happen to know how to install rpm packages in aix?
I
downloaded c 5.1 from ibm (in rpm) wich is necessary to install 9ir2 but i don't
know how to install rpm in aix 4.3.3. Could u help me???
Thanks
in advance
Paulo
-Original Message-From: Scott Ste
Hi all -
We are thinking about using Mercury WinRunner to load test our 11 to 11i
upgrade and wondering if anybody has experience using this before. How steep
the learning curve, how reliable and how 'real' the load is comparing to the
production load. Any other feedbacks are also welcome.
Thanks
Title: RE: windows application to show sql being executed by a client pr
Well I guess the cat is out of the bag! I didn't think that TOAD with SQL Monitor had been released yet. Yes, an (earlier?) version of his app was chosen to be incorporated in TOAD.
-Original Message-
From: [EMAI
Lisa,
Try oslevel -r at the command promt. It should tell you.
-Scott
At 09:49 AM 2/6/03 -0800, you wrote:
Hi
Ethan,
Thanks so much for your
reply. I'll have to check which patch level we are on.
Have a great day!
Lisa
-Original Message-
From: Post, Ethan
[mailto:[EMAIL PROTEC
Consider TUSC for your training needs. We offer all sorts of Oracle classes.
www.tusc.com.
Robert G. Freeman
Technical Management Consultant
TUSC - www.tusc.com
Author of several books you can buy on Amazon.com!
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/6/2003 11
First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the
partition and start from zero, you'll be happy you did.
Scott
First off, I am not an NT/Win2k admin, and don't even play one on TV.
The advice from every SA I've asked about this, and from searching the
web,
is don'
Hey Dave,
In Madison, Greenbrier & Russell -- I believe they were the first Oracle
Certifed Partner -- has many Oracle classes. I've been happy with the
Milwaukee-area classes.
http://www.gr.com/what/classhtml/coursesbylocation_madison.asp
HTH! GL! :)
Rich
Rich Jesse
Title: windows application to show sql being executed by a client program
Looks
pretty nice. Real similar in concept to TOAD's SQL Monitor, but adds the
option of seeing the values of bind variables, formatting the SQL, watching
processes, etc.
Worth
the download, IMHO.
Dave
-Ori
Title: RE: windows application to show sql being executed by a client
If anything it will be incorporated into an existing Quest Product.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Pretty cool...
A future Quest product ??? ;)
Just wondering... :)
When Klaus Andersen (the guy who hired me into Oracle Denmark in 1990,
and now is Managing Director of Microsoft Denmark) was head of Oracle
Education world-wide he put into the standard license terms that you
cannot use Oracle software for training of 3rd parties.
Klaus is a very smart guy. I
Well, you're getting close.
The full message looks like this:
ORA-01652, "unable to extend temp segment by %s in tablespace %s"
The interesting part of the message appears where the '%s' are.
Jared
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/06/2003 0
The Oracle Software Investment Guide should be downloaded about every
two weeks according to my friends in Oracle Legal, because things change
rather often. The SIG is about 70-80 pages, by the way.
There are cpu licenses and Named User Plus (NUP) liceneses available
now. That's it.
Mogens
Ja
First off, I am not an NT/Win2k admin, and don't even play one on TV.
The advice from every SA I've asked about this, and from searching the
web,
is don't do it. Rebuild the box. There are remnants of NT left if you do
an
upgrade, and you don't really want that, do you?
Jared
"Breno A. K
Could you post it to the list?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 12:14 PM
> Bob,
> I have a very simple script which checks to see if the database is up and
>
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Hi
Henry,
OS
isn't paging when I've looked. But with the memory this low it seems to me
paging could happen pretty darn quick.
There
are a couple of logins that can run reports. These aren't big databases
but as you know
Hrm, how about UTF8?
-Original Message-
Sent: Wednesday, February 05, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Dear List,
Life was pretty easy here before they came up with
this euro symbol :-( We had WE8ISO8859P1 (the default
I bevieve) as a char set on all Unix and MS (so
Saira,
I've forwarded your message to the CTO of Oracle Lite, my old friend
Jacob Christfort, whom I know from our days at the National Hospital
Dormitory in Copenhagen, where we had lots of fun, and where many nurses
lived. Those were the days, but sadly we both ended up working with IT.
If J
I have been told that I will finally get a budget for some training and want to get
some in Oracle. I see that Learning Tree has some classes. Do you guys have any
recommendations to links to point me to other sources for classes. Everything I have
learned has been from RTFM and books from so
Hi Jared,
Responses in line.
Jared Still wrote:
>
> I think your list of reasons for using RMAN is incomplete.
>
> The database backup window may need to be shrunk not
> because the database is so big, but because there are a lot
> of systems to backup, and they use a lot of time and ta
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Hi
Ethan,
Thanks
so much for your reply. I'll have to check which patch level we are on.
Have a
great day!
Lisa
-Original Message-From: Post, Ethan
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 1
Title: RE: Looking for simple monitor script dbup.bat
Hi Bob,
Check out Steve Adams' script (www.ixora.com.au). It's written in ksh and will need a little modification to send emails, but it's bulletproof. Also others on the list have mentioned Cygwin (?) the Windows-ksh to allow this to
Henry,
I got aiostat from IBM Support when I bugged them about how to monitor AIO. Not sure
if aiostat is readily available as a download from their Web site or in/for the newer
versions of AIX.
It works similar to vmstat and iostat, showing number of pending AIO requests at the
time of samp
It worked once and I'm not going to try it again (why bother?). The
setup.aix is just an executable that execs a java process using setup.jar.
I'm not really happy and this system is pretty unstable, but so it goes. I'm
still struggling with igoring the problems I see or I wouldn't get anything
els
Precisely. Our partner's SA also followed this idea and that's why
his Sun server crashed due to a NFS bug. Unfortunately, my database
was on it. :(
Richard
-Original Message-
Sent: Thursday, February 06, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Quoting Bernardus Deddy H
Thanks Peter... Ya, I will be moving it between Netapp san and EMC disk.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
You will only know what your system is capable of
It is very dependant on the disk arrays and no
Hello guys,
I remember seeing a freeware software that can connect to a database
through ODBC on Windows, then reverse engineer the ER diagram from the
database.
Could someone on this list email me or us the link to get this
software? Thank you very much.
--
Lyndon Tiu
--
Please see the offi
Bob,
I have a very simple script which checks to see if the database is up and
open. I've emailed you the script.
Orysia Husak
Database Management Services
PEROTSYSTEMS
(602) 307-2896
cell: (602) 300-9752
-Original Message-
Sent: Thursday, February 06, 2003 9:00 AM
To: Multiple recipient
Vladimir,
You can also try these:
sizer -p (# of processors)
sizer -v (full version string i.e. 5.1A where uname -a says 5.1)
HTH
Stephen
>>> [EMAIL PROTECTED] 02/06/03 08:33AM >>>
psrinfo -v
vmstat -P
-Original Message-
How do I find hardware info on Tru64 machine?
Available RA
Thanks Dennis...
Ya.. its all on disk and problably only a test with some tuning is going
to give me realistic picture. I am going to try it on NETAPPS new disaster
recovery SAN solution
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 3:50 PM
To: Multiple recipients o
Kool!
Thanks...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 16:33
>
> psrinfo -v
>
> vmstat -P
>
>
> -Original Message-
> How do I find hardware info on Tru64 machine?
>
> Available RAM, number of CP
Dennis,
I tend to treat use of hints for exceptional cases only. With
collections CASTed as tables, I seem to have a generalized problem of
tables involved being scanned FULL (not using the available indexes)
and query response being slow. I can't seem to build a query with
collections and have it
Sean - I could probably be of more help if you could describe something
about how you propose to recover the system. Do you have a recovery site?
Have assurance from your vendor that they could provide a comparable system
somewhere in a reasonable frame of time?
Another item to consider would b
hi aidan,
the following script will create .ctl and .dat files for each table of
OWNER.
These files can then be used with sqlldr.
HTH alex
#!/bin/ksh
###
#
# Desc: create CTL and DAT files for sqlldr usage
#
###
I had to apply the SP1 for Oracle to run.
I built the PC from all off-the-shelf inexpensive parts ;)
I will now let my Win NT4.0 Server die on its own...
- Kirti
-Original Message-
Sent: Thursday, February 06, 2003 12:09 AM
To: Multiple recipients of list ORACLE-L
upto you if you're s
Could you post execution plan, statistics?
Concatenated index on (TEST_DATE,TEST_VAL) might help, as well as increasing
the size of sort_area (if you find, that it uses disk for sorting).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE
Hello,
I'd like to update my server (Windows NT) to Windows 2000 Server.
I have a Oracle Database 9i in this machine.
Does anyone know any kind of problem in this operation (database
compatible) ?
Thank.
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
This is ok for tape restores but not for disk restore...but thanks Rob.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:36 PM
To: Multiple recipients of list ORACLE-L
Take a look at this link, it might be helpful...
http://portal1.legato.com/resources/whitepapers/W
Quoting Bernardus Deddy Hoeydiono <[EMAIL PROTECTED]>:
> I
> suggest if
> your O/S (Win2K) running well ,please don't apply the service if
> not
> necessary.
Perhaps this is the advice most people followed that's why that
Slammer worm took off.
--
Lyndon Tiu
--
Please see the official ORACLE-
Hi,
Is any one getting emails from OAUGNet & OAUGNet-DBA
list servers (WWW.OAUG.COM)? For some reason, I am not
getting emails for the last one week.
Thanks
Bob
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailpl
>-I'm thinking some type of crib sheet with useful commands for that DR
>-situation might be useful too.
This is one of my main ways that I survive, I really like cheat sheets. Also have a
$50 bill in the folder to go buy beer afterwards, you'll need it. ;o)
Dave
-Original Message-
Se
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
No problems here AIX 4.3.3 ML9 Oracle 8.1.7 64 bit.
Lisa,
Be aware that there are some issues with ML9 as I am finding out with
swap. We are planning on going to ML10 which should fix the problem as
well as using vmtune command
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question
Lisa,
We've been using
timed_statistics=true
at our site for over
a year, without any problems.
ed
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Thursd
Look for sys_check.tar in the Compaq web.
It do a full test and audit of your system.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de DENNIS
WILLIAMS
Enviado el: jueves, 06 de febrero de 2003 15:59
Para: Multiple recipients of list ORACLE-L
Asunto: RE: hw i
Reed,
Thanks.
I do not know what we may have. They (Sybase DBAs) are still looking for the CD for
me.
May be this newer release of the driver might work with OMWB...
- Kirti
-Original Message-
Sent: Thursday, February 06, 2003 7:49 AM
To: Multiple recipients of list ORACLE-L
Kir
1 - 100 of 142 matches
Mail list logo
