Title: RE: Complex Integrity Checking
Ok
Richard, this seems to be what I want.
I read
carefully the message but I didn't find the trigger
RHUNTLEY.SINTERVAL
How
did you do that?
Thanks!
iulian
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]]Sent: Wednesday,
That is my opinion ..
Jr. learns the methods.
Mid. knows the methods and predicts the results of some.
Sr. had used all of them and knows the results.
Guru seems to know the database internal code.
Bunyamin Karadeniz
- Original Message -
To: Multiple recipients of list ORACLE-L
Thank you all very, very much.
Indeed, ORACLE-L is a great place to share problems and the solution.
Ferenc, can you give the exact syntax of the command please?
Thanks,
Aleem
-Original Message-
Sent: Wednesday, June 05, 2002 3:23 AM
To: Multiple recipients of list ORACLE-L
Oh You may consider all these event triggers on create, on drop etc.
Capture the previous code from data dictionary and store it in some table
This is just an idea, not implemented procedure at least by me
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Ferenc,
This has just crossed my mind and perhaps that after I think harder
I'll find it a foolish idea, but would it be possible to have snapshot
logs (or their home-made equivalents) on all the tables in the view and
building a 'delta view' on top of those logs ?
FM : Stephane, thanks for
Jay, this question was answered yesterday, but for the sake of clarification
:
set _trace_files_public = true in init.ora
HTH.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Please note 17 hour time difference between
_trace_files_public = true
in init.ora
Iain Nicoll
-Original Message-
Sent: Wednesday, June 05, 2002 8:55 PM
To: Multiple recipients of list ORACLE-L
Hi all,
User Trace files are currently created as
-rw-r-
Is there an easy way to change the permissions when they
Hallo,
I have this excelfile. Is it possible to import this into an oracle table. This file
is supposed to be located on unix machine from the beginning and the import into an
oracle table would be done from unix. How should I name the fields in the oracle
table. I mean should I use the 9-10
Because in Excel could be about 65k rows only, the easiest thing to do is
export Excel table as INSERT INTO ... script and run it from sqlplus.
JP
On Thursday 06 June 2002 12:03, you wrote:
Hallo,
I have this excelfile. Is it possible to import this into an oracle table.
This file is
There are some posibilities:
- Make an ORacle - Object program in Excel and insert data into Oracle.
Look at c:\orant\oo4o directory.
- Export data (Save as) from Excel to an csv file and them import into
ORacle using SQLLoader.
(Open file with wordpad).
-Mensaje original-
De: [EMAIL
Hello Roland,
The easiest way is to save it from excel as flat comma-separated text file.
Then you should use Oracle SQL*Loader tool and yes you will have to
pre-create the table with all fields you need. (99,9% that's what you need)
You cannot import .xls file into Oracle database directly
For BACKGROUND_DUMP_DEST , USER_DUMP_DEST , CORE_DUMP_DEST , alert_$SID.log
gave -rwxrwxrwx (chmod 777 ) permissions
All Database Oracle Software files Owned by $ORACLE_OWNER.
oracle Exe having -rwsr-s--x Permissions
Did NOT seem a Permissions Issue
-Original Message-
Sent:
The Original PRoduction m/c has been Formatted
The Few Kernel Values that we had Checked during the Problem :-
nfiles = 790 (Correction)
maxfiles = 200
nproc = 276
nfloc = 200
maxuprc = 200
nofiles = 60
This being a Small HP-UX Box having about 75 User processes including Oracle Shadow
Title: RE: Textfile into oracle
Yes, use Sqlloader...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Textfile into oracle
Hallo,
I have this excelfile. Is it possible
BDY.RTF
Description: RTF file
Title: Oracle 32 Bit running on Solaris 64 Bit
Hi there!
We are running 32-Bit Oracle Software on Sun Solaris 8 (64-Bit).
What is the advantage of doing this?
Why don't we use 64-Bit Orlacle on 64-Bit Solaris?
Nobody here can answer my question and the systems were set up
Hi
Just browsing through the documentation for 9iAS 9.0.2 and I am a bit
surprised.
It looks as though you have to install the so called Infrastructure
(SingleSignOn,
Oracle Internet Directory and a metadata repository) if you want to use
Portal
or Discoverer. If you are just running web apps
Title: How to move 200 GB db from prod to dev?
Hi!
We are supposed to clone our production database onto a new development box (both boxes are Sun Solaris). The db is about 200 GB in size.
What would be the best way to achieve this? Simply copying over the files won't work, since
Could anyone please give me an example on how the sqlloader script would look like ,
How many fields would it be,? I cant find anything ofthis in themanual. I have 100
fields in the excel file but only 9-10 field names...
Thanks in advance
Roland
Alexandre Gorbatchev [EMAIL
Oh yeah,
The dumped controfile script with give you all of the files name s too. Then
just search and replace in a text editor PCLDB1 and ROLAND,
Hope it helps at all,
Hannah
-Original Message-
From: Doran, Johanna
Sent: Thursday, June 06, 2002 11:15 AM
Title: How to move 200 GB db from prod to dev?
Helmut,
Why
can't you simply copy the files and then re-create new control files? This
gives you the option of renaming the database.
Not
sure what your backup procedures are, but you could always restore a backup to
the development box and,
NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no matter what
default i set!
Hi lists,
I am using Quest Shareplex product for Oracle to Oracle one way replication. I
have two systems (source and target) and two environments (dev, demo). On system
one, the
Title: Message
Hi, all!
Thanks for your help and suggestions. Here is
some feedback on what I have found on the performance problem
of the querying data between two databases
using DB links.
To John Kanagaraj: filter by
ROWNUM does not make any difference I have absolutely the same
Title: RE: Complex Integrity Checking
Iulian, here is everything you need to recreate that,
table, package, row level trigger, statement level trigger and test
data.
Once
you've duplicated this, feel free to modify and hopefully you'll be able to do
this for your specific case.
So, why do you need written rules? Are these folks
not talking to each other?
I currently work in a highly proceduralized
environment. Nothing routine gets done in less than
three weeks after being blessed by several layers of
management and a change review committee. This is a
very
Title: How to move 200 GB db from prod to dev?
Search the
Oracle-L archives- this question has been covered several times recently.
Also, Oracle
DBA Tips Techniques by Sumit Sarin (2000, Oracle Press) has detailed
instructions for cloning a database in Chapter 1. Note the error in the
We are preparing to do an upgrade of our Data Warehouse on Sun Solaris from
version 8.0.4.0.0 to 8.1.7.2.
We've done a number of upgrades in the past but this is the first time we
are going from 8.0.4 to 8.1.7.
Following is the basic, high level plan:
1. Upgrade from 8.0.4 to 8.1.7.0 (Oracle
Twice today I've received virus alerts from my mail server. In each case
it appeared that a list member (different members) sent me what appeared to
be a MSoft graphic. I'm not sure if someone is getting the list traffic
and spoofing the id's or what...
I didn't keep the first one since I
Title: RE: Oracle 32 Bit running on Solaris 64 Bit
Is it possible that you have vendor software that doesn't support Oracle 64-bit? Before any decisions are made, I would compile a list of all vendor software on the box and also those used specifically for the application. Then research each
Title: RE: How to move 200 GB db from prod to dev?
Dump the prod control to trace
Copy the db files over to dev
edit the dumped controlfile (you can change db name here)
replace the copied controlfile with the new eidted one and bring up dev
I forget exactly what needs to change in the
Title: How to move 200 GB db from prod to dev?
1) use
RMAN to clone the db; or
2)
create the new dev db with the required users but without all the data/index
tablespaces, and use transportable tablepsace feature to move tablespaces/data
files . . . export/import of meta-data is quick -
Title: Oracle 32 Bit running on Solaris 64 Bit
As far as I am aware there is no advantagein
running 32 s/w on a 64 bit o/s. In fact the reverse is true, there could be
significant disadvantages.
Any impact would be at a very low level and not
noticeable from a user perspective (unless data
Title: How to move 200 GB db from prod to dev?
Helmut,
I have just done it right this
morning. Not that big but worked.
Pasos para Clonar Bases de Datos
1-) Take a cold backup of the Origen DB-
Preferiblemente frio
2-) Take a backup of the controlfile of the
originDB
3-) Copy all
-- Browning, Alan [EMAIL PROTECTED]
Can someone please point me to in the right direction?
We need to establish policies, standard operating procedures,
and responsibilities for our Oracle DBA and Sun Unix Admin.
Is there any literature that outline typical practices on how to divide
Title: How to move 200 GB db from prod to dev?
A few options. Do you use RMAN for backups? , if so
duplicate the database and rename the files as part of that
process.
Otherwise clone the database by copying the files at
the o/s level and change the instance name. Several documents on
SELECT
TO_NUMBER('123,67','999D99', 'NLS_NUMERIC_CHARACTERS='', ''')
FROM dual;
There is empty space after , in ='', ''') .
JP
On Thursday 06 June 2002 16:27, you wrote:
Hi,
I have NLS_NUMERIC_CHARACTERS set to '.,' .
The numeric data appears in the char format 34566,45
How to
Title: Oracle 32 Bit running on Solaris 64 Bit
Seems
to me that patches and upgrades for the 32-Bit versions come out
quicker.One disadvantage of the 32-Bit version is if you require
more than 2Gb of shared memory (SGA for all instances on the box). I've
stuck with the 32-Bit versions
Roland,
If you are saying that you have 100 columns in the spreadsheet but you only
want to copy 9 columns into a table with 9 fields then you have 2 choices.
Reduce the spreadsheet to only 9 columns (by copying to another worksheet)
and then saving as a CSV file and importing by sqlloader. I
I have a similar situation and here's how I deal with it.
(I'm assuming your datafiles have the same name but the pathname is
different)
Production: SID = PROD = e.g.
/zbackup/array3/oracle8/dbs73/PROD/wds01.data.dbf
Development: SID = WDSU = e.g. /extdisk/oracle8/dbs73/PROD/wds01.data.dbf
If your redo log files are normal unix files (i.e. not raw devices
or Veritas quick I/O files, then the first process to read a block
will bring that block into the buffer cache. The second process will
find already in the cache, which might benefit the other guy. I/O
contention seems unlikely.
Title: RE: why so much slower
Tried that
-Original Message-
From: Mike Killough [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 7:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: why so much slower
Why don't you try using a leading or ordered hint to get
Title: Message
Mike,
you
created the view on the db_B machine and called it from db_A,
right?
"To Tom
Mercadante: creating of a view, that does filtering, did not help. Absolutely
the same results!"
Tom Mercadante Oracle Certified Professional
-Original Message-From: Michael
Metalink has a note on best practices on this.
The best method of these in my opinion is to have n
unqiue archive destinations (one per instance). Then
you can NFS cross mount these destinations to the same
location from each instance in your environment. RMAN
can then backup/recover the entire
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think they are alluding to UNIX file system contention. If the redo logs are in regular file systems (not raw, Veritas Quick I/O, etc.) then UNIX (at least in my Solaris environment) needs to lock
Roland,
At the risk of being the extremo de la broma to the OT lot.
The field names that you have specified in the excel file will need to be
deleted anyway. You will need a control file that loads the data in to a
table that has a hundred (100) fields. You will then need to save the excel
file
Title: Oracle 32 Bit running on Solaris 64 Bit
Have
to go to Uncle Larry and ask him why they can't get there softwarerunning
in 64bit. Oracle Appsonlyavailable 32 Bit. We had the
same questions as well. I guess Apps 11i has so many problems and issues
they don't have time to get a 64 Bit
Hi list,
Scenario OPS, 2 nodes, 8.1.7, AIX using raw
devices, EMC box.
I am new in OPS and have to implement archiving
in an OPS environment and configure RMAN to use with LEGATO.
My question is how to organize the
archives. What will happen if one of the nodes goes down ?
I think that
Title: Message
Tom,
I
tried both ways:
-
creating the view on db_B and query it from db_A
-
creating view of db_A using link to db_B
No
difference.
Michael Rosenblum,
Dulcian Inc.
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday,
http://www.dbdomain.com/a120197.htm
it's down near the end of the article, but they talk about a deadlock
with no rows and say it appears to be a problem with the initrans or
pctfree setting on that table
--- Walter K [EMAIL PROTECTED] wrote:
We have an application that is periodically
Title: duplexing the archive redo log directory
Anybody encountered any bugs relating to
the
LOG_ARCHIVE_DUPLEX_DEST and
LOG_ARCHIVE_MIN_SUCCEED_DEST parameters
in 8.1.6 or 8.1.7?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user
Hmmm...but with all the problems we've been having with OiD and replication
(BUG 2369181 was opened for us), I don't forsee us being able to use it.
Interestingly enough, my co-worker has been able to get Oracle to use
iPlanet and OpenLDAP for names resolution. It's a bit of a hack, since
Title: Message
just
checking. I've had good luck with the view existing on the db_B
machine.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Michael Rosenblum
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 2:24
PMTo: Multiple recipients of list
Title: Message
Okay
guys,
We are using OS
striping. However, for reasons of partition elimination, etc. I broke
up 80 years of data into separate years. Now one of the tablespaces is
being hit 70% of the time. Given OS striping and that I can't really
Matt,
Do not alter the LOG_ARCHIVE_DUPLEX_DEST parameter online. Altering a
parameter that uses a / in its value will cause problems doing selects on
v$parameter table see document 136791.1. I ran into this issue and had to
bounce both instances to resolve the issue.
Bryan
-Original
Has anyone got this working using secure id authentication for logging into
DB? If so, I'd like to hear from you.
TIA
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
First of all,
Tks to all the reply about this topic 3 weeks
ago.
Trying to clone a DB I am getting an
ORA-01503 CREATE CONTROLFILE failed
ORA-01159 file is not from same database as
previous files
ORA-01110 data file 7:
'C:\ORACLE\ORADATA\VTAS\DATOS'
TIA
Ramon E. Estevez[EMAIL
Walter,
we had a situation where our pctfree was 0, our
initrans was 4, and we were trying to update the table
using 8 concurrent processes. Since we had no space to
grow, our ITL could not expand, and some of the
processes deadlocked with a similiar error.
What is your pctfree and initrans?
Thanks for the link. The example shown at the bottom
of the article looks like an unindexed foreign key
issue rather than an initrans/pctfree issue. What's
really strange about my deadlock is that it shows no
other session waiting on the lock except itself.
Originally, I thought the
Hi,
You
can not setup your archive logs in EMC storage (RAW). Currently I am
working on this project. Oracle recommends that the following
setup:
SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS
- RAW (EMC storage)
ARCHIVE LOGS / ROLLBACK
(UNDO)
- LOCAL (on each
This has now happened on 3 separeate boxes. This has happened while
putting on an Oracle Applications patch or in the last case,after starting
the concurrent managers for 11i with a lot of requests scheduled to compile all
of the flex fields. In every instance, the thread id does not match
I once rewrote the necessary system views to accomodate SQL Navigator.
Creating the users own copies did not work at that time, I had to modify
the
actual SYS copies of the necessary ALL_* views.
It was not fun, and tends to break when Oracle is upgraded.
Jared
Miller, Jay [EMAIL
Typing on a keyboard can accomplish this.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader
Hallo,
Anyone whom
I remember having this problem a long time ago and finding an explanation on
www.ixora.com.au I don't have time to search my notes at the moment but if I
can, I'll do it a bit later.
Henry
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Rich,
Has your coworker perhaps done a writeup on this?
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/06/2002 12:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle
Oracle Security Alert #34
Dated: 5 June 2002
Security
vulnerability in Oracle Net (Oracle9i Database
Server)
Description
A
potential security vulnerability has been discovered in Oracle Net for Oracle9i Database that
may
result in a potential of denial of service attack against Oracle
Title: RE: why so much slower
Problem is that fast refresh of materialized view I
don't believe is compatible with in-line view. Okay, I am wanting
everything and might have to use complete batch refresh to recreate materialized
view.
-Original Message-
Title: RE: why so much slower
You didn't mention 'materialized view' in
your original message.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, June 06, 2002 4:13
PM
Title: RE: duplexing the archive redo log directory
I had already done it online, but had to bounce
the database 30 minutes later for another
unrelated reason, so we should be OK.
Any other 'gotchas'?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is
I've asked him about it, and he'll be putting it on the web soon. From
what I've seen, it's definitely not for the faint of heart. I'll post to
ORACLE-L (with his permission) when the doc's completed.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Jack,
Thanks for the reply. The table is defined as:
INI_TRANS = 1
PCT_FREE = 10
I meant to mention in my original posting that the
platform is Solaris 8, Oracle 8.1.7.0/32-bit.
I don't know what the exact number of concurrent
transactions is, probably no more than a few (1-3).
The
Title: RE: How to move 200 GB db from prod to dev?
Helmut,
This works perfectly for cloning a DB where the instance names are different,
but the directory structure is exactly the same, which looks to be the case from
your original post for the /u02 file system. We do this in order to clone
What's the initrans for the indexes involved ?
Anjo.
Walter K wrote:
We have an application that is periodically
encountering what appears to be a self-deadlock. Only
one session is listed and it holds an exclusive (X)
lock and is waiting for a share (S) lock with NO ROWS
waited. I have
Hey all,
While at a Users Group meet yesterday, HPaq demo'd 9iRAC. While the demo
was highly impressive and all, I was intrigued by one of the tools used to
demonstrate the transparency of the RAC to a client. The tool's window was
labeled Oracle Workload Generator and was supposedly a Windows
If I understand you correctly, you are referring to
"RAW" EMC storage as the shared storage array accessible from all nodes in the
cluster, while "local" is local storage that is only accessible from the node to
which it is directly attached?
If so, then putting the tablespaces on that
[EMAIL PROTECTED] wrote:
Typing on a keyboard can accomplish this.
Scott Shafer
San Antonio, TX
210-581-6217
Can you give an example of how to type on a keyboard ? The Oracle
manuals are unclear on this.
TIA.
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ:
I'll betyou are running...Oracle...8.1.6.
Right?
If so,
the solution is
SELECT /*+ NO_MERGE(x) HASH(st) */
*
FROM (your 2 table join) x
,small_table st
WHERE x.fk = st.pk;
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 05,
I checked out ixora a few weeks ago when this problem
surfaced and saw the article you are probably
referring to but that was a library cache lock and
doesn't look to be the same as what I'm experiencing.
I sure wish I knew how to read the trace files like
Steve Adams can as well as I wish I
Seems that the no rows message was the identifying
criteria of our problem, however, I have both slept
and drank since then. Not at the same time, of course.
Well, maybe a little overlap.
How about your indexes - initrans? pctfree? any bitmap
indexes involved?
--- Walter K [EMAIL PROTECTED]
Anyone used CaseStudio from:
http://www.casestudio..com/enu/default.html
?
Your opinion, please?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
So, we've finally taken the jump and are using JSPs (erm...Java Stored
Procedures, not Java Server Pages) on 8.1.7.2.0.
Informal Poll: How do you use Java Stored Procedures?
1) Easy interface from PL/SQL to lp and other OS commands.
2)
3)
4)
...
Rich Jesse
Thanks to everyone who helped with this.
It's working perfectly.
Jay
-Original Message-
Sent: Thursday, June 06, 2002 5:38 AM
To: Multiple recipients of list ORACLE-L
_trace_files_public = true
in init.ora
Iain Nicoll
-Original Message-
Sent: Wednesday, June
All indexes on the table involved have INI_TRANS=2 and
PCT_FREE=10.
--- Original Message ---
To: Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
What's the initrans for the indexes involved ?
Anjo.
Walter K wrote:
We have an application that is periodically
encountering
Hi,
I have One db instance containing three schemas to represent development, stage,
and demo environments. I occassionally need to *roll* the schemas as a release occurs.
We have been using import/export to accomplish this. In the past, another dba has
done this task (so this is
Hi,
I
have One db instance containing three schemas to represent development, stage,
and demo environments. I occassionally need to *roll* the schemas as a
release occurs.
We have been using import/export to accomplish this. In the past, another
dba has done this task (so this is why I
Hi,
Yes
you are correct.I am using Oracle9i RAC (Real Application
Cluster).
Muqthar Ahmed
DBA
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 4:44
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Archiving in OPS
If
Gurelei
Are the parameter's the same ?
sort*
hash*
*pool*
db*
Gurelei wrote:
Hi.
I have executed an explain plan on a dev and prod
databases. Both databases have the same data, use the
same version of ORacle (8.1.7.0) and the same OS (AIX
4.3.3). All the tables are analyzed. The plans
First, take a hammer
Stephane Faroult wrote:
Can you give an example of how to type on a keyboard ? The Oracle
manuals are unclear on this.
TIA.
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET:
Hi.
I have executed an explain plan on a dev and prod
databases. Both databases have the same data, use the
same version of ORacle (8.1.7.0) and the same OS (AIX
4.3.3). All the tables are analyzed. The plans however
are somewhat different (below). What could explan the
differences? For example,
Title: RE: How do YOU use Java in the DB?
In our ecommerce databases:
1) Interface with LDAP
2) Email
3) Query for product inventory/pricing via MQSeries
4) Send customer orders to our fulfillment provider
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent:
Peter, Charile:
Sore area size is 5 times more in prod DB, shared pool
is larger in dev, db_block_buffers in dev is twice the
size in prod. I guess this answers my question.
thanks
Gene
--- Peter Gram [EMAIL PROTECTED] wrote:
Gurelei
Are the parameter's the same ?
sort*
hash*
Then place your thumb squarely atop the fine manual...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Suzy Vordos [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Sqlloader
First,
Hi.
We are running ORacle 8.1.7.2 OPS on 4 SP/2 nodes.
This morning one of the nodes crashed. some users
experienced their reports which were executed on other
nodes, failed and then completed successfully when
restarted. My explanation for that was that when one
node crashed, the parallel
Sore area, hmmm, sounds off topic to me. :)
joe
Gurelei wrote:
Peter, Charile:
Sore area size is 5 times more in prod DB, shared pool
is larger in dev, db_block_buffers in dev is twice the
size in prod. I guess this answers my question.
thanks
Gene
--- Peter Gram [EMAIL PROTECTED]
alter table table_name move tablespace target_TS storage (initial
bloody_big_number rest_of_Storage_clause) pctfree nn ;
HTH.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
-Original Message-
Sent: Thursday, 6 June
Jeffrey,
As an idea - does orakill let you kill the thread off?
This may let you workaround the issue without restarting the service.
Bruce Reardon
-Original Message-
Sent: Friday, 7 June 2002 6:05
This has now happened on 3 separeate boxes. This has happened while putting on an
Title: Message
If you cannot tie that thread to v$process
then it is likely a problem with a background thread.
If you are using sqlnet expire time it
creates 2 threads for each connection, the timer thread will not show up in
v$process. There are also a few other threads that will not
I have some Java in a database I am working on it is a really simple
parser for doing something that with a real tricky piece of PL/SQL I could
no doubt emulate. Java just was easier. I will most likely use some of the
AQ stuff with Java in later development, currently we can swing both ways.
I use it for email.
Jared
On Thursday 06 June 2002 14:07, Jesse, Rich wrote:
So, we've finally taken the jump and are using JSPs (erm...Java Stored
Procedures, not Java Server Pages) on 8.1.7.2.0.
Informal Poll: How do you use Java Stored Procedures?
1) Easy interface from PL/SQL to lp
yup.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 5:11 PM
Hi.
We are running ORacle 8.1.7.2 OPS on 4 SP/2 nodes.
This morning one of the nodes crashed. some users
experienced their reports which were executed on
Hi List,
Suppose I have m1,m2,m3 machines,
all the users sitting on these machines are using
oracle 'user1' to connect to the server.
As all the people are logged in with the same user
name ,Can we find which user(or machine) has issued
which SQL statement.
Thanks
Sam
1 - 100 of 102 matches
Mail list logo
