its a single instance system..here is some more details ...pls suggest
if something needs to be corrected
SHARED_POOL_SIZE=190MB
DB_BLOCK_SIZE = 4KB
DB_BLOCK_BUFFERS = 125000 (488MB)
LOG_BUFFER = 5MB
SORT_AREA_SIZE = 2MB
SORT_AREA_RETAINED_SIZE = 1MB
Hi gurus,
I have just migrated from Oracle 8.1.6 to Oracle 8.1.7 (Enterprise Edition on
Windows 2000) but when I try to query my partitoned tabless I get the error
ORA-00604 'error occured at recursive SQL level 1'
ORA -00904 'Invalid column name'
I have run the scripts U0801060.sql (which calls
Title: RE: How to delete name service
There is also controlset001 and 002.
Be sure to remove from all.
Be sure what you are deleting.
Yechiel AdarMehish
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 31, 2003
Hi
We had a different problem with our upgrade but the same error message -
there is a patch available from Oracle that is supposed to help(did n't for
us though)
Regards,
N.
-Original Message-
[EMAIL PROTECTED]
Sent: 01 April 2003 09:04
To: Multiple recipients of list ORACLE-L
Hi
Good day to
everyone
How do I find what options are actually
loaded into database?
Not only installed, but
loaded?
For example, I may choose "Spatial" in
Or. Installer, butlater I may create basic database (catalog.sql and
catproc.sql) without any option...
It seems that V$OPTION is
Hi All,
Oracle 8.1.7.4 Win 2000 ONAMES with region database
I have ONAMES repository on server1
I have 2 additional onames services on server2 and server3(no
database/repository).
I received a NNO-50 serious errors in configuration data. I do not know how
it happened but I had to truncate and
Hi,
Do not make the path to the Oracle home you install Designer into any longer
than 13 characters long, or you will find that certain tools do not work.
The drive designator (e.g. C:\) does not count toward this total.
Regards
Pete
-Original Message-
Sent: 31 March 2003 22:49
To:
Hi All,
I have my first upgrade of parallel server coming up and am wondering what
the major differences are between a normal upgrade and this one.
Am I correct in assuming that the installer will detect both nodes and
install the upgrade on both nodes?
Is it correct that I only need to run the
Hi
Slightly OT
I have a couple of programs that need to be run after Oracle has started
and want to run them without a user logging in.
The likely place seems to be in the scheduled tasks running at startup or
as a program under the local run key in the registry.
The processes are a couple of
Hi Ravindra,
Use the following, supposing your db_block_size is 2048 (change as appropiate).
SELECT segment_type, segment_name,BLOCKS*2048/1024 Kb
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('owner') AND SEGMENT_NAME = UPPER('table_name');
You should
There is a script, over on DBA-village.com, that uses rank() and
ration_to_report(), which are features that I apparently didn't install
along with the database (8i) :-(
Do I have to install this from the CD and re-start the database in order
to use?
Are there any possible problems with
and ration_to_report()
That should of course be ratio_to_report(), as we're not yet on
rationing here in the UK (only a matter of time according to sections of
the media and some MPs!).
Craig
**
This email and any
Hi Jack:
the answer to your second question is yes, because you only have one DB,
;-).
about you first question there are some platforms on which the distribution
of binaries to all the nodes goes wrong but with 8.1.7.4 on tru64 it doesn't
( as far as I know ;-))
You will be pretty safe if you
Title: RE: RMAN question
Dennis,
I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also backup the control file several other ways and would likely never ask RMAN to perform that function. The only reason I issued 'restore controlfile validate' was
Get GAJA's Book .. Oracle 101 Perf. Tunning.. U will find a Lot there ..
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-Original Message-
C.S.Venkata Subramanian
Sent: Tuesday, April 01, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
where can one find the
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 4:03 PM
where can one find the other myths about oracle?
Venkat
--
A number of Oracle Press books ...
Cheers
Richard
--
Please see the official ORACLE-L FAQ:
Hi Peter,
Sounds like a job for an after startup database event trigger (check
out CREATE TRIGGER doco).
Cheers
Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 10:28 PM
Hi
Slightly OT
I have a couple of programs
I assume that the existing 8.1.7.0 environment is already running OPS.
In that case, the 8.1.7.4 patchset should apply successfully.
If it is a TruCluster 5.x or higher, it would be a Cluster File System, in
which
case it would most probably be a single ORACLE_HOME shared by both nodes.
[I have a
Its the Java JVM you have installed with the Jdeveloper. Have a look at
your Environment variables and see what Java is in the path and what
classpath is set. I would say OEM isn't compatible with the one installed
when you installed JDeveloper
Cheers
--
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm (Gaja Krishna
Vaidyanatha)
www.jlcomp.demon.co.uk/myths.html (Jonathan Lewis)
http://www.orapub.com/cgi/genesis.cgi?p1=subp2=abs119 (Cary Milsap)
-Original Message-
Foote
Sent: 01 April 2003 14:34
To: Multiple recipients of list
If you want no user to log in, you may wish to start your database in restricted mode
(and use an account which has the appropriate privilege to log into Oracle if you have
to). The snag is that you have to issue an ALTER DATABASE once your job is done.
Another solution, assuming that your
Richard,
hopefully not in mine! And if you do believe we have mistakes in our
book, please do tell me or one of my co-authors. We really do want to
present accurate information and any corrections will be sent to the
publisher for the next printing. That goes for everyone on the list
Along the
Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking
too slow. I checked my systems and I see the snapcf_SID.f files, one for
each database being backed up. I do not see the other files you mention. I
notice the mystery file names have a format quite close to your backup
Hi,
You can also download the delsrv.exe (free download) from the Windows
2000 Resource kit and use it delete a service.
delsrv sevice name deletes the service.
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B274305
Regards,
Madhavan
http://www.dpapps.com
On Tue, 01 Apr 2003
Hi,
Is there a way to see whose function a user is executing?
Development and production schemas exist on the same database and both
accounts have granted object privileges to the user roles. (I think public
synonyms are being used). I'm wondering if there is a way to check that a
user is
Hi all,
I'm currently writing an Oracle user guide for our developpers about how
Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs
cost base (90 on 120 databases are still rule base) ...
I want to add an Oracle urban legends and myths section focussed on
development.
I couldn't support you more Tim.
-Original Message-
Sent: Monday, March 31, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L
Oraperl?
I released DBD::Oracle 1.14 a few days ago.
In the release notes I said:
NOTE: OCI 7 and Oraperl will not be supported in future releases.
I'm
Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups
when taking backup of an OPEN Database which is undergoing User Transactions ?
(Or am i mistaken ?)
Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it
?
Qs.3 How does RMAN Check
Wierd. Our primary ONAMES server is 8.0.5 on OpenVMS, with the Region DB
being on the same box. Our secondary ONAMES server is 9.2.0.2 on WinTuke
using the same Region DB as the primary (amazing that 9iR2 can still use an
8.0.5 Region DB). Yes, we are working on upgrading this config, despite
Arvind,
Try cutting DB_BLOCK_BUFFERS in half. Yeah it's a strange concept, but if the
swapper is running them giving back some memory to the system may stop it the
improvement in response time will more than make up for the additional wait in getting
data into the cache.
Dick Goulet
One other way to go would be to use a system startup script (see
http://support.microsoft.com/default.aspx?scid=kb;en-us;198642 for details)
that first started your db, and then followed up w/whatever other scripted
tasks were necessary. Theoretically, anyway...
HTH,
-Roy
Roy Pardee
Title: Re: Oracle urban legends and myths needed
Do a search for myth on asktom.oracle.com:
e,g.:
Whenever possible, issue frequent COMMIT statements in all your programs.
By issuing frequent COMMIT statements, the performance of the program is
enhanced and its resource requirements are
1: RMAN does not generate excessive redo because it does not use the 'alter tablespace
... begin backup' command. It instead coordinates with dbwr, somehow, to be sure it
is getting a consistent view of the tablespace.
2: The concept of an incremental backup is that you only backup the
What had happened was the data in the table onrs_region got corrupted but
the region database was still up. Somehow this caused all 3 name services
to shutdown on all 3 servers. I do not have a clue how that is possible.
There were checkpoint file on all servers but still no one connected.
Vivek
1. RMAN works on an entirely different principle than hot backups. Much more
transparent to the database.
2. RMAN incremental backups work by checking if a block has changed since
the last incremental backup of the current level or lower. So only changed
blocks get backed up on an
No excessive Redo ...one of RMans new features..
I will have to write a book here to give you good answers...
I would suggest reading the really good cheat sheet on technet on
Backup and recovery...they are very good and complete..
If not that just search google for RMAN faq and you
Does this mean the 'use Oraperl' and the oraperl subroutine syntax (like
ora_login) would be deprecated?
I wouldn't ordinarily care, as I haven't used that syntax for years.
However, quite a few of our application areas wrote entire applications
using oraperl. Just getting them to plug a 'use
From: [EMAIL PROTECTED]
I have a couple of programs that need to be run after Oracle has started
and want to run them without a user logging in.
The likely place seems to be in the scheduled tasks running at startup or
as a program under the local run key in the registry.
The processes are a
How do you monitor if the indexes are being used in 8i? Individually the tkprof and explain plans do the trick. However from a running system, how can the index usage be determined?
If the index is being used? How many times did the index get used during a specific time frame etc.
Regards
MenonDo
I need help,
I have a procedure to insert xml data into a table.
The xml data is store in CLOB, and i user xml parser
and DOM to get the value and insert into table.
If the file is is under 1 MB, everything is OK.
But when the xml size is larger than 1 mb i'll
get error message
ORA-29532: Java
Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN
for enabling taking of backups onto backup devices OR does it need an
extensive setup ?
I found it to be fairly easy to get RMAN working with Legato NetWorker. We
had to go through a few hoops to get it working on a Veritas
Hello Gurus
We are in process of planning to upgrade our existing Oracle Financials 10.7
Character Applications to 11i( ver 11.5.8)
Existing env
HP-UX 11.00 32bits
Oracle Financials 10.7 Char
with Manufacturing Bill of Material
Some customization (of Forms Reports)
No middle tier
Database
Question:
If some idiot decides to circumvent Oracle's referential integrity and
re-implement it by using triggers (insert, update, delete) that checks the
foreign (parent/child) key fields in other tables like this,
declare numrows INTEGER;
begin
-- ApplicationForm is used if the state and
Tim,
Personally, I have a few v7 db's around. My DBD interaction with them
however
is limited to logging on to the database just to make sure it's still up.
Would removing OCI7 support include removing the ability to logon to a v7
db?
Jared
Tim Bunce [EMAIL PROTECTED]
Sent by: [EMAIL
Since you the action switches from SQL to PL/SQL to enforce the trigger,
it sounds like a context switch to me.
FYI: This can be improved somewhat by adding and rownum 2 into the
WHERE clauses of these. There will be noticable improvement when there
are many child rows.
Jared
[EMAIL
Title: RE: Do triggers cause a context switch between SQL PL/SQL
Yes ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Scott (or anyone runing HA 2.2 wishing to upgrade to
9i): I noticed you did not receive a response from
this message a couple of months back.
We're in same situation (Sun Cluster 2.2, wishing to
upgrade to Oracle 9i). It's not clear from the Oracle
certification matrix if this is supported.
We did something very close to this in November of last year. We have
the same OS and hardware. We were also character mode however we
differed in that we used GEMMS for process manufacturing rather than
discrete manufacturing in Oracle. We also had some customization. Our
database was a
Hi,
What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris?
We are using Legato products and they have NetWorker Module for Oracle and NetWorker
Module for SAP on Oracle.
Which one is better?
Thanks,
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
I thought as much, from what I've heard and read. Does anyone know if
there's a way to figure out how much overhead the switches generate? I'm
guessing they would show up in trace files in the 'other CPU' category.
Kirti,
This what oracle support said;
-joan
As the doc says When running Oracle9i 64-bit on AIX 5L, the machine can
be booted indifferently
with the 32-bit kernel or the 64-bit kernel. Switching kernels simply
involves
a reboot, there is no need to reinstall AIX or to modify the Oracle
Roger
We don't run SAP, but are you considering using RMAN as a part of your
plans?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Hi,
What is the backup
Murali
If I'm not mistaken, the first Oracle version that offers real support
for this is Oracle9i. I think what you are doing is about all that can be
done -- capture SQL, run explain plan on it and make a list of the indexes
that are used. If you look around, there are scripts to help and
Answer 1: RMAN keeps track of increasing SCNs of any changing datablock
within the datafile being backedup. Hence not much redo.
Answers to other questions have been posted by others.
HTH
GovindanK
|XXX|
|You should treat
I seem to be missing some of the replies etc to this so apologies for
repeating anything anyone else has said.
1. A BCHR of x% means that you have a well tuned system (where x is
usually 95)
2. Minimise the number of extents for each object
3. Set PCTIncrease to a small value (typically 1%) to
All,
The primary reason why RMAN does not generate
excessive redo is because because it does not put the
tablespace in hot backup mode. Thus any blocks
belonging to a given tablespace that are modified
before the END BACKUP command is processed, do not
require block-level before and after images.
On Tue, Apr 01, 2003 at 09:08:51AM -0800, [EMAIL PROTECTED] wrote:
Does this mean the 'use Oraperl' and the oraperl subroutine syntax (like
ora_login) would be deprecated?
They would be more than deprecated. They wouldn't work at all.
I wouldn't ordinarily care, as I haven't used that
On Tue, Apr 01, 2003 at 10:08:31AM -0800, [EMAIL PROTECTED] wrote:
Tim,
Personally, I have a few v7 db's around. My DBD interaction with them
however
is limited to logging on to the database just to make sure it's still up.
Would removing OCI7 support include removing the ability to
Title: RE: Do triggers cause a context switch between SQL PL/SQL
A context switch is order because a trigger is a pl/sql object ...
if you can change the trigger ... instead of count(*) try using exists assuming you have a usable index ...
select count(*)
into numrows
from dual
where
Kirti,
Can I add to your request?
I'd appreciate knowing of anyone who migrated to collaborative suite instead
of Exchange and if there was a $$ difference how much it was and which way. Also if
you did make the move from Exchange to Collaborative did you save any money in the
The case is not as bad as the subject may let you believe, but not
quoting Disreali was above my strength ... Anyway, an interesting case
encountered today. Basically, a dreadful query, involving a reasonably
big table with an innate tree structure (the stuff connect bys are made
of), accessed
Yes.
In fact, I am trying to decide using RMAN or SAP BR-tools.
-Original Message-
Sent: Tuesday, April 01, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Roger
We don't run SAP, but are you considering using RMAN as a part of your
plans?
Dennis Williams
DBA, 40%OCP, 100% DBA
Kirti,
Check the OTN training/seminars that are being presented in different
areas of the world. I attended one such session that talked and demo'd
the Oracle email functionality. It is an amazing product if you need all
of the features that Oracle OTN had set up. The demo was for web based
email
I am putting together a prelimanary job task analysis
for Oracle DBA's and would like some input from you
hardworking DBA's on this list.
Here is what I have so far for core competencies and I
would like to add or subtract from this list based on
your input.
A. Oracle Architecture And Options
I did some bulk load testing with triggers on v8.1.7.4 a few months ago.
All the trigger(s) had for code was a NULL; statement. The first trigger
increased the time 100% in the insert (ie: a load that took 1 minute
increased to 2 minutes with the trigger). Each additional trigger after
the
ORA-01555, 0, snapshot too old: rollback
segment number %s with name \%s\ too small
indicates that the DBA should immediately create a
hugh rollback segment
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of
Stephane Paquette
Sent: 01
Dick,
check out this link
http://www.oracle.com/jsp/events/EventsDetail.jsp?p_eventId=9595src=1544227src=1544227Act=183
it is the link top the OTN events about just what you are talking
about.
If your lucky you can get the slide show that did the comparisons
between Oracle and MS per user per
In case of hot backup scn at then time of starting backup is frozen in
datafile header , and is refreshed at the time of end backup .what happens
in RMAN ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 12:43 PM
All,
A V9.2 DB can't/won't talk to a V7 DB, and vice versa.
So we were forced into using a V8.1.7 DB as the middle man.
It works for low volume transactions.
-Original Message-
From: Stephane Faroult
interesting tuning case study snipped
A moral to the story? SET TIMING ON. What matters is elapsed time, not
stats. That said, I must check events next week.
Another lesson, which probably wouldn't make any difference in your
case, is
Congratulations Stephane -- a good lesson for us all.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 01, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
The case is not as bad as the subject may let you believe,
Try help.sap.com and search on RMAN and Oracle.
Here's one to get you started.
http://help.sap-ag.de/sapdocu/core/470/helpdata/EN/3f/9d80051aec11d2b42c00609419997a/content.htm
Jared
Roger Xu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/01/2003 01:09 PM
Please respond to ORACLE-L
What do you thinke of how the OutLook express handle the data (email)?
I think they are stored in database .
Now ,I am going to program by visual c++ ,
In order to process large data , I want to use oracle .
But I don't want to tell my users: to get a oracle database 9i and
install it .The
Title: RE: Do triggers cause a context switch between SQL PL/SQL
Your query with the exists would be the same as doing this, right?
select count(*)
into numrows
from from ApplicationFormCriteria
where ApplicationFormCriteria.applicationFormId = :old.applicationFormId
and rownum = 1 ;
Murali ,
I have attached a script.
i use the same to find index usage.
hope this helps.
Regards,
Jp.
FindIndexUsage.sql
Description: Binary data
From: liujd [EMAIL PROTECTED]
What do you thinke of how the OutLook express handle the data (email)?
I think they are stored in database .
Now ,I am going to program by visual c++ ,
In order to process large data , I want to use oracle .
But I don't want to tell my users: to get a oracle database
I think the answer will depend slightly on your operating platform and
intended use of the product... But the generic answer is No.
I have never heard of just the engine for Oracle... Essentially Oracle
is just an engine, there's not much you could remove and still have a
functioning product
Title: Database character set for Webshpere access
list,
I've searched the faq list and metalink. It appears the database character set for java etc should be al32utf8 and nls_character set of al16utf16 for a 9i R2 database.
Has anyone altered a database from US7ASCII to al32utf8 and
What are you going to be doing? You probably can use an embedded
database like BerkeleyDB or Sqlite
On Tue, 1 Apr 2003, liujd wrote:
What do you thinke of how the OutLook express handle the data (email)?
I think they are stored in database .
Now ,I am going to program by visual c++ ,
In
Thanks for the information, Ron.
I will check it out in due course of time. I was more interested in knowing if anyone
has done this migration. As Dick mentioned, we are interested in finding out if there
is any $$ savings, and how much, and at what cost (of deployment etc etc)..
These days
Hi gurus,what do u recommend:
taking "Developer OCP" then "DBA OCP", or "DBA OCP" direct
?assuming a person who is currently a 28 years -
already is a senior oracle
developer.thanx for advice
Regards,Salaheldin
Aboali--Senior Software Developer
HELP
--
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
San Diego, California-- Mailing list and web hosting services
Hi All,
Is there any way to find out the total disk capacity available, from
the PL/SQL program ?
Regards,
Pradeep
--
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
San
Hi all,
what might be the best configuration for OLTP database
if you have following components:
DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks...
And what is the correct flag for Optimize Performance
for Applications or Background Processes...
TIA
Joshua
I've been using this query for both normal and empty tables and works so far.
For those tables with no data in them (or that have suffered no deletion) you
can ommit the second query since the table should not have any emptied block. Emptied
blocks are those who have been
85 matches
Mail list logo