Hi,
Can some one send me a sample program on arrays ,like how to place values in
arrays( PL/SQL tables ) and how to retrieve values from the array etc.,
Thanks for your help in advance,
Venu
--
This e-mail may contain confidential and/or privileged information. If you are not the
Thanks Jared for the script, have modified (the little that had to be done :-), and
works like a charm.
the next problem that I have, is that I want to make this an automatic affair, so I
want that this shell should first read the parameter, LOG_ARCHIVE_DEST, get the
archive destination from
Hi All,
The Environment is Windows NT Server 4 SP5 with Oracle 8i Ver 8.1.6
Enterprise edition.
When i am trying to install forms6i it takes the current oracle home and
denies to install it as it is already being used.
Moreover i can not even change the oracle home from this list item of
I had read from a paper that . NEVER EXCEED 55% of totaL memORY FOR NT . but
I KNOW THAT YOU CAN NOT EXCEED 2 GB TOO.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, June 25, 2001 10:53 PM
Does anyone have an idea of what percentage of
Title: Multiple Oracle Instances on NT
yOU CAN RUN SEVERAL ÝNSTANCES ON nT . I DO IT
NOW.
NOTHING IS DIFFERENT. BUT DO NOT FORGET TO MAKE ONE
INSTANCE DEFAULT .
- Original Message -
From:
Yttri, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Monday, June 25,
Hi Smith,
As everyone in the list has rightly pointed out that NT is stable and may also lead to
problems. I myself installed a 50gigs DB in aIBM Netfinity server with RAID 1+0
combination in MSCS. Even tough the client lost a datafile and was unable to restore
the whole db. Instead they
Nice colour choice ..
Guy Hammond
guy.hammond@To: Multiple recipients of list
My database will be growing 20 GB per
year.
Anyway . Forget it .
Thank you All.
Bunyamin
- Original Message -
From:
Christopher
Spence
To: Multiple recipients of list ORACLE-L
Sent: Monday, June 25, 2001 6:32 PM
Subject: RE: SGA QUESTION
Who
knows.
Excuse me but you are a little presumptious and rude with that last mail. If
a process is put in place that requires a form to be signed and
authorisation to be given before action can be taken then I would be going
totally against the grain and would get into trouble for not adhering to the
Hello Lisa...
I have been handling Oracle on NT last 6 months - and I much prefer UNIX. Here are
some things I learnt the hard way...
- can you run multiple instances of Oracle on one NT machine
yes u can. Another lister has replied to u about this - how one uses oradim80 to
create
I thought this might be of interest to people as there have been a number of
discussions as to whether multiple DB writers are supported on NT.
Regards,
Bruce
Bug No. 1839458
Filed 19-JUN-2001 Updated 22-JUN-2001
Product Oracle Server - Enterprise Edition V7 Product Version 8.1
Platform
Title: RE: Griping about auditing (not the Oracle Kind)
My
point precisely. I'm not putting my neck on the line because someone won't allow
me to do my job. Let them be the one who takes the hit when the s**t hits the
fan.
Thanks
Chris, good point well made (better than my knee jerk
We are running an Oracle 8i (8.1.6.) server on NT 30-250 concurrent users
day and night since two years. It is a dedicated Compaq Proliant server,
never had any problems. Since two years the databse is running without a
single reboot.
Tamas Szecsy
-Original Message-
Sent: Tuesday, June
Ed
Respective Table is NOT partitioned
ACID is the UNIQUE Key on the Table . There are NO Constraints
whatsoever
Thanks Indeed .
Vivek
-Original Message-
From: Shevtsov, Eduard [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 7:22 PM
To: Multiple recipients of list
Hi all
Lets say I have a table:
f1 char(10)
f2 char(2)
f3 number
where f1 is a name, f2 is a code and f3 is a number.
What I want to produce is a report that looks
something like this:
F1 F2 IS A F2 is B F2 IS C F2 is X
f1f3f3 f3
f1f3
Hello ,
Can I know whether is it possible for me to set up a trigger to activate if
any user active this in-house logoff function to kick off any user who is
activate this script ?
ALTER TRIGGER CFLOG DISABLE
/
UPDATE CFsecurity
SET LOGON = 'N'
WHERE STFID = UPPER('STFID')
/
UPDATE CF88LOG
Hi Vivek,
you have the best plan that you can get via index path.
I'm afraid, there are only 2 way here that I can offer for you.
1. Decrease number of executions. Is such huge number of executions
justified in your case?
2. If you can't change application logic (don't have access to SQL code),
Title: Multiple Oracle Instances on NT
Hi,
If I
am not wrong Oracle instance on NT is a single process composed of all oracle's
threads.
UNIX
ps -ef
MTS is
not supported by NT
Sinardy
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin
Hi all,
Vacation is over !
We'll have some tables with a PK and between 1 and 3
other fields . Those tables will be insert once and
read 2 to 7 times.
I'm wandering about the use of IOT and done some
tests.
When inserting 700 000 rows, the IOT and the standard
table with a PK took the same
These are my network conf files:
listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL= IPC)(KEY = PROD))
(ADDRESS = (PROTOCOL= TCP)(HOST = 10.17.150.5)(PORT = 1521))
(ADDRESS = (PROTOCOL= IPC)(KEY = extproc))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
Ivo,
I guess it should look like this in you init file
mts_listener_address=(address
=(protocol=tcp)(host=10.17.150.5)(port=1521))
mts_service=ORASIDa
mts_dispatchers=(ADDRESS
=(PARTIAL=TRUE)(protocol=tcp)(host=10.17.150.5))(dispatchers=5)
mts_max_dispatchers=10
mts_servers=5
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode
explained
If this is true then I may be a victim of a disease called
'Common Oracle RDBMS
Misconceptions' . Somebody help me!! (Jim carrey-MASK style)
Please help me. If
They don't publish it, but I'm pretty sure that
dbms_utility.get_hash_value calls the same routine -
so you can pre-test values by passing them through
that to see what they hash to
hth
connor
--- elain he [EMAIL PROTECTED] wrote: Hi,
Does anyone know the algorithm used in hash
Kevin and John,
The original limit was 2GB on NT, but since service
pack 3 and above this can be extended to 3GB by
changing a few settings. There is also a special
driver that can be obtained to allow access up to 8GB.
I have never tried this driver since I don't have any
boxes with 4GB, but
On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode explained
If this is true then I may be a victim of a disease called
'Common Oracle RDBMS Misconceptions' . Somebody
Hello List,
I have trying to install both of them (Oracle database software and
Developer software) on the same machine, but it has been completely
impossible for me. Could anybody tell me whether there is or not any way
to do it?
Thanks in advance
begin:vcard
n:Jimenez;Beatriz Martinez
well whats wrong with the article. It is true. It is the way Oracle Handles
the HOT Backup.
Ravinder
Vladimir Begun
Hello ,
Can I know whether is it possible for me to set up a trigger to activate if
any user active this in-house logoff function to kick off any user who is
activate this script ?
ALTER TRIGGER CFLOG DISABLE
/
UPDATE CFsecurity
SET LOGON = 'N'
WHERE STFID = UPPER('STFID')
/
Title: RE: To IOT or not
While evaluating the use of IOT for over db, i came across some points:
--IOTs will use cost based optimization, even in rule environment.
--IOTs are faster than normal tables when queries are based on the primary key.
--Secondary indexes on IOTs may not perform as
Sinardy,
MTS has been available on NT since Oracle 8.0.3.
-- Anita
--- Sinardy Xing [EMAIL PROTECTED] wrote:
Multiple Oracle Instances on NTHi,
If I am not wrong Oracle instance on NT is a single
process composed of all
oracle's threads.
UNIX ps -ef
MTS is not supported by NT
Well i dont know about everyone else, but i knew thats how the hot
backup worked, but then again, i've not attended oracle education
classes either, just some hard core reading and have gotten all of my
backup/recovery concepts from Rama Velpuri's book. An excellent book if
you dont have it.
hi
Error during import: ORA-02270: no matching unique or primary key for this
column-list
i am in the process of migrating my oracle databases from dg/ux to solaris8
OS. at the same time, i am taking the opportunity to resize the tables,
indexes to cater for growth in the near future.
to do
Title: QUERY HELP
Dear Guru's,
How can i refer the previous record detail(s), when oracle fetchs the current row details?.
sql SELECT rownum rnum, empno eno, ename FROM EMP;
RNUM ENO ENAME
--
1 7369 SMITH
2 7499 ALLEN
3 7521 WARD
4 7566 JONES
7 7782 CLARK
Title: RE: Ora-1654 Unable to extend index on tablespace
Mitchell have you tried coalescing your tablespace? How big are your extents?
-Original Message-
From: Mitchell [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 5:28 PM
To: Multiple recipients of list ORACLE-L
Subject:
hello all,
i installed and configured the OEM 2.0.4
successfully. and also do the configuration for Oracle Management server as
required.
but unable to start the oracle agent service. I've
Oracle 8.1.5 on NT 4.0 Server.
the error was: Error 0015: could not find the file
specified.
i came
Bruce,
great reply! great points to ponder!
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L
Ron,
I'm going to say that it might be possible with some provisions.
Title: QUERY HELP
One
way to do this is in the procedure, use variables that hold the previous values
(e.g. last_rnum := rnum). Then, do your comparison of your current value to your
last stored value (e.g. if rnum - last_rnum 1 then flag='*'). I am sure
there are more than one way to skin
On Mon, 25 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-I agree with His Chrisness on this one.
-
-If the avg(NT Admin) avg(Unix Admin), we'd
-all be reading this mail on Window's boxes.
-Er.what I mean to say is..
-
-sly grin
-
-but, in all seriousnesswhen there
Title: RE: QUERY HELP
Have you tried this:
select tab2.col1, tab2.col2, x.col1, x.col2
from
(select column1 col1,
column2 col2
from tab2
where ( your independent conditions here, can't refer to outer query here)
) x,
tab2
where x.col1 = tab2.col1 [etc...]
Is that what you are
Lee,
In my case (please see my previous post on the subject) I had proposed a
change that was rejected. In short I wanted to move a datafile during a
maintenance down day from one drive to another where there would be more room
for expansion. OK, so management rejected the change for dumb
Hi
I always have my init files in the OFA locations so I'm guessing here.
Isn't the startup command listed in the alertlog if you use the pfile
command?
Sounds like a good one to be in there.
Jack
As I am concerned, the only redo information it generates is related
to the system tablespace, the one refering to the manage of the extents.
Ramon Estevez
*809-565-3121 x 225
* [EMAIL PROTECTED]
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En
HUMM, Our last unscheduled Unix down was due to the local power utility whereas
the last unscheduled down on NT was due to the Blue screen of death (Ok, so
the screen is Black on 2000).
Reply Separator
Author: Thater; William [EMAIL PROTECTED]
Date:
Nirmal,
You said I need this in reports. If you mean Oracle Reports, there are a
few ways to do it. If not Oracle Reports, skip down to the SQL part.
1) Create a placeholder column outside query (or use a package variable,
whatever floats your boat).
2) Create a formula column within the group.
FYI,
I was told that this error occurred because not all Oracle NT services were
stopped during the installation.
Only the origin database's service and the TNS Listener service have to be
running.
Add this to your list of things to do, because the Installer does a bad job
of re-installing iAS
Easaw,
It appears that you are trying to import the child table before the parent table
exists. I think the disabeling the constraint before you export should help. Or break
the export into smaller parts and export the tables in different dmp files then import
them in the proper order for the
we've had this discussion here a number of times. And I know that Oracle
teaches how hot backup works, at least in the Server Internals classes
I didn't think it was shocking though :)
From: Joseph S. Testa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Title: QUERY HELP
Do you
want a query to return the missing numbers, or do you want a query to return the
records AFTER some numbers have been skipped ?
The
first can be done in pl/sql (loop with counter compared to rownum), the latter
in sql (use "where not exists ...").
HTH, Remco
Joe company,
Jeremiah has it exactly correct. The only part of the data file that is
un-writable is the datafile header block, which gets frozen until the hot
backup of that tablespace completes. Look at it this way, when the start
backup command gets issued Oracle is in fact freezing
Well, I guess so if that was the only occurrence. I'll never know and I doubt
that they will fess-up.
At any rate, If one wants to use NT or any other OS for that matter in a 24x7
guaranteed manner then one should look into making as much as possible
redundant. Back in my Blue Suit days we
Well, I betcha the reliability of NT2K and unix is
very similar, given high level of SA competence and
following good system engineering procedures.
Anecdotal failure tales ( like Sun on Ebay, or any of the
other Unix failures on NASDAQ, etc. ) are more than
a bit similar to a game of
Yep, that's the way it works. Whoever started the rumor that the datafiles
were unwriteable hadn't looked into the process deeply enough to understand
it. The Oracle Ed. class that I took for backup and recovery explained the
process exactly as it is, using the checkpoint, redo, and rollbacks
Really?
Can please you post the results from such an query against your version of
the database?
Thanks.
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Saurabh Sharma [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001
test
When I worked for a large Oracle Office install for the state I was
the technical ops mgr. (Largest distributed Oracle Office install
in the US.)
One of the rules we had in place is every one was given 3 meg of
storage for email. If you needed more, you had to ask the Oracle
Office
Hi Gurus
Some times one of instance is shutdown.When I checked alert log found
following error message.
Mon Jun 18 09:04:21 2001
Restarting dead background process EMN0
EMN0 started with pid=15
Mon Jun 18 09:04:24 2001
The similar kind of problem I faced when I shutdown the database by shutdown
Different situations . different solutions. Its all subjective. What
will work at one location is like using a feather to stop an elephant at
another. rather useless.
-Original Message-
Sent: Monday, June 25, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Sorry but
We have ORACLE 8.1.6.1 database and I login as DBA and tried to turn on
autotrace. I got
following error messages:
SQL set autot on
ERROR:
ORA-00904: invalid column name
SP2-0611: Error enabling EXPLAIN report
Any ideal?
Thanks
We are running Oracle on a clustered Unisys Aquanta system and have had very
few problems. I can only think of one time this year that I had unplanned
downtime.
The database files are on shared drives and the database software is
installed on two nodes, allowing us to switch to node B in the
i am getting duplicate records if the whole (say XYZ_A_LO_001) value
is repeated without much probs..
but my prob is checking duplication of the last 7 digits..
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They
Same as in normal operation. That's where the before image of any data
changed is stored for undo. My point was that Oracle operates as you
would normally expect it to, except the header block of the files are
frozen at the start backup checkpoint, and you generate more redo as it
is
Hi All,
I thought I had a script to check for space bound objects (can not allocate
next extent for whatever reason) but seem to have misplaced it.
Anybody want to save me the time?
TIA
Jack
=
De informatie verzonden in
Rollbacks? What's their role in the hot backup mechanism?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 26 Jun 2001, Holman, Rodney wrote:
Yep, that's the way it works. Whoever started the rumor that the datafiles
were unwriteable hadn't looked into the process deeply enough
Well, my UNIX box would probably run forever except that the DDS3 tape
changer can't seem to last a whole year without breaking. Need to shut the
machine down to replace the tape changer. I'm hoping to get lucky this year.
Only 120 days till victory!
# uptime
12:09 pm up 245 days, 1:01, 4
Hi,
We are running Oracle 8.1.6 and are planning to
install
OEM. Are there any issues regarding OEM affecting
oracle negetively (performance or otherwise) that
the people are aware of?
thanks
g
=
__
Do You Yahoo!?
Get personalized email
Full authority and no responcibility - looks like very much an HMO. I don't
think I would survive in this environment for so long. Maybe if I did not
have where to go and had small children to feed. This is exactly what I
posted. This is no win game and possible only if payd by the hour and payd
yeah,
that is an awesome write up he did.
"Walking on water and developing software from
a specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 26, 2001 5:06
I believe you're hosed if you installed Oracle 8i into the 'DEFAULT_HOME'.
When I do this setup, I install Forms first into the 'DEFAULT_HOME' which is
X:\ORANT. Then I do the installation of Oracle into a new home, usually
Ora816, this works just fine. Basically, I believe you need to install
Not ins are nasty, try something more like:
create table tmp (
dup_valule varchar(100),
keep_row rowid);
create index t1 on tmp(dup_value);
insert into tmp
select my_column_name, max(rowid) from my_table
group by my_column_name
having count(*) 1);
select my_table.*
from my_table, tmp
where
Yes, I agree, I was unable to see a path using this view:)?
KK
-Original Message-
Kirti
Sent: Tuesday, June 26, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Really?
Can please you post the results from such an query against your version of
the database?
Thanks.
- Kirti
For every SID there will be 2 services in NT - one called
OracleServiceURSID and another OracleStartURSID. If u keep the latter as
start automatically - ur db will come up auto when NT boots up.
Just thought I would mention, that is only for 8.0, 8i has one service:)
Kev
--
Please see the
Ross Mohan for president!
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 26, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
I am hearing such
Hi Gurus
Some times one of instance is shutdown.When I checked alert log found
following error message.
Mon Jun 18 09:04:21 2001
Restarting dead background process EMN0
EMN0 started with pid=15
Mon Jun 18 09:04:24 2001
The similar kind of problem I faced when I shutdown the database by
I think he was shocked by the fact he had a completely different opinion,
and many as well as oracle preach similar opinions.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
What versions, what OS?:)
-Original Message-
Martinez Jimenez
Sent: Tuesday, June 26, 2001 7:01 AM
To: Multiple recipients of list ORACLE-L
Hello List,
I have trying to install both of them (Oracle database software and
Developer software) on the same machine, but it has been
Thank you - I just spewed coffee all over my monitor! ROFLMAO!!!
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 26,
Bhahahaah
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
I've never found hot backups shocking
Jeremiah,
Marlene and I did an exploding the myths paper very similar to what you
are doing..
always set pctincrease on your temporary tablespace to 1
and my OOW submission is very very similar to yours. Not quite, but really
close.
It will be interesting to see if they choose one, both or
Well don't set too many events, remember these are queries.
The more navel-gazing your database does the slower it will be.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Jack,
Here's one that we use..
--
CREATE OR REPLACE VIEW SPACE_BOUND_OBJECTS
( TS#,
NAME,
BLOCKSIZE,
MAXFREEBLOCKS,
TOTFREEBLOCKS,
FREEEXTENTS ) AS
select a.ts#,a.name,a.blocksize,
nvl(max(b.blocks),0),
nvl(sum(b.blocks),0),
Well perhaps you can start writing articles for people.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, June 26, 2001 8:01 AM
To: Multiple recipients of list
My ideal is a vast ranch - as far away from technology as I can get. In
the meantime:
The error enabling EXPLAIN report is your best clue. You've enabled
autotrace with it's default options, which include executing an EXPLAIN
PLAN. You probably have not created the PLAN table. Try running
oh yea baby.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Tuesday, June 26, 2001 10:47 AM
To: Multiple recipients of list ORACLE-L
I've never found hot backups shocking myself. Is it possible that rather than
visiting Jeremiah's site
That is correct. The move command can not move a table with a LONG
column. You can try exporting, dropping, recreating in new tablespace and
importing.
Terry
Walter K wrote:
Hi,
I'm on 8.1.6 and need to move some tables to a
different tablespace. The problem is that some of them
contain
Hi
In a web application taht I write in java I need to pass a number of parameters
to a PL/SQL stored procedure. Since the number of parameters can be different a
Vector, ArrayList, or HashTable on the java side would be a good choice. Can you
pass a Vector to a PL/SQL stored procedure?
If I
cheers, Genehope it behaves itself for you!
-Original Message-
Sent: Monday, June 25, 2001 6:03 PM
To: Multiple recipients of list ORACLE-L
Ross,
To this question I have a very straight answer.
I don't know. I asked a few people and couldn't
get an answer. Our SAs are not on
Mark!
This is cool...you got the bleeding edge so
far out it's amazing
MaximumPC has had some great articles on the Ge3
technology...programmable textures, in hardware...
amazing
having said that, the number one ( and two, and
three and four ) problems with NT is that, in
supporting
Title: RE: Ora-1654 Unable to extend index on tablespace
Hi DBAs
Whenever I have the ora-1654, I
will
1. alter index/table name deallocate unused
2. alter tablespace name coalescs;
3.runquerys to check dba_free_space and
dba_data_files
There are total 140 indexes on this tablespace with
On Tue, 26 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-well, then there must be a whole lot of unix boxes out there because we've
-got 40 of them right here. i'd say all of my 32 databases have been up that
-much too, but i've only had 25 of them up a whole year.;-) yup, i
Rama,
I've also worked with some top-notch consultants and contractors.
Unfortunately, I don't always have input into the hiring and purchasing
process. Sometimes you get blind-sided. My job is to make whatever comes
in the door work. It's tough when you're faced with this kind of lunacy
DELETE is not a finction that NOLOGGING has any effect on. You can't reduce the
amount of redo generated in a delete by making the object NOLOGGING. It is a
common misconception :-) that NOLOGGING pertains to all types of DML and DDL.
Please consult the following section of the Concepts Manual:
lolI just quote the Groucho Marx line: I wouldn't want
to be in any club that would have people like me as a member.
;-
-Original Message-
Sent: Tuesday, June 26, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Ross Mohan for president!
Walking on water and developing
Sad to say but I suspect that Oracle Education is responsible for the
popular misconception about frozen writes on data files during a hot backup.
It's interesting to me that it doesn't occur to most people that you would
blow out a rollback segment if you had to hold all of those changes to
Based on Gaja's book, tune based on waits not based on hit ratios.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Tuesday, June 26, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L
All right folks, I'm collecting misconceptions, of
Hi Gurus
I want to check every 5 minutes interval whether instances are up or not.If
its not up then I will get page.Let me know any one have such scripts.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at
I am hearing such amazing storiesrunning for seven years
no failures in 4 years.never any failures except when
the NT administrator brought down the power grid, etc.
I am not an old hand, nor am I a greenhorn, but in my experience,
real, live production systems ( e.g. more than 100
The subject line may be overstating things a bit, but
I'm pretty frustrated at the moment.
Backups are working fine when I run them manually
(i.e., from a command line or within the RMAN
utility). The problem is trying to schedule the
Oracle backups through the NetWorker Administration
Yea, hit ratios are never important.
Ever.
For anything.
-Original Message-
Sent: Tuesday, June 26, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L
Based on Gaja's book, tune based on waits not based on hit ratios.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
The question of restricting users to the 'approved' applications only comes up
every couple of months...
Yes, you can use PRODUCT_USER_PROFILE but remember:
It only works Oracle SQL*Plus connections -
If you can control what your users can run on their PCs, why do you let them
have SQL*Plus?
How about:
create table tmp_table as select substr(rowid,length(rowid)-7,7) last_seven
from your_table;
and then:
select last_seven duplicates from
(
select last_seven,count(*)
from tmp_table
group by last_seven
having count(*) 1
);
I didn't test it, but it should be pretty fast with only
1 - 100 of 182 matches
Mail list logo
