This response from Oracle is not a good one. Kirti is on the right track
regarding the SCN stuff as far as I remember. Other than that, I know
that Peter Gram and Bjorn Engsig (among a lot of other guys) might be
able to suggest something, so I've CC'ed them.
I have my own law on ora-600s: If
Mogens I do agree that this ora-600 [2662] is in the code that handle
SCN numbers, since SCN handling is used
many places in the code the stack trace that show which path throw the
code you took is necessary if there
is no hits on metalink fits the problem ;-)
Mogens Nørgaard wrote:
This
As I understand, this hidden parameter is for the whole database.
In my case It's just for a few tables (I don't care about recovery of these
tables).
Thank you !
Best Regards
Kamel Benlatreche
-Message d'origine-
De : mantfield [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 6 janvier 2003
And apart from the differences in cost on the
simple test, you also remove the information
about uniqueness and non-nullability if you don't
declare the primary key, and this has an impact
on the optimizer's decision tree.
Bear in mind, also, that Oracle will rarely do a
tablescan on the inner
As others have pointed out, the need to cache
a large table should always be questioned carefully.
Having said that, your best bet is probably to create
a KEEP pool (parameter db_buffer_pool_keep in 8.1,
db_keep_cache_size in 9), and assign the table to
the KEEP pool in its STORAGE declaration.
I have a question from my SysAdmin/Storage guys.
How can an Oracle 9iRAC database run on a SAN ?
A SAN supposedly allows only one node to access
a disk. Can multiple nodes in a 9iRAC cluster
access database files on a SAN ?
We can understand a dual-hosted (or is it
dual-ported ?) Storage which
Many thanks to all who replied !
-Original Message-
Sent: ? 06 ? 2003 22:00
To: Multiple recipients of list ORACLE-L
Audrey,
Are these direct connections or coming through JVM or some other middle tier
server where the userid cannot be discerned.
You can use the audit statement
In that case, you are pretty much SOL, sorry. nologging option of tables
only applies to direct path operations:
create as select
direct path Sql*Loader
insert /*+ APPEND */
Other than that, all other DML will get logged in the redo log, and as
several have pointed out, using the
Thanks a lot to all who replied!
-Original Message-
Sent: ? 07 ? 2003 6:01
To: [EMAIL PROTECTED]; Andrey Bronfin
Andre,
Oracle does not send passwords across the network
in clear text, they are encrypted by default.
Jared
On Monday 06 January 2003 05:43, Andrey Bronfin wrote:
Wow, the OT list is still running...
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO |
A Relationship manager needs to broadcast mail to all the Customers .
There are around 102,847 customer
To achieve this functionality in our code we are opening a cursor, fetching each
user id from a table and inserting into a mail table for each fetch.
Mail is getting Generated for only 7130
Hallo,
I have this sql,
SELECT * FROM varukorgtmp
where varukorgid= 120 That makes the result of this testfile.xls
(See attached file: start.xls)
There are two values in EAN-field, which are the same
23324614 in row 2 and 3
Now I want in an sql script to check out which are the duplicates of
Ferenc,
There's this new FREE product on the Metalink site. It's called ORA-600
Lookup (I don't bother to bookmark it, just do a search on that and the
first one in the search list is the link to the product). You put in
the version number, the first argument on the ora-600 and then, if
there is
Title: RE: MAX Number of Records in Cursor ?
Possibly the some exception is being generated and (possibly) ignored? My best guess it the script bombs at some point and no one knows why ...
Remove any exception handlers in the script and re-run.
Raj
List,I am a newbie on Linux and Clustering technology, I need to setup a RAC system and have been reading somedocumentation on how to do it. I am a bit confuse about the difference between setting the disk up with Linux raw partition and Oracle cluster file system, I hope someone on the list can
oh yeah, we're alive and kicking. All the *interesting* people are
there :)
(this should give me a run on people to approve for subscription as no
one wants to be thought of as uninteresting G)
--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
Wow, the OT list is still running...
Patrice
There are no limits on the number of rows which can be
retrieved. Please check the query and the application code
surrounding it more closely.
I'd suggest extracting the query into SQL*Plus and running
it there. If the behavior is as expected, then the
surrounding application code is at fault.
wow, that was stupid of me !!
UNIX System Administration Handbook (3rd Edition)
by Evi Nemeth, Garth Snyder, Scott Seebass, Trent R. Hein
Unix for Oracle DBAs Pocket Reference
by Donald K. Burleson
(I copied the ISBN from Amazon).
Regards,
Stefan
--
Please see the official ORACLE-L FAQ:
I read it and love it. The only thing I was wondering about is the fact,
that he uses tcl/tk, which I found most people don't use anymore. Nice
surprise.
I wasn't quite sure wether oraora was looking for books that gives more of a
general overview of books that delve into the depth of unix
Yes. This is also a very good book. I own an older version for Oracle 8.0.x,
but I remember it to be pretty well written and concise.
Another remark on Unix books for Oracle DBAs: My company got a copy of
Oracle 9i Unix Adminstration Handbook by Don Burleson. It starts at the very
beginnings of
Besides, Vivek, have you ever heard about INSERT ... SELECT ? Why, I ask, do you want
to loop ?
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 07 Jan 2003 05:54:17
There are no limits on the number of rows which can
be
That I know of, there's no limit to the number of rows fetched by a
cursor. I've certainly returned more rows than that.
Have you tried the sql statement in SQL*Plus? I know I advocate this a
lot, but it does tell you if the problem is the sql itself. Are you
SURE there are over 100K customers to
Mogens,
You meant K. Gopal (aka X$KG) is on the right track... and not Kirti. ;)
I do not recall posting in this thread.
- Kirti
-Original Message-
Sent: Tuesday, January 07, 2003 1:59 AM
To: Multiple recipients of list ORACLE-L
This response from Oracle is not a good one. Kirti
All oracle passwords are encrypted is not a true statement. Failed login
attempts, are retried by sending the password in an unencrypted format.
Atleast, until 8.1.7. To avoid which, ORA_ENCRYPT_LOGIN variable and
DBLINK_ENCRYPT_LOGIN parameter (for retried attempts across database link)
should
The 9iRAC interconnect which comes with the product is specific to the
hardware platform and manages the connectivity failover in concert with the
cluster software.
Regards,
Bill Burke
The Kinder and Gentler DBA
IOUG University Master Class Faculty 2001 2002
iDBA Management, Infrastructure and
Here is another product that goes after ORA-600:
http://www.ubTools.com/cgi-bin/ib/ikonboard.cgi?act=Pages;page=iorabugfinder
The creator, Danisment Unal, used to be on the list.
- Kirti
-Original Message-
Sent: Tuesday, January 07, 2003 7:34 AM
To: Multiple recipients of list
For those of you that enjoyed Exam Cram, I received the following newsletter
and thought I would pass it along.
Dear Exam Cram member,
We're back, and better than ever! The Exam Cram site you
used to know and love is now Exam Cram 2
(http://www.examcram2.com), produced by a joint effort
between
Hi,
following metalink documents may help you.
Note:65080.1 Using SQL To Delete Duplicate Rows In A Table
PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID
PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE
Murat
A couple of other thoughts depending on the size of the table with the large
number of foreign keys (I may have missed the exact row counts), you might
want to consider bitmaps on the foreign keys in the main table depending on
the uniqueness of the data. Also, if the foreign key tables are
Are you dead ?!
-Ursprüngliche Nachricht-
Von: mantfield [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 7. Januar 2003 02:59
An: Multiple recipients of list ORACLE-L
Betreff: True inner peace
By following the simple advice I read in an article, I have finally found
inner peace...
It
In addition to all the books already mentioned, I find following reference useful when
dealing with multiple flavours of UNIX..
http://bhami.com/rosetta.html
- Kirti
-Original Message-
Sent: Tuesday, January 07, 2003 7:59 AM
To: Multiple recipients of list ORACLE-L
wow, that was
in case this is a windog machine - install kind of unix shell. and the unix style
commands work perfectly - just tried it. either use unix tools for windog or cygwin
from rh.
or dump the w...
have fun.
[EMAIL PROTECTED] 01/03/03 18:40 PM
Hi everyone,
This may be a stupid question. If so
If this is a one time DML activity, one may get creative with TTS and this hidden
parameter :)
- Kirti
-Original Message-
Sent: Tuesday, January 07, 2003 4:39 AM
To: Multiple recipients of list ORACLE-L
In that case, you are pretty much SOL, sorry. nologging option of tables
only
Pro: It is in memory
Con: You must buy the memory. You must be sure you don't cause the box to
start paging to swap ... very bad ... VERY bad.
When you live in the land of bad applications, sometimes the politics of the
situation are such that you just do what you know is the equivalent of
Thanks to all for the advice..
Ps I am an Oz type living in Canada - just flew here at xmas and yes it aint
cheap but ooh airline food is great!
CIAO
-Original Message-
Sent: Monday, January 06, 2003 10:29 PM
To: Multiple recipients of list ORACLE-L
I'm flattered you put me in the same
Don's book is very good. Highly recommend.
RF
--- Stefan Jahnke [EMAIL PROTECTED] wrote:
wow, that was stupid of me !!
UNIX System Administration Handbook (3rd Edition)
by Evi Nemeth, Garth Snyder, Scott Seebass, Trent R.
Hein
Unix for Oracle DBAs Pocket Reference
by Donald K. Burleson
Hi there
Trying to email out from Oracle.
Utl_smtp is installed, executing procedure currently as a DBA. This sun
Machine does send email notifications out via the crontab to me so I know I
can send email via the exchange smtp server.
Problem, Email packages execute, if I do a print I see code
Black Adder is an excellent method to get me to shut up and leave!
-Original Message-
Sent: Monday, January 06, 2003 8:29 PM
To: Multiple recipients of list ORACLE-L
I'm flattered you put me in the same category as Kirti, Dan, Jared,
Connor and Jonathan.
If I recall the cost of my
Hi
How to avoid FULL TABLE SCAN?
Thx
-seema
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema
Title: RE: Database/system Crashing
Well I relocated the background dest files and I got the
following error... that was a great idea!
ORA-00206: error in writing (block 3, # blocks 1) of
controlfileORA-00202: controlfile:
'/u04/oradata/ERCS/ora_control2'ORA-27063: Message 27063 not found;
Mogens:
Yes. You are right. You have to bump the SCNs globally
(i.e. across all data files to higher number, say 1 Billion)
using the event 10015 and ADJUST_SCN. Then we can safely
open the database and rebuild that.
KG
Best Regards,
K Gopalakrishnan
-Original Message-
Norgaard
Gregory,
There are several things to consider since you are still at the
design phase. This table sounds like a great candidate for denormalization.
Is this an OLTP or OLAP system? How static are the values in the reftables?
If the reftables are static and contain very few values, consider
$ oerr ora 29540
29540, 0, class %s does not exist
// *Cause: Java method execution failed to find a class with the indicated
name.
// *Action: Correct the name or add the missing Java class.
Looks like you are missing some Java Class... Do you actually get the email
it sends?
Also if you
Hallo,
I have this sql,
SELECT * FROM varukorgtmp
where varukorgid= 120 That makes the result of this testfile.xls
(See attached file: start.xls)
There are two values in EAN-field, which are the same
23324614 in row 2 and 3
Now I want in an sql script to check out which are the duplicates
okay fine, Talisker then :)
--- Fink, Dan [EMAIL PROTECTED] wrote:
Black Adder is an excellent method to get me to shut up and leave!
-Original Message-
Sent: Monday, January 06, 2003 8:29 PM
To: Multiple recipients of list ORACLE-L
I'm flattered you put me in the same
Jos,
Yes,
you are right that if you use OCFS then you can just have one mount point and
create all
data
files under it, because OCFS is a file system. It makes it a lot easier to
manage space
and
you can use commands like: cp, mv, rm etc which you can't do to a raw
partition.
Backup
on
Title: RE: FULL TABLE SCAN?
_full_table_scan=FALSE
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: FULL TABLE SCAN?
Hi
How to avoid FULL TABLE SCAN?
Thx
-seema
Title: RE: Database/system Crashing
Got the same error on NT last week.
Check if there are system backups that backup the control
files.
When Veritas backup the control file as a regular file the
database can not write to it and you get this message.
Yechiel AdarMehish
- Original
Title: RE: Database/system Crashing
Val,
Have you tried copying a known good controlfile in place of
the bad one? If not, try it and report the result. If it corrupts as well, it
seems to me that there is a much bigger problem. If it does not corrupt, then
the question is, why didn't oracle
Title: RE: Caching a huge table's data in memory
I don't think a cache table is actually pinned in memory. It just means
that its blocks stick around once they are read and are not recycled as
much as normal tables. That having been said, due diligence should be
taken to tune the queries and
Our developers sent me a function which is running quite long to see if I
could give them any advice. It is written in PL/SQL for version 9.2.0.1
of Oracle on Sun Solaris. It is going across a database link. It reads
tables in one database and loads a new table in a datamart table on another
1. Set optimizer_mode to RULE.
2. Make sure all statements have a WHERE clause.
3. Dont use functions in the equality clauses.
4. Create an index on each and every column you have in the database.
Take my advice. I dont use it anyway :)))
Raj
At great personal risk, I will tell you some secrets.
There are many options.
1) Don't query data. To really enforce this, remove select, insert, update
and delete privileges from all users.
2) If you must query data, use an index and only an index. Create indexes
that cover all possible
I also got this e-mal. I could not find anything on 9i just 8i. So, they
have some catching up to do.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 9:08 AM
For those of you that enjoyed Exam Cram, I
Title: RE: FULL TABLE SCAN?
A Where clause in your SQL and indexes that support the Where clause are a good place to start.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Hi
Create a meaningful index and keep your stats up to date.
Dave
The OT list rules
-Original Message-
Sent: Tuesday, January 07, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Hi
How to avoid FULL TABLE SCAN?
Thx
-seema
Hello All
I seem to be missing something very basic as no matter what I do
I cant get statspack to install
This is 8.16 on WIN2kpro
I downloaded the newest version of stataspack and placed it into
%oracle_home%\rdbms\admin
C:\Oracle\Ora81\RDBMS\ADMINdir stats*
02/08/2000 07:36p
Seema:
Use an index, obviously. If and index exists, ensure that the query uses
it. The select columns order should match the order of the index columns.
Or try using a HINT.
Sometimes a full scan is not a bad thing. Are there less than 100,000 rows
in the table? Sometimes the optimizer will
I have never delved into just what gets cache and how permanently it gets
cached when a table is cached. In the case of a monstrosity of an
application, to cache or not to cache (that is the question) a large table,
is a case of tweedle-dee and tweedle-dum. But when people are grabbing at
any
Title: RE: Caching a huge table's data in memory
Read
Cary Millsap's papers on Misunderstandings about Oracle Internals at his site www.hotsos.com. They are
excellent!
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 9:54
AMTo:
Cherie,
If network bandwidth is the bottleneck, the use of Fast Refreshable
snapshots will be a great help. Whereby you only pull the rows that have
changed since the last refresh across to the primary.
Raj
Hey all,
I have a trigger that pins various packages on the startup of our 8.1.7.2.0
DB on HP/UX 11.0. I check V$DB_OBJECT_CACHE every so often to see that it's
working and to make any necessary additions/deletions from the list of
pinned packages.
However, the SYS.DBMS_APPLICATION_INFO package
Looks like they are still starting up the new incarnation, the Oracle books
are about the Oracle 8 exams.
I don't understand what happened to Coriolis before, why did it close down?
Not enough sales?
In this area the computer books sections are shrinking in the bookstores, I
suspect people are
I had some problems with stats pack install today.
There is: 'on error exit' in the scripts. Remove it so the script can
continue. This may solved your problem.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07,
Bob,
The scripts contain CONNECT statements which likely do not
include the @instance TNS connect-string you are using
initially. The scripts also contain WHENEVER OSERROR and
WHENEVER SQLERROR directives, so they blow out of SQL*Plus
on error, most likely...
Please consider editing the scripts
I think that you can try 2 things:
1) Run the function in the source db. Selects across links does funny stuff.
2) Write CSV file on the source system and sql loader on the target using
direct.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Bob:
I have a slightly different version. My spcreate.sql involkes 3 scripts: @@spcusr,@@spctab,@@spcpkg. The problem that I had was that spcusr was creating some x_ views that already existed in the database(perhaps from Steve Adams' script). When the spcusr script encounters the errors, it quits
I believe, with 8.1.7, Oracle changed the behavior of selects over a
database link so that it is optimized for snapshot (materialized view)
replication. We faced a similar situation and the answer was to copy the
source tables over the db_link and then run the PL/SQL against the copied
tables
Title: RE: Long-running PL/SQL function (long)
Cherie,
I'd run this function with 2 events separately ...
first 10938 this will give you pl/sql profiling or simply use dbms_profiler package. This will tell you where (and at which line) you are spending most of your time. Metalink has some
Hi, Arup:
I created lmt rbs this way:
CREATE TABLESPACE RBS
DATAFILE '/oracle/u02/oradata/YPD/rbs01.dbf' SIZE 2048M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 2M;
and then
SQL create rollback segment RBSTest1 storage(initial 2048K next 2048K)
tablespace rbs;
Rollback segment created.
SQL create
Are you using a ref cursor (from JDBC ) and sertting some arraysize .
Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 5:08 AM
A Relationship manager needs to broadcast mail to all the Customers .
There are around
Bob:
Try running the scripts in the command line version of SQL Plus. In NT use
sqlplus instead of sqlplusw. The statscusr.sql prompts for a couple of
tablespaces.
Start spooling right after logging in and set termout and echo on. You
should capture some output this way.
RWB
Bob Metelsky
Raj,
Thanks for your reply.
This is a one-time-only load to set up a new datamart from our existing
warehouse.We have a separate process which will be doing periodic
refreshes. However, yes, the inserts are going across the network with
the current design.
Cherie
Raj,
Just got this code this morning so I haven't had a chance to run a trace
yet. Will have to schedule that for tonight.
Yes, code is being run on the source DB.
Yes, ACCT_PAY_TYPE is less than 2000 rows. You are the second person who
has recommended a PL/SQL table. I will run a test
Title: RE: FULL TABLE SCAN?
It's a
bit buggy in 8i!
-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003
1:09 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: FULL TABLE SCAN?
Is
that backported to 8i and 7.3 ??? :)
Thanks, but I don't think I'm in the same class as
some of those names. I just keep my head down
and keep trying. :)
Jared
Mark Richard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/06/2003 06:23 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
HOT DAMM!!
Ive taken everyones suggestions and did the following
Edited all the stats* file to change
whenever sqlerror exit;
To
whenever sqlerror continue;
And connect perfstat/perfstat
To
connect perfstat/perfstat@instance
I also ran the script from a cmd window rather than sqlplusw
I
Thanks Raj.
I would think that the default being set to 'always encrypt' would be
more reasonable,
In checking the parameters via
select
a.KSPPINM NAME,
a.KSPPDESC DESCRIPTION,
b.KSPPSTVL VALUE,
b.KSPPSTDF ISDEFAULT
from X$KSPPI a, X$KSPPCV b
where a.indx = b.indx
and a.KSPPINM
Dear,
Since a few weeks I am tuning a big conversion batch written
in PL/SQL (millions of lines of code split over 7 batches)
When the job is running, certain batches stop with ORA-1555: Snapshot too old. Other batches run well till
the end.
Bizarre is that not always the same job
I remember seing a script on Steve Adam's site that will delete the views
created so that STATSPACK can install correctly
Babu
George,
Did you resolve this yet? The error code indicates that you are missing a
Java class. Did you load the ORACLE_HOME/rdbms/initplsj.sql file? this
will load the PL/SQL Java classes needed to send mail.
hope this helps
PS. Uncomment your exception clause in your procedure so that you
What about invalidations? If something invalidates the packages does it
reload?
Just guessing...
I remember this thread and was hoping you would have an answer by now...
Damn...
:-)
-Original Message-
Sent: Tuesday, January 07, 2003 1:18 PM
To: Multiple recipients of list ORACLE-L
Position: SQL Server DBA..the selected candidate will be crossed trained in
Oracle if not experienced.
Location: Philadelphia, Pennslyvania area (Berwyn)
Salary Range: Low-mid 70s base, outstanding benefits, plus 4-6 weeks paid
vacation first year.
*No relocation but a small sign on bonus may
Title: RE: Long-running PL/SQL function (long)
Cherie,
Bulk inserts/selects are available since 8i ...
Not being sarcastic but sorry to disappoint you, but your developers haven't used anything new that wasn't in 8i ... you can give them the bad news .. (if you want.)
I think bulk
Title: RE: Database/system Crashing
Dan,
I meant to say that I found out why Oracle crashed. There
is a bigger problem with the OS since it crashes when the db is down and it
seems to lose parts of itself if that makes sense. After the OS "sorta crashes"
or partially crashes, some Unix
Thanks for the clarification, a lot more to read.
Richard Ji [EMAIL PROTECTED] wrote:
Jos,
Yes, you are right that if you use OCFS then you can just have one mount point and create all
data files under it, because OCFS is a file system. It makes it a lot easier to manage space
and you can use
I get around the connect problem by setting oracle_sid before invoking
sqlplus (no W) from a dos box in NT.
Of course, this means that I work on the server itself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January
Hi All!
Need advice:
We have two Windows 2000 servers with MSCS installed on it.
Now I need to install Oracle9i.
I read about Real Application cluster for 9i and Oracle fail safe:
MSCS will take care about load balancing and failover do I need to instal RAC on top?
Thanks.
Greg.
--
Please see
Title: RE: Database/system Crashing
"PS.. do we all get a virtual
"pass" on a future audit for helping? :)"
ABSOLUTELY!!
;)
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003
3:52 PMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL
Stephane,
Thanks for your reply.
I don't think it's a possibility to get another resource to rewrite the
PL/SQL. Our shop is more java-based and PL/SQL is not our developers
language of choice.
Do you mean to move as many statements inside of the loop to outside of the
loop as possible? If
Jared,
The ORA_ENCRYPT_LOGIN is not a database parameter, but an environment
variable to be set on clients. Maybe Platform specific. Not sure. I have
never used this, just remembered reading about them in some security
document.
Got it. Saved under favourites.
Patrick,
Chasing down the culprit of a randomly happening ORA-1555 can be a true pain
in the ^%%.
First thing to check is if you have a commit happening across a cursor.
This little jewel happens when the duhveloper decided that he needed a cursor to
retrieve some data from a table
Title: RE: Database/system Crashing
Val,
if the
unix commands are disappearing, then it sounds like you are either losing disk
directories, or the paths that point at them.
when I
first read your post last week, I had a sneaky feeling that this was an OS
problem and not an Oracle one. but
Guang,
Which version are you using? I tested this on a 8.1.7.4 system and it works
fine. The only difference is, I didn't supply the INITIAL and NEXT; they are
unnecessary anyway.
create rollback segment arup2
storage(maxextents 4);
select max_extents
from dba_rollback_segs
where segment_name
My 2cts at a contribution
This is what I did to get email working
Your rollback names will vary
1.) Increase the shared_pool_size parameter to at lease 50MB and set the
java_pool_sze parameter to 20MB. Bounce the database.
# increase from 12MB to 50MB
shared_pool_size = 52428800
ORA_ENCRYPT_LOGIN is a sqlnet.ora parameter.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, January 07, 2003 12:11 PM
To: Multiple recipients of list ORACLE-L
Thanks Raj.
I would think that the default being set to 'always
I seem to recall there being a bug in some versions of
Oracle (8i??) where you had to manually load a class
into the database before the utl_smtp would work. Do a
quick search on Metalink and you should be able to
find it.
Robert
--- Leonard, George [EMAIL PROTECTED]
wrote:
Hi there
Trying
Patrick - Do any of these jobs update the same tables? Or do any jobs read a
table that other jobs are updating?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, January 07, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Guang,
It can eat up only the segment it is assigned to, not the whole rbs
tablespace, you will still have other segments.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 2:08 PM
1 - 100 of 144 matches
Mail list logo
