I think I am having problems with my redologs. Under normal circumstances no
errors arise, but if I do a massive import of data as I was doing last night, this is
what alertSID.log shows from time to time:
Wed Apr 2 23:29:52 2003
Thread 1 advanced to log sequence 557295
Current log#
Title: 9i startup on Linux
Hi!
I am having problems getting 9.2.0.3 started on Red Hat Linux 8. I've done the standard linking in rc3.d and the like.
But when I reboot the machine, Oracle is not automatically started when using an SPFILE. If I dump the spfile to a text
Peter,
An option you might want to investigate writing your script command file,
using the W2K resource kit utility, (can't think of it's name right now, to
convert it to a service. Set service to startup automatically and then
create a dependency on Oracle service for this new service to
It's more accurate to say SQL Server *can be* case sensitive ... or not, as
desired and configured. The kicker is as you describe ... if it's set to be
case sensitive instead of insensitive, all object names, column names, etc.
are treated that way, not just strings in char, varchar and similar
The create view does not access the data at all. It just create an object in
the data dictionary.
What you need to compare is 'select * from view' against doing the select
from sqlplus.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
It can be Unix as well as Windows. As I have to support various DB's
Best Regards
Ramesh D. Papnoihttp://www22.brinkster.com/rpapnoi
(Brainbench Brainbuzz certified Oracle 8/8i DBA Developer)
-Original Message-
Adar
Sent: Thursday, April 03, 2003 2:39 PM
To: Multiple recipients
You did not mentioned what OS you are working on.
If the remote database is on your network, even via wan, you can activate
all the tools from your desktop.
We use RAS to connect to remote servers without network connections and then
you have SLOW network connection and your tools will work.
If
Thanks all for ur feedback. I would add little more into it now. Now as far
as Administering is concerned it can be done on any OS Well!.
How about Backup and recovery, because it requires the Manual steps as to
change tapes etc and How the Remote System Administrator co-ordinates with
Hallo,
anone whom could explain what new. means
in this pl/sql procedure.
for instance: new.kundeoms := new.kundeoms + (in_diff);
new.mva := new.mva + (in_diff_mva);
How do I get hold of it so i can see which sql it runsor is new.kundeoms just a value
from a table?
I don't believe that was the case. auto and uniform
in all of the (admittedly rudimentary and subjective)
tests I've done appear the same in terms of
performance.
I prefer uniform purely for the reasons of:
- more thorough elimination of fragmentation
- predictability of next extent sizes
hth
Basically as the message suggests the redo cannot be
recycled until the checkpoint has completed flushing
out the cache.
A *workaround* is to add redo log (size or number) but
its really a heads-up about your I/O subsystem not
being up to keep up under stress.
hth
connor
--- Fermin Bernaus
This happened to me once - when I was mistakenly ran the script as SYSTEM
instead of SYS/internal. Any chance somebody did this on your DB (a long
shot I know)?
_
Tim Onions
Head of Oracle and Web Development
Speech Machines (A MedQuist Company)
...the
instance recovery time is more manageable in 9i --
mttr_fast_start_target in the init.ora.
For a time, in version 6, Oracle said you HAD to use shutdown abort,
that a shutdown immediate could corrupt the database (that was an
undocumented feature)
I've had cases where the regular, automated
Perhaps you need to do a trace to determine the real cause of you
problems. Full table scans are not necessarily the problem. When you have
trace for the program and the explain plain you have of the executing SQL
you will have a better idea than assuming you need indexes to stop full
table
Mark has hit on the crux of the issue. Most of us have expectations
from users and management that we will have the databases available as
much as possible. Downtime costs money and should be avoided.
That said, we will eventually need downtime for one reason or another.
The question becomes
Is this procedure being run with a trigger Roland?
If so then the :new refers to the value of each row that is being inserted from the
table
To explain better
if an update triggger is on table roland with columns (road,town,country) and one row
is in the table with values Main Rd, Leeds,
Good Posting, JIM .
I had once gone thru the exactly same experience.
Oracle database has some processes that work both independently , but
again, they work in tandem. Here is the peice where LGWR (in Archivelog) and
ARCH(s) are expected to work in tandem with each other (in ARCHIVELOG mode).
Ramesh, since in your sig line you say you're brainbench and brainbuzz
certified, do you really think those tests have any meaning, i took them
and thought they were a joke.
joe
Ramesh Papnoi wrote:
It can be Unix as well as Windows. As I have to support various DB's
Best Regards
Ramesh D.
Title: RE: Oh Dear, Mr. Ellison's at it again
19th
Century... electric cars were being made in the late 1800s... not much progress
since.
:
)
Pat.
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003 4:04
PMTo: Multiple recipients
Hi James,
Hopefully the other lesson you've learnt is the importance of
training, even for Junior DBAs so that such fundamentally basic but
potentially costly mistakes can be avoided.
Cheers
Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
At least at Joe's down the road I used to make tips? Dice proudly rewarded
me with this posting last night
Title: SAP Database Administrator
Skills: SAP, UNIX, Solaris, Oracle
Date: 4-2-2003
Location: Dallas, TX
Area code: 214
Tax term: CON_W2
Pay rate: $22.23/HOURLY - $22.23/HOURLY
Hi Arvind,
A little test for you.
You have a table that contains 10,000,000 rows that is packed tightly
into 1,000,000 data blocks.
You have an index that has a level of 4 and has 10,000 leaf blocks.
The table is well striped across a number of devices and you have 4
CPUs on the box.
You
Title: RE: oracle full table scan
To answer the original question ...
1. use following query to see which tables are part of FTS ... it is a point in time information. (Query from www.ixora.com I think).
SELECT usr.name oowner, ob.name oname
FROM ( SELECT obj
FROM sys.X_$BH
WHERE
New maybe a Package and the Variables may be Public variables.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-Original Message-
John, Tech Dev
Sent: Thursday, April 03, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Is this procedure being run with a
Hi
I would suggest to increase the redo log size. Doesn't effect you during
daily operation, but prevents the database from hanging during nightly
batches. No side effects I can think of (except for the fact that, of
course, it will take you longer to backup the archived logs since the files
are
Jared,
Thanks for the reply. I will try next time. I just feel like combine
the reuse and set together, seems not that logical.
Thanks,
Joan
[EMAIL PROTECTED] wrote:
From TFM:
Specify REUSE to indicate that existing control files identified by the
initialization
parameter
Chris,
We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.
Joan
Chris Berry wrote:
Schauss, Peter wrote:
I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system
Hi Arvind,
I don't judge full table scan is good or not necessary bad.
this is the script might answer your question.
-joan
The following scripts provide information on the full table scan
activity.
If your application is OLTP only, having long full table scans can be an
indicator of having
Hello Arvind,
Thursday, April 3, 2003, 5:58:38 AM, you wrote:
AK Dear All,
AK is there any way to find which tables (table name) are suffering from
AK full table scan ,so that i can create indexes on them to enhance the
AK performance.
AK Thanks
AK Arvind
AK --
AK Please see the
I am certainly not suggesting that recovery can't handle a crash--I'm just
trying to make sure that I understand what shutdown abort does. Some posts
have implied that it's no big deal, which is counter-intuitive to me. To
me, crashing a program on purpose seems like a drastic measure. No doubt
Fermin - Connor's reply sparked an idea. By any chance do you have your redo
logs on the same device as your data files?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 03, 2003 5:04 AM
To: Multiple recipients of list
Nelson, have you tried the free TightVNC from http://www.tightvnc.com ? It
has a few performance features that seem to work slightly better than the
standard VNC, especially over slower links like VPN over a 768Kb DSL.
I've been about as happy as I can be with TightVNC for my setup.
Rich
Rich
I dissagree, they will be bigger but there will be less of them. If the amount
of processed data does not change, I do not think changing the size of the redolog
files should affect the total amount fo bytes to be backeup up
Thanks for the recommendation anyway ;)
Guys,
What is the purpose of OraclePeerSNMPMasterAgent Service ?
It is listed in the o/s SERVICES list.
I need to administer an oracle instance on server A from
server B with DBA Studio.
For this to be done , do i need OraclePeerSNMPMasterAgent running
on server A.
will stopping this service ,
the problem is, if immediate hangs and you have automated the
process... nothing happens. it doesn't time out so you sit. and sit and
sit. and hope that whatever is keeping the database active will
eventually end.
In version 7 (7.3.2) I found that while using a third party monitoring
package that
Tables are not suffering, they're rather cruel and coldhearted.
As in the Tom Godwin's story, The Cold Equations, it's always
the users who pay the price. You might try with tuning the SQL
statements that access tables. Occasionally, that does the trick.
-Original Message-
Sent:
Arvind - If you want to locate tables that are being scanned and the SQL
statement, I have found the following script posted by Mohammed to work
quite effectively.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
REM From: Mohammed Shakir [mailto:[EMAIL PROTECTED]
REM
Hi
all
Can any body
help in answering these questions
1. What features of Oracle
9i do you recommend to use? Why?
2. What are the features
of Oracle 9i you do not recommend? Why?
3. Have you had any
problems with any of the Oracle 9i features? Please elaborate. If any, how did
you
Oh, I wan't advocating a kill -9, just comparing it to a shutdown abort.
AFAICT (as far as I can tell) there isn't a great deal of difference. I
did, once on Oracle 7.3, have to shutdown the db with a shutdown abort
and then just could never get it to open again. Could not recover it
and
Title: 9i startup on Linux
Well,
there is this little file called "/etc/oratab" and the dbca leaves a value of
"N" in the last field.
The
allowed values are "N" for No, "Y" for Yes and M for Maybe. The last field
is there to determine
whether dbstart should start the oracle instance or
Using immediate or abort is a matter of personal preference. Use whichever
option that works for you. But I would not agree that using shutdown abort is
risky or should be avoided. (I don't know of any bugs with shutdown abort.
There could be, but then a lot of other things also could go
Say what you think Joe,
When I have been looking for contacts several agencies have asked me to take those
tests as a means of ensuring that I know what I am supposed to know.
They act as a pre-interview filter
If it sorts the wheat from the chaff then I don't think they perform a bad service in
Title: Message
The
performance of JDBC OCI vs Thin really depends on what you are trying to
do. Thin driver can perform better
than
OCI and in some situations doesn't. Also there are limitations in Thin
driver such as you can't return
a
PL/SQL table using Thin driver, you can't do TAF etc.
Things like :new.value and :old.value are commonly associated
with the beasts called triggers. You can find triggers on oracle
tables and guns. For the rest, please read the fine manual.
-Original Message-
Sent: Thursday, April 03, 2003 5:09 AM
To: Multiple recipients of list ORACLE-L
Dear List,
I have a database with 500 tables I want to put these tables based on size
to Three different TBS,Small size tables less than 5 M on TBS1 with extend
size 160K ,Tables less than 160 M and bigger than 5 M on TBS2 with extend
size 5 M and tables bigger than 160 M on TBS3 with extend size
Our RMAN backup is backing up much more than the actual data blocks when
doing a full backup. I know that it backs up all blocks that have ever been
used, but I'm trying to figure out exactly what that means. My first
thought was that it backs up all blocks below the HWM, but I analyzed the
tables
I hope someone on the list can help.
Environment:
Oracle
9.2.0.1
Red Hat Linux
Im in the process of trying to connect to a Progress database via Java
Stored Procedures in Oracle 9.2.0.1.
The Progress JDBC driver is a type 2 driver, which means that it has shared
libraries that it
We're running Oracle 8.0.5 for 3 years now
and want to go to Oracle9i.
Should I
a) upgrade OR
b) exp the db and do an install of 9i then imp
(this is a lenghty process)
what say you? TIA.
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Leyden, Joseph
INET:
Rick - In Java Programming for Oracle by Don Bales, he ran some comparative
tests showing the comparative advantages of each interface under different
circumstances.
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
H
Gurus,
I am running Oracle 8.1.7.4.1 on a Win2K Advanced Server platform using 2 ZEON P4
processors.
The problem I have is that when I stop the Service for the DB (OracleServiceLIMS), it
crashes the database instead of performing a clean shutdown.
The registry entry is set to allow 5 minutes
John - Thanks for the encouragement. I'll get cracking on the next exam this
weekend!!
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 03, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Say what you think Joe,
Hamid
Be sure to read How to Stop Defragmenting and Start Living very
carefully so you really understand the concepts. These concepts free you
from being overly concerned about details.
Myself, I try to plan for 1 year of growth. The future gets too
unpredictable past that.
Dennis Williams
Keith
Here is my understanding (don't rely on this one). When Oracle allocates
tablespace, the disk blocks are cleared. My interpretation is that when RMAN
encounters a clear block, it doesn't write it to the backup piece. I don't
think it spends a lot of time trying to figure out above HWM and
Vivek,
Answers to your questions embedded. You may want to
read up on the manuals for more details. BTW, you
don't have to copy my e-mail id in your replies, given
that I belong to the list, just as many others. I am
trying to avoid getting 2 copies of every e-mail that
you send.
Cheers,
Gaja
Totally agree with Connor. Just to add a comment to
his note.
A usage model recommended for UNIFORM vs. AUTOALLOCATE
follows:
If you know the data volume and growth of your
segments and they are predictable, then use UNIFORM.
If you are completely in the dark with:
1) How much data is going
Hi,
I have been grappling with this for sometime
I have a table a_user_groups
USER_ID SECURITY_GROUP_ID GROUP_ID
-- - --
1005 1012 1010
1005 1012 1011
1006 1013 1010
1007
Correct.
The only potential disadvantage is that recovery will take longer when
bringing up the database after a crash.
Jay Miller
-Original Message-
Sent: Thursday, April 03, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
I dissagree, they will be bigger but there
Barb,
This isn't an Oracle limitation. It's a Sun HA limitation. Oracle 9i
will run on Sun Solaris HA 2.2, with no problem. We've installed it and
built an instance and run it. The problem comes in when you want to HA monitor
the database. HA 2.2 won't even run when it gets to the Oracle 9i
Raj,
Indexing small tables is a good thing if you are doing single row lookups.
An index read and lookup by rowid is much more scalable than
doing an FTS, even if the table is only 2 blocks.
Jared
Jamadagni, Rajendra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 05:28 AM
Title: RE: oracle full table scan
Thanks Jared,
What if my developer is selecting all or most of the records from the table and not all the columns in the select list are in the index that should have been used?
I understand your point, in fact to use Jonathan's words .. should a small
Comparing users to Marilyn Cross.
Naive, not overly bright, sentenced to death.
Is that too harsh for users?
Jared
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 07:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
SQL*Server doesn't crash, it's a disorganized retreat. *-)
Dick Goulet
-Original Message-
Sent: Wednesday, April 02, 2003 11:14 PM
To: Multiple recipients of list ORACLE-L
Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ?
-Mensaje original-
De: Rachel
Hi,
Sorry for reposting.
Just wanted to put in a subject...
I have been grappling with this for sometime and thought it will be best
for others to take a look at it.
I have a table a_user_groups
USER_ID SECURITY_GROUP_ID GROUP_ID
-- - --
1005
Jared, I like you more and more every day.
-Original Message-
Sent: Thursday, April 03, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L
Comparing users to Marilyn Cross.
Naive, not overly bright, sentenced to death.
Is that too harsh for users?
Jared
Gogala, Mladen [EMAIL
Jamadagni, Rajendra wrote:
PS: Stephane, you probably have this on the top of your Oracle Myth
list ... right?
YMMV
Raj
Indeed, together with 'always replace NOT IN with NOT EXISTS ...' -
another case today ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official
I got same problem. what I did is before call sqlplus /nolog, I rename
the glogin.sql to something else and change back after the jobs done.
That is most easy step I need to do.
Joan
John Carlson wrote:
The way I do it is to create another login.sql script for batch jobs only and place
that
Precisely.
I am trying to propose the abort option, but I am not the majority around this place I
call work.. :)
On a more than dozen times in the last few months, I had to kill oracle processes to
get the database to shutdown (with immediate), so the scheduled reboot of the machine
will
Chris,
No i havenĀ“t tried TightVNC... I'll go and check it out ...
Also I forgot to mention that there is an excellent client SW that permits a
Linux/unix box to connect to a Windows 2000 Terminal Server. If anyone is
interested, go to http://www.rdesktop.org/..
Pretty impressed with it ... :)
only for some. unfortunately not for most of mine
--- [EMAIL PROTECTED] wrote:
Comparing users to Marilyn Cross.
Naive, not overly bright, sentenced to death.
Is that too harsh for users?
Jared
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 07:18
Hi All,
I have been trying to upgrade our Oracle environment which is presently using Oracle8i
with DataGuard setup, using the GUI based - DataGuard Manager, but so far not been
successful, I am constantly and consistently getting DataGuard Remote Process startup
failed, even though, I have
Title: RE: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
...
So use your test systems, load them up like production, and try both.
I bet in 9 out of 10 cases, checkpoint+abort+startup will be much
faster
I am getting following in alert log
file
internal error code, arguments: [17090], [], [],
[], [], [], [], [] .
its a hp-ux 8.1.6 system .
It happens only when two user does the same thing
.
any idea ?
-ak
Title: RE: dbshut script - shutdown or shutdown immediate
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
I would
have guessed
that optimally, you'd try immediate first then abort if
immediate takes
too long.
I've read that some people on the list have
If you can change it to an IOT, it may be beneficial.
There's no blanket clause to be used that says 'Always do this'.
I higly encourage folks on this list to setup and use the run_stats
method of comparing different access methods. This is something
Tom Kyte put together. It is very simple to
Gary,
Check doc # 136214.1 on MetaLink.
There are some other non-Oracle reg entries that affect shutdown.
Jared
Gary W. Parker [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 09:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
Joseph.
I prefer to exp/imp when possible. You get a chance to change anything
you like. With 8.0.5, you may have to upgrade in two steps. You could test
the exp/imp on your test system and get an idea of how much system downtime
your users would experience. Then ask them if that would be
No human should have to run 8.1.6.
Maybe Note:29616.1.
ORA-600 [17090] Empty error stack when signalling error
Note:
For additional ORA-600 related information please read
[NOTE:146580.1]
PURPOSE:
This article discusses the
internal error ORA-600 [17090], whatit means
I purchased this CD-ROM last week and I must say the quality of the copy is
very poor. The graphics are poor and the sound is so low you can hardly
hear it. I emailed them about the quality but they did not bother to reply.
Just thought I would let you all know.
Ron
-Original Message-
oramagic,
Only let one user do it at a time.
What are the two users doing?
Are they doing it at the same time.
Are they the only ones that are able to do it?
Damn if I don't sound like my father right now
Ron
[EMAIL PROTECTED] 04/03/03 02:29PM
I am getting following in alert log file
Jacques - We have used SHUTDOWN IMMEDIATE for over 5 years now for cold
backups, with zero problems. Weekend before last we had 3 production
databases that didn't go down for backup (all of our databases scheduled for
cold backups). When I checked the following morning they were just hanging.
The
You can look it up at:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=153788.1
Jared
AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 11:29 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
It isn't often you find a tool that compiles and runs flawlessly in a few
minutes.
Just installed on RH80, works perfect. Very cool tool.
Thanks for the pointer.
Jared
Nelson Flores [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 10:53 AM
Please respond to ORACLE-L
Here's how we do it:
We have 2 cron jobs, one of which runs 10 minutes after the first.
The first does a shutdown immediate. The second checks if oracle is running
and, if so, does a shutdown abort.
-Original Message-
Sent: Thursday, April 03, 2003 2:24 PM
To: Multiple recipients of
Here's one way to do it:
OS_USER=jkstill
USERNAME=jkstill
PASSWORD=$(pwc.pl -username $USERNAME -instance $ORACLE_SID)
echo $PASSWORD
unset SQLPATH
# emulating a 10 second shutdown
(
sqlplus -s /nolog EOF
connect $USERNAME/[EMAIL PROTECTED];
exec dbms_lock.sleep(10)
EOF
)
Sorry, the attachments didn't make it, though they were only text.
I can put them some accessible via the web if anyone wants them.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 11:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Madhavan,
I have created a similiar table and inserted the data
as follows :-
=
CREATE TABLE UT
(
U NUMBER(4),
S NUMBER(4),
G NUMBER(4)
);
INSERT INTO UT VALUES(2005,1012,1010);
INSERT INTO UT VALUES(2005,1012,1011);
INSERT
I added a column using alter table add
...
i can see it from sql . can select it from sql .
But if I try to use it in a pl/sql block or procedure .It can't find that column
.
is it a bug ?
8.1.6. hp-ux
-ak
I got the attachments...
--- [EMAIL PROTECTED] wrote:
Sorry, the attachments didn't make it, though they were only text.
I can put them some accessible via the web if anyone wants them.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/03/2003 11:34 AM
Please respond
Actually this is how RMAN works. It writes all blocks up to the HWM of a
given table,
even empty ones. So, if your HWM is artifically high, you will encounter
backups
that are larger than they need to be.
Oracle9i RMAN Backup and Recovery On bookshelves now!
RF
-Original Message-
Joe,Dennis John
U must b knowing OCP takes $$ and these were free of cost, done around 1~1.5
years back. Now these are also chargeable. Anyway I am going to remove those
from my signature!! (Offcourse, I am not adding a new signature as
ListMember for [EMAIL PROTECTED] :)
Best Regards
Ramesh D.
Keith
Like I said, don't rely on my interpretation. Believe Robert -- he wrote
the book! And yes, buy the book. Great book, highly recommended.
http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1049405966/sr=8
-1/ref=sr_8_1/002-7783294-4962413?v=glances=booksn=507846
Dennis
Alas, I'm until recently a prisoner of windows so I can't speak to shell
scripts. On windows I'd probably try a windows script host vbscript like
so:
warning = air code
Option Explicit
Dim WinShell
Dim jobImmediate
Dim
Hi Jaydas,
Thanks for the reply.
It gives me a good starting point to go with. The query handles cases
where there are multiple rows.
For eg: U=2006 has G=1010 and S=1013. If there were another U=2010 with
same G=1010, then a rum through
the query would generate a S=1012 for this combination also
From: Joan Hsieh [EMAIL PROTECTED]
Chris,
We hang on shutdown immediate, not startup. That's why I choose to use
shutdown abort.
Well, in that case of course you'd use it, but personally, if it was me, I'd
want to find out why it was hanging, and fix that instead. I'm not
suggesting shutdown
Did you look at them...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
We got a new brand new dba in our group...he did all of the 8i and 9i
certifications
in 2 months.
He uses large SIG letters beside his name now. He did bust his butt for a
while to
do it...
Kinda puts one to shame doesnt it.
Brian
-Original Message-
Sent: Thursday, April 03, 2003
Hi DBA's
I am in the process of establishing Crash Recovery
scenarios using RMAN and i came across one situation
wherein i am able to recover a tbs having (non system
tbs) rbs in it using svrmgrl but the same damn thing
does not work with rman.
I want to know where i am going wrong with
List,
Has anybody cloned a 8i database and moved it over to 9i? I want to clone a
database that is on 8.1.7 AIX 4.3 32-bit now, move it to a different server
that is running 9iRel2 AIX 5 64-bit. Is this possible and has it been done?
thanks,
David Ehresmann
--
Please see the official
I should have stated that this is Oracle 8.0.5, if that makes a difference.
After posting the questions, I went to Metalink and found some conflicting
informaiton, but the consensus seemed to be that it was unrelated to the HWM
of the tables. For example, after dropping a table, all the blocks
From: Nelson Flores [EMAIL PROTECTED]
VNC and OpenSSH are slow
Anything cross platform isn't going to have the same kind of optimization as
a single platform solution. I find them fast enough to be useable, but
you're right terminal server on windows is faster for windows boxes.
and VNC is
1 - 100 of 124 matches
Mail list logo