otn - http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
this site really sucks bad - half the links are broken. wtf?
its 8.1.6 that's off of correction, not 8.1.7.
my copy of 8i Backup recovery handbook is at the office, and the docs
are not available online.
most important:
don't open the
Hi List,
I try to estimate commit rate on our system. Currently I just periodically collect
values of 'user
commits' statistics in v$sysstat in order to estimate frequency of LGWR's writes. But
I assume this
statistics doesn't reflect group commits. Is there more sophisticated method to find
Barb,
When you say 'recover on different hardware', I hope you mean that you will
recover on another *similar* box that has the same OS and CPU architecture.
I.e. a database that was on Sparc Solaris 8 cannot be recovered on a HP-UX
box (or even a Solaris 2.6 box I think)... This is because of
Hi List,
I'm looking for recomendations, best practice, etc about setting strip size for RAID5
arrays.
We have a hybrid system (mainly OLTP) with prevelant reads operations and have limited
number of
disks.
My question is should I merely setup the stip size equal to Oracle block size or
Hi List,
Does someone have experience with Compaq's RAID controllers? I've inhereted a 22x7
system where
RAID arrays are supported by SmartArray 5300 controller. Last weekend I had an
opportunity to add a
spare disk to the RAID5 array which consisted of 7 disks.
I was amazed when the Compaq
Doh!
Your message came minutes after I'd already opened the database.
When I attempt the recovery I get the message
SVRMGR recover database until cancel using backup controlfile;
ORA-00279: change 278038264 generated at 11/01/01 01:28:13 needed
for thread 1
ORA-00289:
hai list,
my system (compaq deskpro under os- windows nt)is connected to a printer
-HP deeskjet 870cxi professional series..
i want to print one file through the text_io utility of D2k .
.i called the printer through a trigger on pressing a button
Barb,
What Paul said -- Do NOT open the database normally. If you use the
backup controlfile, Oracle presumes that the SCN's in the headers may
or may not be in sync and will allow you to recover past the SCN in the
controlfile. Presumes it's fuzzy.
You have my sympathies, I've been there, done
Hi,
TKPROF is not designed to format the event 10046 level 4 data.
It can only format the trace of event 10046 level 1 (Read: SQL Trace).
If you want to format the higher level trace file you need to use
*itprof* (Check www.unal-bilisim.com ) *sparky* Hotsos profiler
(Check www.hotsos.com).
I submitted a TAR and Oracle seem to think it's because the shared pool
is too small. Hmmm. Upping it did seem to resolve the problem, but...
this is a scenario in which a bit of Oracle functionality just stops
working, without throwing an exception from the trigger code, nor even
making an entry
We have a cust on 10.7 on Sequent box. We want to go upgrade to 11i on Sun
box.
Options we have i think -
a) upgrade to 11i on Sequent (upgrade database to 8.1.7) then export
import onto sun box (empty 11i system)
b) install 10.7 on sun, export /import system from sequent into 10.7
I cannot get on any link from Tahiti.
Does anybody know what's up?
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Title: RE: Oracle 7 documentation - Good One
We have 44 instances still running one of
8 versions of Oracle7, ranging from 7.2.2.3
to 7.3.4.4.
They don't give me as many headaches as some of
my 8.0 and 8.1 instances
Matt Adams - GE Appliances - [EMAIL PROTECTED]
It will make sense
We are running some 7.3 servers, are in the process of upgrading.
Matthew, out of curiosity, how many DBAs and operators do you have to
support 44 instances?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Adams, Matthew (GEA,
Bruce,
Can you expand further on the following statement?We use a lot of
synonyms (not in forms but in SQL).
This led to the above query using around 1000 times more consistent gets
than it needed to (due to bad execution plan).
Thanks,
Cherie Machler
Oracle DBA
Gelco Information System
Rachel, Paul:
Ya, that was it.
I re-copied all the files and this time did NOT open normally.
Recovery completed.
I'm outta here.
Thanks for your help!
Barb
--
From: Rachel Carmichael[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, November
Jan, I can get to the first page on the site but moving around to other
pages is taking forever.
Dave
-Original Message-
Sent: Thursday, November 01, 2001 6:10 AM
To: Multiple recipients of list ORACLE-L
I cannot get on any link from Tahiti.
Does anybody know what's up?
JP
--
7.3.2? baby
now 5, THERE was a real geek's database
--- Guy Hammond [EMAIL PROTECTED] wrote:
I submitted a TAR and Oracle seem to think it's because the shared
pool
is too small. Hmmm. Upping it did seem to resolve the problem, but...
this is a scenario in which a bit of Oracle
Hi All,
It's nice to learn that there are so many Oracle 7 database's still out there .
It does not give me a Complex any longer .
Oracle 7.3.4.4.1 DBA and Oracle 8i's tinkrer .
Probably I am already outdated with Oracle 9i out in the market .
Shreepad
--
Please
Title: RE: Oracle 7 documentation - Good One
We currently have a grand total 138 databases,
(and more on the way on what seems like a weekly
basis) with a active DBA support team of about 12, but some
are part time and many are dedicated to special projects.
Matt Adams - GE
Are you starting everything up in the proper order ?
- Database first (8.1.?)
- 8.1.? listener
- running your applications environment file (APPSORA.env)
- the other processes you listed
Just a guess.
-Original Message-
Sent: Wednesday, October 31, 2001 3:55 PM
To: Multiple recipients
I need to prune data from a set of tables every day. I need to retain the
last 90 days of information. Two of the tables, A and B, have foreign keys
to a third, C. I cannot disable the constraints prior to deleting the data,
because the system is 24/7. I have created a script that will delete the
Barbara,
I'm going to take a bit of a guess here - but this should work:
set aside the control files used when the database was opened normally.
grab only the control files from the cold backup set (ideally a backup
control file) or earlier and re-attempt recovery.
I'm assuming that the size
I'm sorry. I thought that you mounted a database and that the instance was
the area in memory (corresponding to the SGA and PGA) that Oracle used. So
what is the instance?
Denham
Garreth,
dynix/ptx is being EOL'ed as of
current release, i think.
i mean, it's rock solid and will
be around for years working well,
but...
thought you'd like to know.
hth
Ross
-Original Message-
Sent: Thursday, November 01, 2001 7:10 AM
To: Multiple recipients of list
De nada chica... glad you had a backup of the files to work with
--- Baker, Barbara [EMAIL PROTECTED] wrote:
Rachel, Paul:
Ya, that was it.
I re-copied all the files and this time did NOT open normally.
Recovery completed.
I'm outta here.
Thanks for your help!
Barb
--
Barbara,
Like Rachel I've been in the same place you are too, a couple of times. In
every instance where I've been faced with recovering a database and/or datafile
the worst part of the process is getting started. Namely figuring out 1) what's
broke, 2) what do I have to fix it with, 3)
Games are usually CPU bound...or system
bus bound (vid card to mobo, natch ).
-Original Message-
Sent: Wednesday, October 31, 2001 12:02 PM
To: Multiple recipients of list ORACLE-L
Hey Walt,
How about using the RAMDISK on your gaming pc. I'll bet it would scream.
ROR mª¿ªm
--
Erik,
First off, do the foreign keys have the 'on delete cascade' option turned
on? If not then do so as it makes keeping things in sync much easier. Actually
in this scenario you don't have to worry about the child tables.
Second, what do you mean by The design of the application
Cheers...
the SDS stuff looks to be (at least as of a year ago) the best in the
market.
I knew a really nice, bright guy who
worked with them in that timeframe,
Mark Hayakashi, i think
The utilities for file layout/io are
good, the idea is great, but set
expectations low. If you get a 10x
Well, yes and no.
1) Database up
2) Listener up
3) Log in as Apps person (hence source in appsora.env)
4) Other processes listed
-Original Message-
Sent: Thursday, November 01, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L
Are you starting everything up in the proper
Gerardo,
The trick works for me also but when i try to export it shows as:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
server
That is an excellent suggestion! I had not thought of that.
Those tables are populated with data as a result of web site interactions.
Inserts need to be as fast as possible. There were no indexes added due to
the overhead of maintaining an associated index.
Thanks again for the suggestion. I
Dick,
thank you -- how come I don't get invited to speak at NOUG anymore? :(
Actually, I've decided that there should be a corollary to my Rule 0 --
while that backup is being made, go and have a cup of coffee and take a
pad and paper with you and start to plan what to do.
This presumes that
I'd love to get a RAMDISK in to my gaming machine -
P4 1.4
256Mb RDRAM
40 gig UDMA100
64Mb Geforce 3 (ELSA GLADIAC 921)
Thinking of upgrading the hard drive at the moment to 60/80 gig.. Hmmm..
Anyone got any good articles etc for RAMDISKS? I'd like to read up on them a
little more..
BTW: The
Not really but I guess I should consider it. Sounds a little better then
waiting for CA to catch up.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 10:00 PM
To: Multiple recipients of list ORACLE-L
Kimberly,
As an alternate suggestion, have you
Why purchase TOAD over SQL Navigator? They both do basically the same
thing, right???
You have direct access to Toadman Jim himself. You have input as to what
you want to see in the product. Bugs get addressed *immediately*. New beta
versions at least weekly. And Jim himself is one helluva
Oracle Certification Gains GI And Veterans Approval
REDWOOD SHORES, CA--(INTERNET WIRE)--Nov 01, 2001-- Oracle Corp.announced
today that their education arm, Oracle(R) University, received notification
from the United States Veterans Association that Oracle Professional
Certifications are now
Our developers use both products.
Light Oracle developers, including some power end-users, get by just fine
with TOAD.
High level folks, those into heavy PL/SQL, swear by SQL Nav.
Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529
Erik - Another suggestion that has been mentioned on this forum is to
consider partitioning. You could partition by insertion date, with each
partition holding a month of data. Then you could clean up by truncating the
oldest partition. Without indexes, any use of these tables will probably be
Mark,
I don't get it...isnt' the ELSA
an AGP ver2 card? This game should
run in video memory for the most part,
plus computations...and an occasional
load of new textures/templates etc.
How odd.
(maybe move this to Oracle OT?)
- Ross
-Original Message-
Sent: Thursday,
Try
set serveroutput on size 100
declare
--
V_SP NUMBER(32) := NULL;
V_FB NUMBER(32) := NULL;
V_PF NUMBER(32,2) := NULL;
--
BEGIN
select to_number(value) into V_SP from v$parameter where name
= 'shared_pool_size';
select sum(bytes) into V_FB from v$sgastat where name = 'free memory';
V_PF
Take a look at PL/SQL Developer from All Around Automations, much better
than both of them, and a lot cheaper.
But Toad is kind of a better product for the money (750 vrs 5000).
Navigator is severely overpriced.
Do not criticize someone until you walked a mile in their shoes, that way
when you
Title: RE: Toad vs SQL Navigator
We have sqlnav here at my site, it's cool and all but pretty expensive. I really liked ezsql and am sad to see it go away (damn shame). I have a question, since it's no longer available for sale how illegal would it be for me to obtain a key from someone to
Harvinder,
try setting NLS_LANG=AMERICAN_AMERICA.UTF8, then doing the export.
If NLS_LANG is not set, the default is US7ASCII as you experienced.
Refer to MetaLink Note 48644.1 and Note 15095.1
Gerardo
-Original Message-
Sent: Thursday, November 01, 2001 7:30 AM
To: Multiple
Hi,
We are continuously getting following error when we are running long tests.
test makes connection to database multiple times.
10/31/2001 9:18:01 PM ERROR: cannot open connection
'dsn=QUARK_ORACLE;uid=nmdbo;pwd=nmdbo;' - error [-2147467259]
[Microsoft][ODBC driver for
Basically virtually all of the ALL_ and DBA_ etc
objects in the data dictionary are views - some very
complex. When you use optimizer_mode = first_rows,
you are now using the CBO on the data dictionary -
since the dict is optimized for RBO, you can get
some occasional anomalies when accessing
Folks --
I got it. Seems that what happened was that one of the scripts that needed
to be run by the applications user shuts the listener down and attempts (but
fails) to restart it. Now, the problem was that the lsnr process was out
there, but that there were no associated services with it,
Dick- Do you have any experience with using on delete cascade? Do you know
if it will be faster, or just easier? I was just curious how it worked
behind the scenes and if it would still just be doing table scans.
Thanks again.
Erik
-Original Message-
From: [EMAIL PROTECTED]
Must disagree here. Just upgraded my ram from
128 meg to 1 Gig ($120.00 US) and my Undying
is running like a champ, loads, saves, visuals,
everything. 900 mz Athlon, Voodoo 5000 w/
128m mem. Can't believe the difference.
Just put them in the slots, nothing else.
One caveat, Norton Antivirus
Problem, the test has to be taken on or after 1 March 2001.
Dick Goulet
Reply Separator
Author: Ken Janusz [EMAIL PROTECTED]
Date: 11/1/2001 8:16 AM
Oracle Certification Gains GI And Veterans Approval
REDWOOD SHORES, CA--(INTERNET WIRE)--Nov 01,
Rachel,
My first rule on recoveries is to go get the cup of coffee after a walk
around the building to cool off. It helps to drag along your SA so that you
have an idea of what is stored out there on tape. BTW, I have the same problem
with the enter key too. I also have the same LOVE for
yeah got the invite.. I was teasing you :)
I'll have to talk to Marlene before committing to anything... won't
even commit to commit to anything :)
--- [EMAIL PROTECTED] wrote:
Rachel,
My first rule on recoveries is to go get the cup of coffee after
a walk
around the building to
Group,
Is there anyway to execute a system level command from within a stored
procedure and also get a return code back ie. A) did some prep on a
partitioned table
B) used utl_file to unload some new data from
remote location
C) NOW I
Pretty poor timing considering the current market.
Jared
Ken Janusz
Hi
I checked sqlnet.log file is growing.I want to set parameter to not grow
sqlnet.ora at application end.Let me know what parameter I need to set in
which file.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at
NLS_LANG should be set on client, either UNIX environment variable or NT
registry entry.
I don't think there's a way to force client to use a particular character
set. This is the whole point of NLS, I think. Server should not care what
language/character set client uses, and vice versa.
Hi. I'm looking into implementing a read-only stand-by database. I'd
like to have it read-only for periodic reporting during the day. Is
this possible under 8.1.7, or 9i?
Are there any drawbacks to having the stand-by database opened for
read-only? I would have two goals in mind: 1. A stand-by,
uhthe Market for Oracle aggrandizement?
I think that's flourishing, eh?
-Original Message-
Sent: Thursday, November 01, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Pretty poor timing considering the current market.
Jared
Ken Janusz
I think u have set trace on in sqlnet.ora
check it out
From: Seema Singh [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: log growing
Date: Thu, 01 Nov 2001 11:10:19 -0800
Hi
I checked sqlnet.log file is growing.I want to set
Next time you're invited I'll be happy to show you the Necco factory.
Henry
-Original Message-
Sent: Thursday, November 01, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L
Dick,
thank you -- how come I don't get invited to speak at NOUG anymore? :(
Actually, I've decided that
Seema - Check your listener.ora file and look at the TRACE_LEVEL parameter.
To effect a change, start/stop the listener.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, November 01, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L
Hi
I
Jeff - With 8.1.7, I believe that you are limited to read-only or standby,
but you can't have both simultaneously. It is either in recovery mode
accepting redo logs from production or open and allowing read-only.
I believe that with 9i the options are much more flexible. Read up
on the
Come on everyone. In 25 words or less.
What I like or dislike about my ETL tool.
The ETL feature I like most is __.
The ETL feature I wish I had most is __.
If I had it to do all over again I would .
The SOB that bought ___ should be nailed to a ___ and
Steve, thanks for the help and for the url and the
advice of stripping.
I don't understand what I'm pasting here , I'm
executing a 'ls' in a FS that's in a different disk in
differents LUNs (on the same Symmetrix), why is it
still stucking. Shouldn't it be placed in a different
queue??
The 'ls'
Given a business rule that says a combination of three columns must be
unique if and only if a fourth column equals a certain value, and if
the table in question contains rows that violate this requirement, I'm
trying to write a single SQL statement that will remove the duplicates.
Of each set
-- Brian MacLean [EMAIL PROTECTED] on 11/01/01 12:25:22 -0800
Come on everyone. In 25 words or less.
What I like or dislike about my ETL tool.
Ab Initio
The ETL feature I like most is it's
fast, scales nicely and is fairly straightforward to maintain. Their
GDE makes it
LoL!
I always advocate stripping when there is a stuck log.
-Original Message-
Sent: Thursday, November 01, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L
Steve, thanks for the help and for the url and the
advice of stripping.
snip
--
Please see the official ORACLE-L FAQ:
you're deep in the SQLNET TNS stack, near a small series of twisty
passages.
(turn high tracing on.. grep the logs for tti and brace yourself )
-Original Message-
Sent: Thursday, November 01, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I am investigating some
Hi Edward,
please list, correct me if I'm wrong
I think may be the amount of log_file_sync could help you too. But I
think you should substract
DBWR waits on this event.
I also think that 'user commits' statistics is independent of group
commits, this statistic is updated whenever a
Hi,
I created a database (8.0.6 - HP-UX 11) and then I changed the processes
parameter to 100 (initial value was 50). I then tried to start the database
and I get the following error:
SVRMGR startup
ORA-07279: spcre: semget error, unable to get first semaphore set.
HP-UX Error: 28: No space
Hi,
we are running batch job executing following statement in a loop about 1
million iterations:
select sysdate from dual...
we are getting error ora-04031 unable to allocate 2400 bytes in shared
pool..
and when we check the sys tables it is showing same number of pare call as
Dennis
Listener.ora file is ok.I have not enable TRACE_LEVEL.I am getting the
following message in sqlnet.log file
I have application server 4 but this error is coming on only one server.
What could be problem.
Thanks
-Seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Title: RE: Toad vs SQL Navigator
Ah... You are correct that Golden and PLEDIT are not tools that compare to TOAD or SQLNAV but that does not mean that there are not excellent tools... For years I was a die hard SQL*Plus fan... A SQL*Plus bigot you might say... I avoiding tools like TOAD and
I have friends looking.
Thanks,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Title: RE: Startup error
Looks like you need to adjust the kernel parameters for semaphores... Refer to the Oracle install guide for the recommended minimums for each parameter...
You can find them at...
http://docs.oracle.com/database_mp_8.html
And specifically...
I think you probably need to revisit the kernel paramters such as SEM*.
-Original Message-
Sent: Thursday, November 01, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Hi,
I created a database (8.0.6 - HP-UX 11) and then I changed the processes
parameter to 100 (initial value
Hi Raj,
I would imagine that the details of the implementation of the two-task common protocol
and its interface functions are
not the sort of documentation that Oracle is going to make available to customers!
Other than the obvious step of contacting Support, check the operating system
t2.timestamp t1.timestamp?
he wants to delete the LATEST insert timestamp, right Paul?
--- Regina Harter [EMAIL PROTECTED] wrote:
Try this:
Delete from my_table t1
where a = 2 and exists
(select 'X' from my_table t2
where t2.a = t1.a
andt2.b = t1.b
andt2.c = t1.b
andt2.d
for solaris
the soln is to bum up semmns parameter.
--- Sujatha Madan [EMAIL PROTECTED]
wrote:
Hi,
I created a database (8.0.6 - HP-UX 11) and then I
changed the processes
parameter to 100 (initial value was 50). I then
tried to start the database
and I get the following error:
What's your SEMMSL, SEMMNI value set to?
[EMAIL PROTECTED] 11/01/01 07:25PM
I think you probably need to revisit the kernel paramters such as SEM*.
-Original Message-
Sent: Thursday, November 01, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Hi,
I created a database (8.0.6
Hi Pablo,
I've seen an 'ls' hang for more than a minute under 10.20 when there were a lot of
delayed writes pending on an
unrelated file-system. A colleague of mine (Chris Bunting) did some testing to
reproduce the problem and concluded that
all filesystems of the same type (JFS or HFS) were
Hi,
Is there a way to disable all constraints, and then enable them all
again?
Thanx
Sujatha
Are you using MTS ? If yes, try and increase LARGE_POOL_SIZE
Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001
Namaskar !!
alter table table_name disable constraint cons_name;
you could generate sql's to generate these ..
select 'alter table '||table_name||' disable constraint
'||constraint_name||';'
from all_constraints
where constraint_type in ('C','R')
/
later you could replace the DISABLE with
Thanks!
-Original Message-
Sent: Friday, 2 November 2001 3:22 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Namaskar !!
alter table table_name disable constraint cons_name;
you could generate sql's to generate these ..
select 'alter table '||table_name||' disable constraint
I am trying to import data into a database, but it keeps skipping rows
because of constraints. So I want to disable the constraints, import the
data and then enable the constraints again.
Can I do this? or is there another way to go about it?
Thanks
-Original Message-
Sent: Friday, 2
Hi,
Hope these script will help you..
Disable
Constraints..
select 'alter table tab disable constraint
'||constraint_name||' cascade;' from dba_constraints where
owner = upper('owner') and table_name = upper('tab')
/
Enable
Constraints
select 'alter table tab enable constraint
THANKS,
I
resolved the issue.
If
I use a script like the one below to test the trigger "for each row"
and "statement insert" it is
taken as multiple statements.
It
works fine now
Regards
Hi lists,
Can anybody tell explain me this:
We would re-create a controlfile to make a new copy of the database with
another name.
I tried to create a new db from existing database coldbackup . But I
tried to recrete with only one datafile i.e. system datafile.
I skipped all the remaining
Title: RE: Oracle on NT startup question
In UNIX there is not service process, but Win NT/2K requires it, something I discovered when I started to working on WIN env. Confusing if you do come from a UNIX env. Look at it this way the Service + the Database( Datafiles, redologs, controlfiles
with import you can give
CONSTRAINTS=N
Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 08:50 PM
I am trying
if nothing else works pick up all the tables based on the
CREATED value of dba_objects
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 2:13 PM
To: LazyDBA.com Discussion
Subject: How to Identify System Tables?
Hi
93 matches
Mail list logo
