ora-600 may result your db down or crash
-Original Message-
Sent: 08 October 2003 10:09
To: Multiple recipients of list ORACLE-L
I want the DB to see and act on an ORA-00600, not just record
one in the alertSID.log
Thanks,
Mike
-Original Message-
Sent: Tuesday, October 07, 200
:)
-Original Message-
Sent: 08 October 2003 09:54
To: Multiple recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
>Ok...strange request time. I want to test a script that I found
>on the DBA Vi
If
you want to reduce your consistent gets, you can reduce your sga size
-Original Message-From: Sultan Syed
[mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To:
Multiple recipients of list ORACLE-LSubject: consistent
gets
Hi,
What does the meaning for this c
Hi
consistent gets are when the SQL needs the data in consistent mode i.e not the current
data. SELECT statements contribute to consistent gets (read from the RBS). DML
normally contribute to db block gets, but say an UPDATE based on a search criterion --
will contribute to consistent gets.
T
Hi,
What does the meaning for this consistent
gets.
Some time my statement return more consistent
gets in statistics.
How I can reduce this Consistent gets.
Thanks in advance.
Title: Message
Sorry
... but I solved it.
Cheers
Sujatha
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sujatha MadanSent: Wednesday, 8 October 2003 1:24
PMTo: Multiple recipients of list ORACLE-LSubject: Unix
Help
Hi,
Sorry
Title: Message
Hi,
Sorry for the
slightly non-Oracle post.
I am after a UNIX
code snippet that will help me copy archive logs to another directory BUT not if
they already exist. So if only 2 archive logs are generated between script runs
only the two new ones should copy. I know I can do
I'm pretty sure that RBO is *gone* in 10g. If I understood correctly
what I learned this week, there will be no more RBO, just one optimizer
code path called the Oracle Query Optimizer. Also, if I understand
correctly, the "RULE" hint will have exactly the same functionality as
the "HEY, DUDE" hint
Melanie,
Yes - in the appendix, there was a direct hit on the SDU setting working with 9.2.0.4 with dynamic registration.
thanks much.
Paul
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
These are the BEST projects to be on. You took a different path than I
would have at the second "Me" line. I would shoot for:
Customer: "It's Slow"
Me: What is?
Customer: The application. Make it fast.
Me: Show me.
Customer: Okay, come see.
Then your job becomes to get a 10046/12 trace on what yo
I want the DB to see and act on an ORA-00600, not just record
one in the alertSID.log
Thanks,
Mike
-Original Message-
Sent: Tuesday, October 07, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
V
Does this help?
http://otn.oracle.com/deploy/availability/pdf/MAA_DG_NetBestPrac.pdf
Melanie
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Drake
Sent: Tuesday, October 07, 2003 9:40 PM
To: Multiple recipients of list
ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know
I thought that I saw something posted somewhere recently concerning the TNS listener SDU setting an support for non-2k sizes with dynamic registration in 9.2.0.4.
Must have seen it late night, can't track it down.
Has anyone come across this?
At 2 sites, it was a choice between connect-time f
Good evening again, Mladen,
Thanks for this. Yes, I knew about the rebuilding of unusable indexes but just forgot
to write it down.
We've logged a TAR with Oracle support and they were non-commital:
"It would be advisable that you first try the reorganization in your
test database and then do i
Type oracle at the unix prompt... You should see the following in the alert
log...
Tue Oct 7 20:21:54 2003
Errors in file /opt/oracle/admin/PV418/bdump/pv418_ora_6629.trc:
ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [],
[]
See Note:33174.1 for more info...
Tim
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality?
Thanks,
Mike
---
==
Hear, hear, Paul!
I too, am a big fan of auditing.
It can make your life so
much easier.
Cheers,
Melanie
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Drake
Sent: Tuesday, October 07, 2003 8:14 PM
To: Multiple recipients
Hi Ethan,
Our SA gave me the following script...
Put it in your /usr/local/bin and include the dir in PATH...
- Kirti
#!/bin/ksh
# -- bdfg
COUNT=0
bdfit () {
if [ -z "$SIZE" ] ; then
LVOL2=$LVOL
((COUNT=1))
else
if [ "$COUNT" -eq "1" ] ; then
echo $LVOL2 $LVOL $SIZE $USED $F
Hi.
I just wanted to plug the use of auditing.
By simply enabling audit session, I detemined that users that were accessing a database via a vpn connection were being timed out (LOGOFF BY CLEANUP). It wasn't the application that was causing the apparent hangs, it was the network. How bout that?
The
I don't know if it will be available on your platform but have you tried
using fold to see of that affects your script. I didn't think line
wrapping was an issue with a script, so it seems to be a bug in bdf. have
you tried just df
Cheers
--
=
Hamid
You might consider creating a table in Oracle that will list all days and
whether it is a business day or not. Eventually you can create a screen so a
user can take responsibility for keeping that table corrected, since for
many businesses there are slight differences in the holiday schedu
and I ended up here:
http://oraperf.veritas.com/index.html
Hmm. so now Veritas has the statspack reports that I uploaded previously.
I don't know what to think.
Maybe they'll see the source code, and the sales staff will think - "too far gone for any of our utils" and leave me alone?
Pd
Do
Hello,
I upgraded to 9.2.0.3 so that I can use the order by in xmlagg but now most of my
queries aren't formated nicely...
Any Ideas?
Thanks
Jake
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jake Johnson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
The fellow who presented from Oracle Sept 23 NYOUG said to the effect
"The RBO is not considered to be desupported of deprecated ... its GONE-
bye, bye dead. It dosnt exist anymore in 10g"
That's what I heard.
Bob
-Original Message-
Sent: Tuesday, October 07, 2003 6:20 PM
To: Multiple rec
For right now, I am unable to comment on anything 10g.
Thanks for understanding!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/7/2003 3:44 PM
Nope. Mr Freeman are you out there??
Also, Jonathan Lewis is a commentary author for this book, so he may
some in
Not so on my instance.
SQL> select sum(bytes) from v$sgastat
2 where pool='shared pool';
SUM(BYTES)
--
251658240
SQL> show parameter shared_pool
NAME TYPEVALUE
---
--
<< And Jared yells at ME for going Off topic!!! :-D
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/7/2003 4:54 PM
Unfortunately it's not my ability to see into the future, but an
inability
to see all of the past.
Now what was that I was looking for?
At 03:34
Actually, something must be wrong with my feed. There are several gaps in
the messages judging from the quoted original, which I never saw, in a
response.
At 03:24 PM 10/7/2003, you wrote:
I'm using Method R to post.
On Tue, 2003-10-07 at 15:04, Wolfgang Breitling wrote:
> A totally different po
List please try out the following :
1. select sum(bytes) from v$sgastat where pool='shared pool';
2. find out the size of the shared pool you have specified in your
parameter files.
3. subtract the two values
4. When I do the same as above the difference is exactly equal to my
db_cache_size.
Unfortunately it's not my ability to see into the future, but an inability
to see all of the past.
Now what was that I was looking for?
At 03:34 PM 10/7/2003, you wrote:
Wolfgang,
Tuesday, October 7, 2003, 2:04:24 PM, you wrote:
W> A totally different point: How come I see your response before
Oracle10g New Features is coming to a book store near you soon!!
he he he
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/7/2003 4:04 PM
You talkin' to me? I don't see anybody else here, so you must
be takin' to me. (DeNiro in "Taxi Driver")?
On Tue, 2003-10-07
ROTFLMAO
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/7/2003 4:24 PM
I'm using Method R to post.
On Tue, 2003-10-07 at 15:04, Wolfgang Breitling wrote:
> A totally different point: How come I see your response before I see
my own
> post?
>
> At 12:39 PM 1
Wolfgang,
Tuesday, October 7, 2003, 2:04:24 PM, you wrote:
W> A totally different point: How come I see your response before I
W> see my own post?
Sounds like you can see into the future. Would you mind reading the
Wall Street journal and reporting back to us?
-rje
--
Please see the official
It's called "optimization".
Do you really need to see your post? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Wolfgang Breitling
Sent: Tuesday, October 07, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
A totally different point: How come I see your response bef
I'm using Method R to post.
On Tue, 2003-10-07 at 15:04, Wolfgang Breitling wrote:
> A totally different point: How come I see your response before I see my own
> post?
>
> At 12:39 PM 10/7/2003, you wrote:
>
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> ht
Title: RE: Software Download
all links of technet have changed.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an
Yep, sounds familiar. So there you have your biggest hurdle for the
performance project: getting the business to set measurable targets and
prioritize the tasks that need attention. How do you "Work first to reduce
the biggest response time component of a business' most important user
action."
You talkin' to me? I don't see anybody else here, so you must
be takin' to me. (DeNiro in "Taxi Driver")?
On Tue, 2003-10-07 at 16:54, Grabowy, Chris wrote:
> Can we PLEASE stop publishing books
>
> I have like 5 books that I'm dying to read from front to back,
> conference papers, this lis
Can we PLEASE stop publishing books
I have like 5 books that I'm dying to read from front to back,
conference papers, this list...
Argh!!! Stop the madness!!!
-Original Message-
Mladen Gogala
Sent: Monday, October 06, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
I haven
I've been working on websites for the last few years. The working
definition I use as "response time" is the time between when the user
initiates the action (mouse click, hitting enter) and the time the user
can USE the information being returned.
This means that sending back the first few charac
Nope. Mr Freeman are you out there??
Also, Jonathan Lewis is a commentary author for this book, so he may some insight.
But wait, I have some dice at my desk...bingo...it's 8 percent faster. You can quote
me.
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 4:04 PM
I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/)
and found OS/390 -
Title: RE: RE: Cary's Book - new topic
we do. We aren't 24x7, but we are 5 am Monday through 6 pm Saturday with a 48 hour permissible window IF we declare an emergency and give them 30 days notice if we are going to be down outside of the regular hours (i.e. upgrades... )
April Wells
Oracle
Bit old but
http://www.pro-dba.com/oracle_10i.html
HTH
GovindanK
<-Original Message->
From: Cunningham, Gerald;Cunningham, GeraldSent: 10/7/2003 12:11:25 PMTo: [EMAIL PROTECTED]Subject: RE: Desupport of RBO The way I read it is that you can still use it, it's just not off
Now that you mention it, I may have forgotten to drop XMLCONCAT first.
The pool sizes were fine.
I'll try the next upgrade (that I can spend extra time on) without dropping xmlconcat
and see what happens.
Thanks,
Jared
Stefan Jahnke <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/07/
did he mention any benchmarked performance improvements from gathering statistics on
the system tablespacE?
>
> From: "Grabowy, Chris" <[EMAIL PROTECTED]>
> Date: 2003/10/07 Tue PM 03:34:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Desupport of RBO
>
> At
On Tue, 2003-10-07 at 14:39, Orr, Steve wrote:
> So to define response time you must first define "response?"
Response time is best illustrated in the "Man in Black" movie,
when agent Kay tells to agent Jay not to ever press that button
(scene in the car). That response time was probably tuned by
Sorry for the delay ...
Was at Ottawa Oracle User Group Days last week and spent the time since then playing
catch-up
Yes, we are using OS/390 v10.
I STRONGLY suspect the SYSADMIN is wrong.
There HAS to be swapping / paging going on, but he insists this is not the case.
Babette Turner-Underwo
Unlike
IOUG, if I remember correctly, OracleWorld's presentations were publicly
available via their website on the first or was it the second day of the
conference.
I
could not make it to the conference, but I was watching some of the keynotes and
reading over their presentations during t
Thank you for your answer. My question was more along the lines "why doesn't kill
session use audsid?" Mr. Kangaraj provided the answer that audsid is 0 for some
sessions, or, in older databases, when AUDIT_TRAIL is not TRUE.
My question would then be: why doesn't auditing use SID/SERIAL# instead
Title: RE: Desupport of RBO
At the
recent NYOUG conference, they were handing out special preview copies of Oracle
10g New Features by our very own Robert Freeman
Page
11 has a section entitled...Collecting Data Dictionary Statistics...this is done
using the DBMS_STATS.GATHER_DICTIONAR
how many projects actually have SLAs? Ive been on 5 projects and none of them have had
them. Its always been.
Customer: 'It's Slow'
Me: What is?
Customer: The application. Make it fast.
Me: Define fast.
Customer: As fast as possible. Do it now.
>
> From: Wolfgang Breitling <[EMAIL PROTECTED]>
Now that the response quality was mentioned, the intimately related
topic is the quality of the application itself. I frequently indulge
myself into observing things like usability:
- Are buttons in the applications created naturally, easy to press
and with good logical explanations?
- Are fields
If you are mentioning 9i download database then look at
http://otn.oracle.com/software/index.html
If it is about 9i papers which were presented during [EMAIL PROTECTED] then click on database,
Application servers etc, scroll down and you will have 9i related articles along with download link.
Title: RE: Desupport of RBO
in 10g, you can analyze sys (9i too, but don't know if anyone actually
does it) as well as fixed tables ... though frequent fixed table analysis is not
recommended.
Raj
Rajendra dot
Here is what you are asking for
http://otn.oracle.com/ow2003/content.html
HTH
GovindanK
<-Original Message->
From: Post, Ethan;Post, EthanSent: 10/7/2003 11:56:25 AMTo: [EMAIL PROTECTED]Subject: Re: Openworld Papers Been off the list for a few days, anyone know if the papers fr
The way I read it is that you can still use it, it's just not officially
supported. i.e. If you call up Oracle Support and say my query (SELECT
/*+RULE */ blah blah blah...) crashes the database, they will say
"Sorry, you're out of luck" or "Switch to cost-based".
Some apps (e.g. Siebel) still rel
didnt they change it to CBO in 9.0.2? Or is that only in 10g?
>
> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> Date: 2003/10/07 Tue PM 02:59:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Desupport of RBO
>
> We had issues here with first_rows and all_row
Well I found the Openworld papers on technet but now I can't find the
software download page for Oracle 9 software, have they removed it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 h
Title: RE: Desupport of RBO
We had
issues here with first_rows and all_rows when set in init.ora for 8i a couple of
years ago... performance dropped significantly. During
discussions with Oracle Support I learned that the data dictionary for 8i has to
run in rule mode, I don't know if the
A totally different point: How come I see your response before I see my own
post?
At 12:39 PM 10/7/2003, you wrote:
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wo
Good point. I suppose this gets into the realm of "perceived response
time". Some applications break long transactions into several user
interactions to hide the real response time. The application still makes
its SLA defined as "90% of transactions complete in < 3 seconds" while the
real trans
YOu could wite a couple of PL/SQL functions...here is some skeleton code.
one to test for Saturday and SUnday and another to check for holidays.
DECLARE vNextBizDay DATE
vNextBizDay := sysdate + 1
Pass vNextBizDay to a SatSun Function test
-SatSun Function
test VNextBizDay a
Been off the list for a few days, anyone know if the papers from Openworld
have been posted anyplace?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Cal
Here is part of an email I was forwarded from an IBM rep making the argument
for 64 bit. Anyone know anything about the JFS2 filesystem? The parts of
the text below that applied to Oracle 64 bit were originally highlighted in
blue but this was lost in the forward. You will have to sift the things
i dont think they are totally removing the RBO from 10g. Ive seen conflicting reports.
I think tom kyte hinted that it is gone, then I read somewhere else that its still
going to be there.
RBO is necessary if you use layered complex views. CBO often times doesnt hold up. Its
a pretty bad desig
So to define response time you must first define "response?" For
acceptance criteria I guess the user has to be specific about what a
response is, e.g., when a web app returns a database large result set to
a web page, if you have to wait until they entire result set is
transmitted to the client th
Note that the foofoofoo volume causes the disk info to show up on the
following line. A script I have that loops through each line coming back
from bdf is breaking because of this. Any simple way to bring the line back
up to the Filesystem line using awk, sed etc...?
bdf -l
Filesystem
List,
any body know any module or reference to get the next business day including
holidays etc.
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fa
Title: RE: Desupport of RBO
10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
>\<
\
>\<
I've got Cary's book for about a week now and I have a comment. On page 12
he defines response time as
"The elapsed time between the end of an inquiry or demand on a computer
system and the beginning of a response; for example, the length of the time
between an indication of the end of an inqui
OK, dumb question. Does this mean the rule hint won't be possible?
Application I support mostly uses CBO but there have been cases where we had to
resort to RBO hint. 'course it'll be some time before we can consider v10...
Kip
|Hi Jared,
|haven't seen it, too. But the fact
|was spreaded over
LOL ;)
-Mensaje original-
De: Mladen Gogala [mailto:[EMAIL PROTECTED]
Enviado el: martes, 07 de octubre de 2003 9:59
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Can I execute an exe from a stored Procedure
No problem! Just open any email entitled "Latest security patch from
MI
In my environment, I am constantly have to update/create test and
development databases,
and for the time being I am recreating both instances.
When I recreate the controlfile, all the redo logs are assigned to one
instance (thread 1).
Is there a way to re-assign some of them to the second thread
Jeff - Sorry, too many issues flying here lately, not reading carefully.
Myself, I would be reluctant to convert the system tablespace. The
possibilities would keep me awake at night, already got enough of that.
Ideally (in my mind), you will have the opportunity to move to 9i or 10i by
export/impo
Hans,
AFAIK, kproc is the slave process for AIO. How many do you see on your
system? Maybe you have too many of them and are choking on CPU scheduling...
Is your CPU stats Ok at this time? You need to have only as many AIO proces
as there are *simultaneous* requests 300 maybe overkill.
Long t
Personally I agree w/ Dennis, If it works, don't mess w/ it. I am
moving to LMT & Undo TBS when I upgrade to 9i from 8i.
Gene>>> [EMAIL PROTECTED] 10/07/03 10:29AM
>>>Thomas To me, the main benefits are in
manageability. I feel in mostcircumstances the performance benefits will be
small.
Hi there,
I'm trying to change my database (Oracle 8.1.7) character set from
WE8ISO8895P1 to WE8ISO8895P15. I would have thought this was possible
but I get this message:
ORA-12712: new character set must be a superset of old character set
The reason I'm doing this is to allow the use of the Eu
Yes. Table is being replicated while you were trying to drop it.
Before dropping it, you should take care that it's no longer replicated.
On Tue, 2003-10-07 at 12:04, Oracle DBA wrote:
> Hi List,
>
> Coudl someone help me to resolve this issue?
>
> SQL> drop table TABLE1;
> drop table TABLE1
>
Hi List,
Coudl someone help me to resolve this issue?
SQL> drop table TABLE1;
drop table TABLE1
*
ERROR at line 1:
ORA-26500: error on caching "USER1"."TABLE1"
Thanks
Sami
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http:/
Thanks for the reply Dennis.I don't think my question was very clear -- I
was specifically asking about the SYSTEM tablespace only -- whether it was
worth the effort to convert it to LMT.
-Original Message-
Sent: Tuesday, October 07, 2003 9:29 AM
To: Multiple recipients of list ORA
Hi All,
We suffer buffer busy waits and io done waits during batch processing. The
batch does direct-path inserts (via Sqlloader and insert-append) in a 16k
blocksize database (JFS, AIX).
Async io servers = 300, maxreqs = 16384
What is the general approach to tune the "io done' wait event? The
Check the Oracle Software Investment Guide at
http://www.oracle.com/corporate/pricing/index.html?sig.html
Hemant
At 06:44 AM 07-10-03 -0800, you wrote:
Help! We
are in the middle of an Oracle licencing audit fight and there is
confusion about what (if any) additional licences we need to
buy.
Cu
Sure u can and without oppenning a email from microsoft
-Mensagem original-
De: Mladen Gogala [mailto:[EMAIL PROTECTED]
Enviada: terça-feira, 7 de Outubro de 2003 14:59
Para: Multiple recipients of list ORACLE-L
Assunto: Re: Can I execute an exe from a stored Procedure
No problem! Just
> How to compress(gunzip format) while doing export
> itself? I know i have to use PIPE but somehow i
> couldn't succeed.
(umask 077 ; mknod gz_pipe p)
gzip -c myfile.dmp.gz &
exp [user] file=gz_pipe ...
--
My employers like me, but not enough to let me speak for them.
Greg Norris
Sprint LTD D
Sami,
A short explanation for gzip in Unix environment (probably the same for
gunzip)
Export
--
set expfile= ...
set logfile= ...
set Pipefile=/tmp/exp_pipe1
mknod $Pipefile p
cat $Pipefile | gzip -c1 > $expfile &
exp user/password file=$Pipefile log=$logfile ...
\rm -f $Pipefile
##
Title: Message
Kevin,
We
just went thru a similar review. Something that the sales rep said made
sense:
If you
buy the product and do not do any customizations of the 11i database which
supports the product, then there is no additional charge.
If,
however, you customize the produc
mknod expdat.dmp p
exp system/manager full=yes direct=yes log=/dev/console &
dd if=expdat.dmp|bzip2|dd of=/dir/full_exp.dmp.bz2
Your sysadmin will love you, especially if your database has many
objects, shoewing up in the log file.
On Tue, 2003-10-07 at 10:44, Oracle DBA wrote:
> Hi List,
>
> H
# Create a Unix named pipe
mknod /tmp/exp_pipe p
# Start Compress through the pipe
compress < /tmp/exp_pipe > $dmpfile.Z &
# Perform the export
exp / full=y file=/tmp/exp_pipe log=$logfile consistent=y
direct=y recordlength=65535
-Original Message-
Sent:
Title: Message
LOGIC would dictate that, because the database that ships with the 11i
installation CDs comes configured that way, and you have 11i licensed, you
should be okay... in fact if you DON'T leave it alone you are probably going to
be unsupported.
April Wells Oracle DBA/Oracle Apps
Hi List,
How to compress(gunzip format) while doing export
itself? I know i have to use PIPE but somehow i
couldn't succeed.
Any help would be appreciated.
Thanks
Sami
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yaho
Title: Message
Help! We are in the
middle of an Oracle licencing audit fight and there is confusion about what (if
any) additional licences we need to buy.
Currently we have 85
concurrent licences for 11i and the database. The problem is that two of the 11i
options require and use partitio
Thomas
To me, the main benefits are in manageability. I feel in most
circumstances the performance benefits will be small.
As an approach, I have created all new tables in LMT with uniform extents
over the last several years. I have moved tables that grow steadily to LMT.
I have left a lot o
I've just visited their page. No problems whatsoever. Can you stand on
your toes and extend that arm a little bit more?
On Tue, 2003-10-07 at 09:49, Martin, Alan (Contractor) (DLIS) wrote:
> Can someone try reaching this site. I keep getting "cannot reach
> server" for almost a week. I hope they a
Manoj
Do you own Moore's book? If so, do you consider the book worthwhile? You
may have seen the discussion yesterday where some people were discouraged
because some of the topics listed on the book's Web site seem well covered
elsewhere. But I haven't heard from anyone who actually owns the boo
Title: Message
it's
working for me... tried clearing your cache? can you ping
it?
-Original Message-From: Martin, Alan
(Contractor) (DLIS) [mailto:[EMAIL PROTECTED] Sent: Tuesday,
October 07, 2003 9:49 AMTo: Multiple recipients of list
ORACLE-LSubject: Cannot reach serve
I hit it first try.
--- "Martin, Alan (Contractor) (DLIS)" <[EMAIL PROTECTED]> wrote:
> Can someone try reaching this site. I keep getting "cannot reach
> server" for
> almost a week. I hope they are still in business. Perhaps the
> popularity of
> Cary's book killed their server:)
>
> Has a
Alan,
I got through to the site okay but Gary's book is out-of-stock.
Check the proxie parameters on your browser. Has something changed in
the firewall?
Rom
>>> [EMAIL PROTECTED] 10/07/03 09:49AM >>>
Can someone try reaching this site. I keep getting "cannot reach
server" for
almost a week. I ho
Here is Tom Kyte's answer to my question. Sort of expected answer,
correct but not evry useful or explanatory.
Mladen -- Thanks for the question regarding "$ORACLE_HOME/bin/kgmgr",
version 9.2.0.4
You Asked
What is $ORACLE_H
1 - 100 of 115 matches
Mail list logo
