list, one of our clietns are going to by SAN, the
current oracle databases take around
36GB of storage i dnt understand there reason
to go for SAN, i sugguested to buy an external storage
box instead. How can i justify my desicion ? (cost
of not the factor)
TIA
rahul
Re :
1. How many of you do run, and are comfortable running,
multiple databases on the same server, whether it is
partitioned or not ?
2. Do you create a seperate ORACLE_HOME for
each instance ?
3. Do you just buy the Oracle DB CPU license on the
total number of CPUs on the server ?
The
Based on these two points:
The version is 8.1.7.1.0
The table is populated by sqlldr direct path.
I have a bit of gossip (i.e. someone I know
told me that someone he knows told him
that he'd heard that ...) there have been
cases where parallel execution slaves have
applied extent trimming in
Title: RE: LMT monitoring
Hi Milen,
1) Have you relinked the executables during installation phase(applying
stubs patch supplied by Oracle) ?
2) Create DB creating scripts with dbassist. Then perform each step
written in *.SQL *.sh files
separately, while watching ALERT.LOG. This approach
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2 recently.
The first problem was that the init_sid.ora file was created a directory different
from where the db create scripts were looking for it. The second problem was that
one of the init
Dear All,
I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the
tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go
straight for the 9i OCP DBA title, with regard to the complexities of the exam.
Thanks in advance for all your help and
Yeah, OK, the 50 figure was just to provoke some responses :-). I'll go
ahead and watch the various v$ views as I increase the cursor level, and see
if there's anything nasty there (I'm not expecting any problems).
Ciao
Fuzzy
:-)
-Original Message-
Sent: Tuesday, March 11, 2003
Undskyld, I should have added a wide ironic smily. I am very much aware
of the far too many poorly written applications out there - you are sometimes
amazed that even large software producing companies seem to thoroughly make
every effort to produce bad code or simply ignore well established
List,
OS RedHat 7.3
Oeacle 8.1.7 rel3
I have had a disk failure on my test box and a datafile needs to be
recovered from my tape backup. The tape contains 6 large datafiles and I
get errors after reading the first one.
Does anyone know the linux FTP option to --ignore-read-errors? The man
Jay,
One thing to consider is that just starting the 9i track and if you've not taken any
OCP exams prior to September of 2002, there is a requirement to attend one 9i training
class in addition to the exams. However (you'll probably need to call Oracle to get a
solid answer to this), if you
Got the overall the nitty on our ratio
15 Dbas in all
1 DBA : 200 Sqlserver databases :) ( Management loves that ratio)
10 DBA: 100 Unix Oracle Databases, 10 NT Oracle DB :)
4 DBA : 40 DB2 and 43 Teradata databases
See that SQLSERVER Database ratio... show that to your boss.. make him sing
Hi
Gurus,
Just
developed a form using Oracle Forms 6i but the form display very quickly
in the Web Browser and disappears. The form however runs very well using Oracle
Forms Run Time.
I have
set the RunTime environment and the HTTP Server is running.
What
could be the problem?
Moses
This
On Wed, Mar 12, 2003 at 04:48:42AM -0800, Ron Rogers wrote:
List,
OS RedHat 7.3
Oeacle 8.1.7 rel3
I have had a disk failure on my test box and a datafile needs to be
recovered from my tape backup. The tape contains 6 large datafiles and I
get errors after reading the first one.
Does
I didnt realize that you might be able to do the 8i one without handing $2k to oracle
for their class and taking the upgrade exams is a better path.
anyone know if this is possible? You only need to get 50% of the questions right on
the upgrade tests.
From: Darrell Landrum [EMAIL
Can youshare some ofthereasons
related to your decision in choosing a direct-attach storage(DAS) instead
of a SAN? In general, a SAN is a much smarter choice than
DAS.
- Original Message -
From:
Rahul
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
Hi World!
What this mean:
ALTER USERusername DEFAULT ROLE ALL;
Thanks
Ed Dorma
Don't think "space". Think "throughput
rates". Read rates, write rates, peak rates, sustained
rates.Press the vendors on those issues, not manageability and
capacity. Don't measure $/Gb, but $/Gb/sec.
Good luck!
- Original Message -
From:
Amit
Nargotra
To: Multiple
If you've developed the form on a Windows client and are running the Forms
Server [web forms]
on a Unix server, try regenerating the .fmx on the Unix server using f60genm
Hemant
At 05:08 AM 12-03-03 -0800, you wrote:
Hi Gurus,
Just developed a form using Oracle Forms 6i but the form display
You only need to get 50% of the questions right on the upgrade tests.
Why not set the goal to it get 100% right? ;)
- Kirti
-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
I didnt realize that you might be able to do the 8i one
Title: Message
That
all the roles that the user has assigned get enabled when he logs
on.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Edouard
DormidontovSent: Wednesday, March 12, 2003 8:39 AMTo:
Multiple recipients of list
The man page for the Linux tar command mentions a --ignore-failed-read
option. Is that what you're looking for? The ftp command isn't usually
used with tape drives...
Kind of upsetting that Linux doesn't seem to have the trusty old mt
program, which allowed all kinds of magtape manipulation...
You are correct. I ment the TAR option.
With the listing for TAR and GTAR there is no option listed for
--ignore-failed-read do not exit with nonzero on unreadable files
as there is for -v, --verbose. That is the problem I am having. What
option character to use to ignore errors.
Thanks,
Ron
I
That
sets all roles assigned to the username as it's default and are in effect at the
same time whenever username logs in.
-
Kirti
-Original Message-From: Edouard Dormidontov
[mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 7:39
AMTo: Multiple recipients of list
Title: RE: Re: OCP
So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam?
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re:
Rahul,
We're heading out onto the SAN route as well from the external storage
world. Right now we use a number of HP-UX servers connected to one of two EMC
symmetrix arrays for datafiles and one of two NetApp Filers for archive redo
logs. They work well, but the EMC's are expensive and
Something l would try in that position is
create stored outline on ...
your select statement in 8.1.6
Then select from user_outline_hints
to find what hints Oracle had generated
in the fast plan. Then write the same
set of hints into the SQL in 9.2 (or even
export/import the hints) -
I used to
ps -ef | grep ora
That would also show me if my listener was up.
manoj.gurnani
Am Mit, 2003-03-12 um 14.39 schrieb Tim Gorman:
The man page for the Linux tar command mentions a --ignore-failed-read
option. Is that what you're looking for? The ftp command isn't usually
used with tape drives...
Kind of upsetting that Linux doesn't seem to have the trusty old mt
Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2 recently.
The first problem was that the init_sid.ora file was created a directory different
from where the db create scripts
Paula,
When you completed the OCP exams, you were given a report card that
was stamped and sealed by the test provider with a passed notation.
After you have completed all of the requirements for the particular
track you were taking you should receive a certificate and card from the
Oracle Corp.
Jai
An important part of the OCP is what it means to others, that is people
you work for, people that will read your resume. Do you see a possibility
that having both 8i and 9i on your resume would be a benefit. For example if
a hiring manager specifies Oracle8i OCP, and company policy
Tim - Can you elaborate on those reasons? Our administrators feel DAS is
usually much cheaper, and they are not convinced the SAN performance is
there.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 12, 2003 7:34 AM
50% ?? You're joshing me!
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
I didnt realize that you might be able to do the 8i one without handing $2k
to oracle
Amen brother Tim
We have never had space issues here, but we regularly have I/O
performance issues. Get your organization on-board with
performance-based metrics for disks instead of GB-based metrics.
Good luck
Stephen
[EMAIL PROTECTED] 03/12/03 06:33AM
Don't think space. Think
Title: RE: OCP
I thought it was better on principal of not wanting to spend the $2K for a class.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP
Jai
An
Dick ... did you have problems with Netapps on your archivelogs or
just the datafiles or both??
We are considering using it for alternative archivelog solution...
Last place we were at we did have a few issue with datafiles but it
got worked out and worked fine after that.
Brian
Silly me! Of course mt would be available somewhere. Just because I
don't have it at the moment doesn't mean it isn't available! Thanks
Christolph!
Hallelujah open source!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003
Thanks Jonathan,
what is meaning of recursive depth ? I see calls to cdef$, seq$
tables/views does it hint something . I though procedure is using some
sequence and these are internal calls to generate seq numbers . Is that rite
?
-ak
- Original Message -
To: Multiple recipients of
On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote:
Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2 recently.
The first problem was that the
Brian,
NetApps work just great for archive redo logs, their just an NFS mount. The
problem we have had is getting things configured for Datafiles. If your use to
a DAS system where you have the server and external disks, you have SCSI or
Fiber cables between the two as dedicated
Brian
I'm not Dick, but will respond anyway. We use a Netapp for our test
system and it works fine for that. My experience has been that it is quite
dependent on your network configuration (dedicated 100baseT as minimum), and
multiple simultaneous reads and writes seems to bog it down. I would
Thanks for the response. I did locate the mt command and tried to
advance to tape to the 5 file count and I received Input/Output errors
anf the operation stopped. I guess the tape is shot and I will have to
recreate the datafile and tablespace.
Thanks to all.
Ron
[EMAIL PROTECTED] 03/12/03
Title: Message
I think there are a couple of ways you can do this. Firstly, if you
ring Prometric and try to register for the 9iUpgrade exam. IIRC,
they'll ask you for your SSN and their system should reject you if you don't
have the necessary pre-req certification. Secondly, you can send an
The examples you have given are SYS-recursive,
The call to cdef$ is Oracle looking for some information
about constraints (one possibility is that you keep breaking
a PK or UK constraint and Oracle has to keep looking up
the name of the constraint because it doesn't cache constraint
names).
The
An action with dep=n+1 (n=0) for cursor #k is the recursive child of the
next dep=n action for cursor #k that immediately follows in the trace data.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10
Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell:
On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote:
Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2
It might be a tape problem, but I think it is unusual for a tape to be this
hosed without errors being generated when the backup was created. If it is
known that a backup was created without errors on this tape, and the tape
has not been mishandled since then, then my first question would be: At
Thanks Jonathan for the information . Let me go through raw -trace file once
more to get info . Everytime I go through it I find something interesting .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 8:54 AM
The
Dick Goulet gave an excellent response to the list earlier -- I'd second him
on each point he made.
There is no doubt that DAS is cheaper on the original purchase, because
you're only buying the disk. Obviously, a SAN has a few more bits of iron
and wire. But have those administrators toted up
Title: Queue_message wait event
Hi all,
Does anyone know how to tackle this one? Developers are complaining that (it appears) the de-queuing is slow.
DB is 9202
aq_tm_processes = 5
job_queue_processes = 4
_job_queue_interval = 3
SQL select * from gv$aq where qid in (44673,42358);
Pete - You've made my day. We had some education money to use or lose last
fall, and the 9i New Features class was offered locally. I thought I might
be able to take the upgrade class even though I hadn't completed the 8i
route. December is not a good month for finding study time, so I shelved
I'm suffering from a senior moment.
The question is at the every bottom.
SQL select sql_text from v$sqlarea sa where buffer_gets 1
SQL_TEXT
SELECT RP.RELPART FROM OERELPART RP, PARTOFFERING PO, PART P
I've had this problem on linux. Best and fastest solution: reboot the
server. There is a memory issue preventing you from starting oracle. I
just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and
now I can start the db.
-Candi
On Wed, 2003-03-12 at 12:07, Schwerdtfeger,
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized. About 1/3 of the production
databases have at least 1 (usually more) development effort going on at
v$session.sql_hash_value = v$sqlarea.hash_value
or
v$session.sql_address = v$sqlarea.address
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 10:18 AM
I'm suffering from a senior moment.
The question is at the every
All-
I am researching the technology of the Internet Directory. Does anyone
have experience with this? I am currently using tnsnames files on all
my boxes, I am running on Unix. I realize this directory would replace
the tnsnames files but lots of confusion on how it works.
1. Would the
Join sql_address from v$session to address from v$sqlarea .
Regards,
Denny
Quoting [EMAIL PROTECTED]:
I'm suffering from a senior moment.
The question is at the every bottom.
SQL select sql_text from v$sqlarea sa where buffer_gets 1
SQL_TEXT
Perhaps this is what you're looking for?
select sql_text ,sid, username, osuser, logon_time
from v$sqlarea sa, v$session ss
where sa.buffer_gets 1-- that's a lot of gets!
and sa.hash_value = ss.sql_hash_value;
HTH! GL! :)
Rich
Rich Jesse
How about:
SELECT a.sid,
a.username,
c.disk_reads,
c.buffer_gets,
c.sorts,
c.executions,
c.rows_processed,
c.sql_text
FROM v$session a,
v$sqlarea c
WHERE a.sid = sessid
AND a.sql_address = c.address
-- AND a.SQL_HASH_VALUE =
yup.. we haven't been bitten but we know the day is coming when its going
to happen...
I'm still looking for a trick or rule of thumb to help avoid the problem
of over allocating that mount point at 3:00AM.
So far what I have done only put tempfiles on the mount point not
other datafile. Put
Interesting question.
I'll throw out another guess that Oracle has extra checking to do to either
retain the first extent or perhaps recreate it (whereas drop just gets rid
of all extents)?
Comparing the results of a SQL Trace or Event 10046 on drop and truncate
could be interesting.
Jay Miller
Bingo! One of the reasons my team lead wants a SAN in here is to limit the
vast amounts of wasted storage (wasted storage = wasted $$$)we have on our
individual disparate systems. That savings must be weighed against the
downsides of a SAN, such as the possibility of I/O contention and the
Stephen,
All of your questions are solid diagnostic inquiries. I have not
changed anything on my backup script and it is a simple TAR -cvf
/dev/st0 files...
and I can read the other tapes okay. I can read the first file header
on the tape okay. I tried a different tape drive and received the same
charlie I think sqlarea and session has no direct relationship . Same sql
can belong to many sessions and columns like users_opening, users_executing
suggests this. There should be one entry in sqlarea per hashaddress I guess
.
may user v$open_cursors to join with addess and sid .
-ak
-
We have over 400 databases, 90%+ are Oracle under various versions, platforms.
Today have 19 DBAs. Two weeks from now there will be 17.
Rightsizing to continue in the 2nd Quarter
- Kirti
-Original Message-
Sent: Wednesday, March 12, 2003 12:09 PM
To: Multiple recipients of
Title: Forcing 2 Decimal Positions
I know this must be extremely simple, but the only thing I can find for this is column format and that doesn't work, so could someone tell me how to force an amount field to show 2 decimal positions? I have tried format 999.99 and 990.00 but it will not
Title: Forcing 2 Decimal Positions
select to_char(your_number, '.90')
from dual
/
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts, having an opinion
From Window A
SQL /
SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES
CONSISTENT_CHANGES
-- -- --- -- -
--
169838526512700725 22864266596
18526
173 182492
[EMAIL PROTECTED] wrote:
I'm suffering from a senior moment.
The question is at the every bottom.
SQL select sql_text from v$sqlarea sa where buffer_gets 1
SQL_TEXT
SELECT RP.RELPART FROM
Title: RE: Forcing 2 Decimal Positions
That's funny, the 00 works for me. See example below (note that my decimal parameter is , not . because of my local settings)
SQL select
2 price,
3 to_char (price, '90D00') as price2
4 from
5 (select 20 as price from dual
6 union all
7 select 20 /
Title: RE: Forcing 2 Decimal Positions
Or if your question was relating to the COLUMN ... FORMAT SQL*Plus command, 99 works for me (again my decimal separator is , because of local settings) using SQL*Plus 8.1.7
SQL column price format 90D99
SQL select 20 as price from dual
2 union all
3
Title: RE: POLL: Database to DBA ratio
350 Oracle Databases spread across US and Europe.
14 full time, 4 part time.
75% of applications are designed and built in-house.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 1:59 PM
To:
Title: RE: POLL: Database to DBA ratio
We have 4 production Oracle databases and 3 DBA's.
Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines.
--Walt Weaver
Bozeman, Montana
-Original Message-
Title: Queue_message wait event
Raj,
I assume you are using persistent queues. Each
queue resides on a queue table that is nothing more than a normal table
subjected to the same problems. By default the queue tables are created with
INITRANS 1 and FREELISTS 1, like regular table.
You have
Title: Forcing 2 Decimal Positions
Thanks.
This worked wonderfully!!
-Original Message-
From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003
1:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Forcing 2 Decimal
Positions
select
That sets all roles assigned to the username as it's default and are in
effect at the same time whenever username logs in.
- Kirti
-Original Message-
Sent: Wednesday, March 12, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L
Hi World!
What this mean:
ALTER USER username
I think there are a couple of ways you can do this. Firstly, if you ring
Prometric and try to register for the 9i Upgrade exam. IIRC, they'll ask
you for your SSN and their system should reject you if you don't have the
necessary pre-req certification. Secondly, you can send an email to
[EMAIL
Don't think space. Think throughput rates. Read rates, write rates,
peak rates, sustained rates. Press the vendors on those issues, not
manageability and capacity. Don't measure $/Gb, but $/Gb/sec.
Good luck!
- Original Message -
To: Multiple recipients of list ORACLE-L
Dick ... did you have problems with Netapps on your archivelogs or
just the datafiles or both??
We are considering using it for alternative archivelog solution...
Last place we were at we did have a few issue with datafiles but it
got worked out and worked fine after that.
Brian
Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2 recently.
The first problem was that the init_sid.ora file was created a directory
different from where the db create scripts were
Bingo! One of the reasons my team lead wants a SAN in here is to limit the
vast amounts of wasted storage (wasted storage = wasted $$$)we have on our
individual disparate systems. That savings must be weighed against the
downsides of a SAN, such as the possibility of I/O contention and the
How about:
SELECT a.sid,
a.username,
c.disk_reads,
c.buffer_gets,
c.sorts,
c.executions,
c.rows_processed,
c.sql_text
FROM v$session a,
v$sqlarea c
WHERE a.sid = sessid
AND a.sql_address = c.address
-- AND a.SQL_HASH_VALUE
You only need to get 50% of the questions right on the upgrade tests.
Why not set the goal to it get 100% right? ;)
- Kirti
-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
I didnt realize that you might be able to do the 8i one
Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell:
On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph wrote:
Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
I had the same error message on NT with Oracle 9.2
It might be a tape problem, but I think it is unusual for a tape to be this
hosed without errors being generated when the backup was created. If it is
known that a backup was created without errors on this tape, and the tape
has not been mishandled since then, then my first question would be: At
Title: Forcing 2 Decimal Positions
Laura,
It woroks for me.
SQL select to_char(clusterid,'9.90') from
t;
TO_CHAR(C- 1234.89
1234.80
SQL select clusterid from t;
CLUSTERID--
1234.89 1234.8
SQL col clusterid format 9.90SQL
/
CLUSTERID- 1234.89
1234.80
Join sql_address from v$session to address from v$sqlarea .
Regards,
Denny
Quoting [EMAIL PROTECTED]:
I'm suffering from a senior moment.
The question is at the every bottom.
SQL select sql_text from v$sqlarea sa where buffer_gets 1
SQL_TEXT
All-
I am researching the technology of the Internet Directory. Does anyone
have experience with this? I am currently using tnsnames files on all
my boxes, I am running on Unix. I realize this directory would replace
the tnsnames files but lots of confusion on how it works.
1. Would the
Jacques Kilchoer wrote:
Or if your question was relating to the COLUMN ... FORMAT SQL*Plus
command, 99 works for me (again my decimal separator is , because of
local settings) using SQL*Plus 8.1.7
SQL column price format 90D99
SQL select 20 as price from dual
2 union all
3 select
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size
from very small (1 GB) to production-sized. About 1/3 of the production
databases have at least 1 (usually more) development effort going on at
If you've developed the form on a Windows client and are running the Forms
Server [web forms]
on a Unix server, try regenerating the .fmx on the Unix server using
f60genm
Hemant
At 05:08 AM 12-03-03 -0800, you wrote:
Hi Gurus,
Just developed a form using Oracle Forms 6i but the form display
I've had this problem on linux. Best and fastest solution: reboot the
server. There is a memory issue preventing you from starting oracle. I
just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and
now I can start the db.
-Candi
On Wed, 2003-03-12 at 12:07, Schwerdtfeger,
Title: Message
Not
mention the afternoons at Big Sky and Bridger working as a ski run quality
assurance tester! ; )
Rick
Weiss
--
Helena, Montana
We
know better
-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003
12:51To:
I need to be able to refresh the data in the tables belonging to out test
database without destroying, changing, or adding any other type of database
object. The data will come from the production database. I am having a
problem specifically with triggers. I don't want to add, change or delete
Hey LeRoy (Go Badgers! Go Panthers!),
1. That's what Oracle claims, but only if you have the Advanced Security
option, which you must purchase.
2. It depends on the box, the version of OS, and other factors. For
example, LDAP authentication will not work on HP/UX 11.0 with the Trusted
System
Well, I'll add my $00.02 worth.
I have about 15 databases, more or less. It varies depending on
what's going on. Right now it's more. :)
They are on NT, Win2k, Solaris and Linux.
Sizes range from a few gig to 450 gig.
In addition, I own IT change control ( Oh joy ), and a
few other
I run into this every time I stop 9.2 on Linux.
No need to reboot. Just use ipcrm to remove the
offending SHM segments.
If you don't know which ones, use ORADEBUG to
find the segments you shouldn't remove from other
running databases.
Or just shutdown all instances and remove any
SHM owned by
I'd twelfth (or whatever number we are upto by now) the comments so far
on how it isn't a fair measure. For what its worth we now have 19 Oracle
instances and 7 sql server databases, probably 50+ schemas. You can take
your pick as to what you mean by database. We have 3 dbas. One thing
that does
Are those pages real production issues?
How much is fire fighting work?
Brian
-Original Message-
Sent: Wednesday, March 12, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP
to 800 GB data warehouses.
Hi,
We need to bring the LDAP data into oracle tables under 8.1.7(Not 9i) and join with
some other tables, which already exist in the Oracle 8.1.7 database to generate
reports.
I was wondering if we can use some tool to reverse engineer the LDAP data ad get table
structures.
Any idea.
1 - 100 of 142 matches
Mail list logo