Dear All,
ThAnks for all your comments and advise.
We have found what was the cause of this.
Just before we put tablespaces in hot backup mode we mount some nfs drives. Then
having placed the tbs in hot backup we use a cp command to copy the *.dbf files to
nfs. Also the copy of the controlfile
gracias
Ofer
-Original Message-
Sent: Monday, June 09, 2003 7:50 PM
To: Multiple recipients of list ORACLE-L
bell ;
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Saturday, June 07, 2003 11:44 PM
To: Multiple recipients of l
Ave !
Here is one possible solution.
Create two tiny scripts. First script let say ex.sql which includes only
word exit and linefeed and second one cont.sql which has only one space
character, nothing else. Then in Your sql script:
--
column NAME noprint new_value SCRIPT_NAME
select decode(name
You could use a little indirect approach in this case.
The file import.sql will look like this
set feed off
set lines 120
set trimpsool off
set pages 0
spool imp.sh
select 'imp un/[EMAIL PROTECTED] file=a.dmp full=yes'
from v$database
where name = 'TEST'
/
spoo off
exit
You have another script c
I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem. But JDBC Thin and MTS
worked fine on my Solaris box. Not sure with HP-UX. Is the Java application
running on an Application Server?
Richard Ji
-Original Message-
I have a script and can be run on commandline like:
> sqlplus /@TEST @import.sql
However, I want to check database name at the beginning of import.sql. I knew
"select name from v$database" can obtain database name. But how can I stop the
script if I found it is not TEST database? In impor
Dear All,
I need to install 9iR2 on Win2K Server/SP3.
Is it SP2 or SP3 ?
metalink docs say that SP1 or higher is OK.
but still found some queries posted on metalink regarding this.
"#$"##$ ...confused :-| !*"#$$
any serious issues known already ?!
TIA.
Jp.
--
Please see the official O
Hi Dear listers,
I'd like to ask your opinion about our possible new project.
overview; install fatwire for the whole community for web application. no
single point of failure, sun servers, oracle.
We have more than 10 divisions currently( different department, like arts,
dental, enginerring..
Thanx a lot bulbultyagt.
Jp.
17-06-2003 09:59:20, <[EMAIL PROTECTED]> wrote:
>Granting Object Privileges on Behalf of the Object Owner : The system
>privilege named GRANT ANY OBJECT PRIVILEGE allows you to grant object
>privileges as if you were the owner. However this a new feature in
>Oracle
Title: Re: 32 to 64 Bit Upgrade -- need info
Munish,
Essentially, you can use the same datafiles, controlfiles, and redologfiles. All of the PL/SQL has to be recompiled (including STANDARD and DBMS_STANDARD, which makes the task something of a chicken-and-egg situation)...
Short story: you n
I'm not a Java expert so please forgive me my ignorance. JDBC application
is facing very strange performance problems during connect. Every now and then
everything appears to be hung and then, 10 minutes later, users proceed
normally but with the elevated blood pressure and serious lack of patien
Note 223146.1 on MetaLink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc
"Goulet, Dick" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/16/2003 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Hello, bulbultyagi,
There's excellent note about session,connection,process from "aktom" ,take a look:
http://asktom.oracle.com/pls/ask/f?p=4950:8:312013611123160740::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5671284058977,
=== At 2003-06-16, 16:59:00 you wrote: ===
>Hello,
>I unable to
Granting Object Privileges on Behalf of the Object Owner : The system
privilege named GRANT ANY OBJECT PRIVILEGE allows you to grant object
privileges as if you were the owner. However this a new feature in
Oracle 9i release 2
Till then to grant an object privilege, you must fulfill one of the
fo
I don't know how it can have two columns with identical names. I know the X$
"tables" are unusual creatures but a duplicate column name goes against all
common sense. Perhaps one of them has a space at the end of the name? Or
else X$ tables aren't subject to the rules? Or else it's a bug in the
des
Hello,
I unable to understand a few concepts from the docs, can someone
explain them to me ?
While configuring the 'dispatchers' parameter in a shared server
(Oracle 9i release 2 on win32)
the options_clause is explained thus:
"SESSIONS (SES or SESS)
The maximum number of network sessions to allo
Gene,
I doubt the procedures followed for 9.2 are the same as 8.1; Partition
exchange does not move any data, merely resets the pointers inside the data
dictionary; so it should not take more than 1 second as you saw earlier.
Check if you were doing an ALTER TABLE TAB1 EXCHANGE PARTITION P1 WITH
Dennis, Stephane, Mladen, Raj and Peter,
Thankyou all for your comments. I was also a little concerned about
chaining and that's why I figured that renaming the existing table and
creating a new one might be a sensible approach. It simplifies the query
(SELECT's offer so much more flexiblity th
Peter,
Unfortunately the design is ok. I guess I should explain what the table
really is...
What I referred to as "students" are actually E-Tag transponders - little
devices stuck on car windscreens. Each time a car drives under a tollway
gantry the Tag is read and certain attributes of the ta
Did you say alter table exchange partition ... validate or alter table exchange
partition ... novalidate? If you say novalidate then Oracle will sort the exchange
table to make sure that you are not creating duplicate rows for the PK constraint.
There is a Metalink note on that.
Does the table h
Raj,
Thanks, however adding the attribute to this table is the correct thing to
do - it's a historical table to supply "show me something as at x date/time
for the particular record". Basically when originally created (years
before my time) someone assumed that a record would never be updated mo
Urr, well, hmm - this does seem to be a case for checking your design rather
carefully. With this volume of data floating about. Any TNF done on it? Once
upon a time I had to deal with a very large table not unlike this. Grossly
de-normalised it was. After a redesign spinning out a few new tables,
Thanks for the answer Ron,
the problem is that I don't see Dev Edition listed anymore ;(.
I dont't know whether RH will repeat this great offer- I didn't expected this offer to
be pulled
so quickly ;( That is why I am searching a way to get this software.
Best Regards
Milen Kulev
-Ursprüngl
Hi all:
We are having an interesting issue with the exchange
partition command in our shop. We are running oracle
9202 on AIX 5l. The exchange partition command used
to take about 1 sec (or less) in our old environmen
(oracle 81 Dynix 4.3.3). Now the same operation takes
about a minute and creates
I'm not sure. You may be right. I thought that it was Larry Ellison,
but then again, it's Monday and my memory is probably failing me.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 16, 2003 4:25 PM
To: Multiple recipients of
Thanks to all.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, June 16, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
The column CTIME in V$LOCK indicate that the time since the current lock
mode has been acquired/converted. The time is sh
That was McNealy that said HP was a great little printer company, wasn't it?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule detai
Rachel.
You know you are a DBA. (OOps dont happen in DBA world !!)
;)
(No offense meant)
-Arun.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, June 15, 2003 5:54 PM
> Okay, now I KNOW I need a vacation
>
> Sorry folks!
>
Okay, there's a variety of inaccuracies here.
1) "The (full cache), which is very expensive, is found on Symmetrix
boxes only" - not true. In fact, just about every storage system today
has some sort of protected write-back cache. This is true of hitachi,
clariion, symmetrix, netapp, etc. EMC'
Title: RE: V$LOCK definition
The time is in units of seconds -
-Arun.
- Original Message -
From:
Loughmiller, Greg
To: Multiple recipients of list ORACLE-L
Sent: Monday, June 16, 2003 1:34 PM
Subject: RE: V$LOCK definition
for some applications, it becomes expr
The column CTIME in V$LOCK indicate that the time since the current lock
mode has been acquired/converted. The time is shown in units of seconds.
--
Joe Frohne
Rawson Oaks Consulting
http://www.rawsonoaks.com
[EMAIL PROTECTED] or [EMAIL PROTECTED]
> Folks,
>
> Question here, the CTIME colu
When Larry met Carly? I don't know whether Carly is his type, but
that would be some marriage! I can still remember the fiery relationship
with Sandra Kurtzig, the former CEO of Ingres. Having in mind that HP
is a "great printer company", according to Larry, I doubt that the
relationship
would wor
There is another product called "EDBA(Enterprise DBA)" by Platinum
technology currently CA, which does the version control and comparison.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 7:13 AM
> Rahul,
> I believe you
Title: RE: V$LOCK definition
for some applications, it becomes expressed in terms of days
:-)
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 16, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
Subject: V$LOCK definition
Folks,
Folks,
Question here, the CTIME column in V$LOCK is expressed in what? Seconds,
milli-seconds, What?? Anyone know?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Melin,
Talking to the REdHat support people and the Dev edition was pulled
last week some time. If on the "buy it" page you see the RedHat AS
Developers edition you can still purchase it and download the ISO's with
a login and password.
Ron
>>> [EMAIL PROTECTED] 06/13/03 05:09PM >>>
Hallo list,
If you really want to free your mind, think of this. What if all this is
simply an illusion? We're stuck in the Matrix and if only we could free
ourselves from the tyranny of the machines (i.e. the evil RAID salesfolk et
al) we could liberate humanity and all our Oracle databases so that every
You forgot Traci Lords.
> -Original Message-
>
> A movie with Julia Roberts or Meg Ryan is what I had in mind.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fat
Soon? Soon?!
What's this "Soon" stuff?
SQL> show sga
Total System Global Area 2.3205E+10 bytes
Fixed Size 735296 bytes
Variable Size1728053248 bytes
Database Buffers 2.1475E+10 bytes
Redo Buffers1335296 bytes
A real pig of an app, but good
>- --- Original Message --- -
>From: "Gogala, Mladen" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 16 Jun 2003 06:44:18
>
>A movie with Julia Roberts or Meg Ryan is what I
>had in mind.
>
>Mladen Gogala
>Oracle DBA
>Phone:(203) 459
Title: RE: Re: Opinions of high-volume DDL and data population
... now from an entirely different angle ...
Mark,
It just _might_ be better if you create a separate table to store the pk from your students table and the total_attendance column. Why? Not only this column adding will be comp
Title: RE: World premier performance of the BAARF party logo
Well,
the way memory is growing, we'll soon have in-memory databases which will bring
the
ultimate victory to Cary by rendering the phrase "hit
ratio" meaningless. How's that for futuristic
thinking? To go even further, there might
Mark - Exclusive access? Man, do you live right. Of course this probably
means a weekend. One advantage of the CTAS is the opportunity to turn off
logging. Also, leaving the existing table in-situ would be a nice fallback,
a great point with a 37-gig. table. If you are licensed for it, this table
i
Mladen - Thanks for the clarification. Gee, does this mean no book? Well,
maybe the movie would be some compensation.
Cary - Thanks always for your willingness to share your knowledge. Looking
forward to your book.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Or
A movie with Julia Roberts or Meg Ryan is what I had in mind.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, June 16, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Mladen - Thanks for the clarification. Gee, does this mean
Thanks Mark
I also saved this.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, May 12, 2003 6:32 PM
> Bill,
>
> You can use TOAD Freeware version to compare two schemas (View/Schema
> Differences menu).
>
> As for table
Title: RE: World premier performance of the BAARF party logo
Putting on my futuristic thinking hat, I see a day not too far off when there won't be any Ds. RAID, as we know it, will go away.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Orig
There's a good document about this two interesting parameters:
http://www.evdbt.com/SearchIntelligenceCBO.doc
and also see "asktom"
http://asktom.oracle.com/pls/ask/f?p=4950:8:308736813964790489::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6601251003901,
=== At 2003-06-16, 04:37:00 you wrote
Indeed you are
right, but I'm sad to say we failed. After
180 or so people passed through the house on Saturday, we probably have MORE
alcohol than when we started. What can I
say? We'll have to have another party! J
Pete
"Controlling developers is like herding cats."
Kevin
Title: RE: Undo Analyze Table
Thank you all,
I'll test and see what helps,
Regards,
Hussain
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 16, 2003 5:37 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Undo Analyze Table
The answer is
The answer is found in the Jonathan Lewis book "Building Efficient Databases".
You should set OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING.
Explanation:
It is realistic to expect a part of an index to be cached and it is also
realistic to expect the index access to be somewhat cheaper the
Title: RE: version control for pl/sql dev forms etc.
Oracle SCM 9i
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Rahul,
I believe you have just described Oracle Software Configuration Manager (SCM) for
the Oracle Repository. It allows comparison of two forms or reports, also modules,
tables, entities etc. It's versioning is at the object level and it's rigorous.
Maggie
Respectfully,
> Maggie Tompki
You might try playing with different values for
optimizer_index_cost_adj.
If this is still at the default of 100, it may be allowing the
optimizer to consider the index more expensive than it should.
You can change this parameter at the session level, but may consider
testing to lower it system wid
I agree about the need for rebuilding. Your approach otherwise seems valid to me. That
said, if disk space is not a problem, can we assume safely that rollback space is no
problem either? In which case I would be quite tempted by taking a deep breath and try
to do it as a single 'Create table as
Analyze table ... delete statistics;
regards
Jo
Hussain Ahmed Qadri <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/16/2003 08:54
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Undo Analyze Table
Hi All,
There is duplicate column on table 'X$KSFMLIB'
and duplicate column is 'CAP_ELEM'
Can any one tell me that why this so and what is significant of this table.
SQL> desc X$KSFMLIB
Name Null?Type
- -
57 matches
Mail list logo