SET ORACLE-L DIGEST
-Original Message-
Sent: Tuesday, August 07, 2001 1:46 AM
To: Multiple recipients of list ORACLE-L
Hi List -
After installing Apps 11.5.2 I am attempting to login for the first time. I
can login as sysadmin through 'personal homepage' without a problem. But
when I
Title: Help needed
HI DBA Guru's
It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I
THANK YOU SO MUCH .
BUNYAMIN
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 7:21 PM
Is this what you are looking for:
select activity_date from (select activity_date from
sbc order by activity_date desc)
where
Spot on, Rachel! I misguidedly joined Mensa several years ago, and let my
membership lapse after a year or two, when it became clear the level of
debate was as you describe. The overbearing aura of smugness in most of the
magazine articles, and most members' inability to LISTEN at meetings just
Hi there,
It could just be that you are missing your semicolons ';' off the end of
your statements.
Cheers,
Kev.
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Tel: 0141 568 2314
Fax: 0141 568 2366
http://www.calanais.com
-Original Message-
yep, I learned that lesson years ago when I joined. I expected interesting,
stimulating conversation. I got kids quarrelling.
I've always figured if you have brains and/or talent, you usually don't need
to brag about it. If you have to brag, you have a self-esteem problem.
From: Paul Vincent
Hi all,
I have question below here .. (Solaris 7 Oracle 8.1.6)
I startup my database with this parameter
db_name = MyDB
instance_name = MyDB
service_names = MyDB
control_files = (/export/home/basic/MyDB/ctl/control01.ctl,
/export/home/basic/MyDB/ctl/control02.ctl,
Dear gurus !
I have killed a session while it was populating a big table.
Now the session is marked KILLED in v$session.
It's serial# is keeping being incremented , so i assume that a rollback
(of rows inserted into that big table by that session) is going on there
in the background.
This
Dear all !
I have killed a session while it was populating a big table.
Now the session is marked KILLED in v$session.
It's serial# is keeping being incremented , so i assume that a rollback (of
rows inserted into that big table by that session) is going on there in the
background.
This rollback
Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone
heard of them or evaluated them?.
Sean :)
Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
Organon (Ireland)
Well, thanks for the vote of confidence there Christopher! :)
I will start off by saying - I am *not* a DBA, though I am fully aware of
all that the job entails what with selling performance, tuning and
management tools to you guys on a daily basis. I am *trained* to do the
job - and have done a
RTFM on auditing - this should provide all that you need. A good start would
be to read:
Oracle Concepts Guide - Chapter 28 - Auditing.
HTH
Mark
-Original Message-
Sent: Tuesday, August 07, 2001 09:00
To: Multiple recipients of list ORACLE-L
HI DBA Guru's
It has been a painful
Title: RE: Help needed
If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise.
rgds
amar
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Seema,
I don't think you can actually tell what storage parameters have actually
been changed from any of the DBA tables, I think this is a case for auditing
on an ALTER statement for the tables you are interested in.
You can however tell when the last DDL was performed against a certain table
I reckon the best scene was when Orac plays a chess game against a pro, and
the stake is the ship and Blake's life. The game is a variant with a truly
awesome yet simple rule change - you can move whenever you like, rather than
waiting for the other guy all the time.
Orac in his a-retentive
look up auditing it is your friend ;)
joe
Deewaker G.V. wrote:
HI DBA Guru's
It has been a painful process for me everytime when I change the
password of the user in ORACLE.. The reason is simple Some one is
trying to play with the tables and change the INDEXS... delete the
I read the Silmarillion - It's a hard go the first time, but it grows on
you. I especially liked the stories in Beleriand, the creation of the
rings, the capture of the twin silmarils on their pillars of light and the
fall of that island - can't remember its name now. Most of its kings had
Kirti, thanks for the clarification.
joe
Deshpande, Kirti wrote:
Joe/Mike:
If the synonyms are PUBLIC they will appear in ALL_OBJECTS and ALL_SYNONYMS.
If these are PRIVATE synonyms, they will not appear in ALL_OBJECTS, even if
the user has access to the table.
With access to the
I've tested it. It's good but expensive. You can have
an accounting and transform it into with graphics
showing you the waits in order of importance. When I
say accounting I mean that save all sqls through a
period of time. F.e. you want to know what happens in
the night window and then schedule
maybe this is public rollback segment.
- Original Message -
From: Sinardy [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 5:36 PM
Subject: Unknown RBS
Hi all,
I have question below here .. (Solaris 7 Oracle
You should wait for PMON ending its job of rollback
the transaction of that killed session. Since one of
the releases of 8i that duty is a new one for the
SMON.
You have few options. If you are in a hurry, you could
do shutdown abort. First issue an alter system
checkpoint; just in case a maybe
Deewaker,
you can run the listed srcipt to find the users that are connected to your server.
With a little modification you can get all of the information you need.
ROR mª¿ªm
+ user1.sql++
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT
COLUMN OSU
Do you create the table with any strange symbol or in
lowercase or mixing lower and upper or within
spaces..?, As f.e.:
create table weird ( Weird Field NUMBER );
Regards.
--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED]
wrote:
Howdy,
I had an interesting situation today. The
Sinardy,
They are the RBS's that are created when you created the database. You only need the
specify the RBS in the init.ora when they are public RBS that need to be identified if
you use MTS. If your connections are DEDICATED then you do not have to place them in
the init.ora but it will not
I thought that was the question, how to get service on an ITAR. Oh well, it
was Monday after all.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 5:12 PM
Ruth Gramolini wrote:
1-800-223-1711
I have what used to
Oracle version 7.3.2
Access Sql that works
SELECT FIRST([columnName]) as ftmp from [tablename] where etc
Oracle doesn't work... looks like FIRST function doesn't exist..
How can I replace this functionality with Oracle SQL? Any help greatly appreciated!
Steve Johnston
--
Please see the
Look up the dba_rollback_segs. Maybe there are public.
In other words maybe it was created with create public
rollback segment stmt. Therefore issue an:
select owner,segment_name from sys.dba_rollback_segs;
--- Sinardy [EMAIL PROTECTED] wrote:
Hi all,
I have question below here .. (Solaris
I stand by what I had said earlier, I think you've done a great job Mark.
There is nothing wrong with being good at many things and not yet an expert
at something, especially at the age of 22. I think I am more of a jack of
all trades and not yet an expert on anything. When I started here about
I know, sorry I've gotten an Alzheimer moment here, but there is someone on the
list working with my old employer, the USAF, on Oracle HR I do believe. I'd
like to ask that individual if he/she 'd like to comment on the following:
Defense Department to use PeopleSoft for payroll, HR
The U.S.
You trying to seduce me, Mrs Robinson? ;0)
-Original Message-
Sent: Friday, August 03, 2001 8:01 PM
To: Multiple recipients of list ORACLE-L
baby! :)
From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
I would check quickly for these files,
http://vil.nai.com/vil/virusSummary.asp?virus_k=99177
Presence of the files:
c:\inetpub\scripts\root.exe
c:\progra~1\common~1\system\MSADC\root.exe
d:\inetpub\scripts\root.exe
d:\progra~1\common~1\system\MSADC\root.exe.
Also make sure your virus
Cool. Thanks for the info, Yosi. I'll take a look.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Monday, August 06, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L
Walt (the resident Bozemanian), and All,
I don't know if you heard or saw, the cover story in Inc
Henrik,
No, in 8.1.7 I don't see an easy way of doing this.
You could accomplish this in 9i with multi-level
updatable snapshots/materialized views as I mentioned,
but the conflict resolution gets rather tricky and
results in a lot more network traffic as the changes
have to be sent back up and
If you did a shutdown abort, wouldn't you still have to wait for the
rollback to happen during instance recovery on the startup? I've never
tried this - I usually just suffer through the rollback.
Jim
__
Jim Hawkins
Oracle Database Administrator
I am getting this error when trying to call a packaged procedure, with an
in/out ref cursor, across instances and servers.
Both instances are 8.0.4. (database and PL/SQL)
The documentation (below) implies that this should be possible with my
version of PL/SQL. Is this just a lie, or am I
well glad i'm not in(military) anymore, as i know what
peopleslop is like and am glad my records/payroll wont be in there.
joe
[EMAIL PROTECTED] 08/07/01 10:20AM I
know, sorry I've gotten an Alzheimer moment here, but there is someone on
thelist working with my old employer, the USAF,
Yes, but it is painless in comparison with the one
done through shutdown immediate.
--- HAWKINS, JAMES W [IT/1000]
[EMAIL PROTECTED] wrote:
If you did a shutdown abort, wouldn't you still
have to wait for the
rollback to happen during instance recovery on the
startup? I've never
tried
Oddly, Orac reminded me a lot of Rachel's Mensa friends...
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
-Original Message-
Sent: Tuesday, August 07, 2001 6:16 AM
To: Multiple recipients of list ORACLE-L
I reckon
Pay Oracle now or pay Oracle later
If you did a shutdown abort, wouldn't you still have to wait for the
rollback to happen during instance recovery on the startup?
I've never
tried this - I usually just suffer through the rollback.
--
Please see the official ORACLE-L FAQ:
It always amazes me how 20 seconds after I post a question to a newsgroup for all to
see that I find a solution that answers!
Thanks anyway for the bandwidth...
-- Original Message --
Reply-To: [EMAIL PROTECTED]
Date: Tue, 07 Aug 2001 05:55:23 -0800
nah, your wife would get upset.
now, if you tempted me with more Friday recipes, that would be a different
story :)
From: Guy Hammond [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness
David,
What is your setting for LARGE_POOL and have you tried
decreasing it?
Also, this is frequently caused by 3rd party software,
such as AutoSecure, that does additional
authorization.
Also check to ensure that user oracle (or whatever
user you're using to start the db) has not been
Right, as we like to say 'you can pay smon now or you can pay him later' but
he will get his due.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 10:50 AM
If you did a shutdown abort, wouldn't you still have to wait
Jim,
No, since 7.3 SMON does the rollback in the background
upon startup. If a user session attempts to access a
row that is part of an uncommitted transaction that
needs rolling back then that user session will take
over the rollback of that transaction.
HTH,
-- Anita
--- HAWKINS, JAMES W
Hi Folks,
Good Morning. I am very new to this forum, So Please bear with me for any
mistakes. I am also relatively new to the oracle 8 front(I am coming back
to oracle after a gap of 4 years). So the question may be stupid.
We are trying to set up an environment using Oracle 8.1.7, Emc
M...beer
I think your sort of bringing up that whole nature nurture issue, good lord
that's a tough one. I would tend to agree that a person could have a high
IQ, or a high ability to learn, but if they are not in an environment that
promotes learning then they may not fullfill their
Ethan,
This is not an Oracle bug, but an AIX bug. The Oracle
patch for this bug was merely a workaround until IBM
released an APAR with the fix.
You need the fix for IBM's lio_listio() problem (APAR
IY15138). The fix is part of collective fix PTF
U473812 (there may be a newer APAR out there
Hope this is not a duplicate, but I did get an error from Fatcity. Something
about a locking issue??
Sean,
Heard of, evaluated, pretty darn nice, did not support our environment at
the time (HP-UX), and was too expensive for the tastes around here then.
Dick Goulet
Title: Privileges
I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as
So does anyone know how to get rid of the virus if you got it?
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services--
Morning listers!
I am having performance problems with this database, transactions ar running
very slow and I am not sure if I have choose the right optimizer mode...
AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory,
500 MB SGA, 70 concurrent users, mostly OLTP transactions.
I have
this is documented, standard behavior
you cannot use privileges granted via a role to write a stored procedure.
Grant all on the table to user1 directly from owner1 and the procedure will
run.
Or, probably better, would be to develop the procedure as owner1 and grant
execute on it to
I did a B.A. Psych, and you are correct, IQ ratings are culturally biased.
The one administered by the military to screen WW-2 applicants was blatantly
biased.
Over the years they (meaning the people who want to sell IQ exams to school
boards and government agencies) tried to address this, but
You cannot use privileges granted through a role to create packages and procedures.
They have to be directly granted to the user creating the packages and procedures.
-Original Message-
Sent: Tuesday, August 07, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
I have granted
Ethan,
I have 8.1.7 on AIX 4.3.3. Don't have 8.1.6.x anymore.
I have used exp/imp extensively with the 8.1.7.0 database with no problems.
However, we do have the APAR applied that Anita mentioned.
You can check if the APAR is applied or not using the following command:
/usr/sbin/instfix -i
gee, I thought it was pay Oracle now AND pay Oracle later :)
From: Page, Bruce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: how to stop a killed session bothering me ?
Date: Tue, 07 Aug 2001 07:16:08 -0800
Pay Oracle now
Dick, that's me. I'm working on the Defense Civilian Personell System -
distinct from the military personell system.
This is the first I've heard of them choosing Peopleslop, although its
no worse than Oracle GHR. My guess, knowing how the guvm'nt works, is
that this is a case of different
Hi there,
Unfortunately you can't just throw things like FIRST_ROWS at a select
statement to make it run faster. The person who wrote the statement should
have taken into account such things as:
a) Size of tables, ordering, which is the driving table
b) Indexes, are the being used, running
Laura,
You need to do the grants directly to the user that is creating the
procedure/package. Major pain. I didn't believe the developers when
they told me that, but after adequate testing I realized they were right.
Roles are still good for managing security of the rest of the db users,
Read
http://aris.securityfocus.com/alerts/codered2/010805-Analysis-CodeRedII.pdf
http://aris.securityfocus.com/alerts/codered2/010805-Analysis-CodeRedII.pdf
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services
That's the ignosecond right after you press send. RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 11:22 AM
It always amazes me how 20 seconds after I post a question to a newsgroup
for all to see that I find a solution
Hi,
I got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet.
I get the following error:
EXP-8: ORACLE error 904 encounteredORA-00904: invalid column nameEXP-0: Export terminated unsuccessfully.
No idea why this happened?I
The worm is just memory resident, so a reboot should get rid of it, BUT
without the patch, you'll get it right back.
The problem for the new version is it deposits a trojan backdoor on your
server.
Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus
scanners are releasing
I agree with you Kevin, but we have to live with developers,
and here (I am sure it happens everywhere) they blame almost all performance
problems to the DBA and most of us, DBA's, know that their sql code is
the first thing they should look at...
I know that the code of the application that
My guess is that everyone's got too much time on their hands these days...
The market'll pick up, and the list will soften up.
I hope, on both counts.
Yosi
Kevin Kostyszyn wrote:
Wow!!! You're correct sir!!:)
KK
-Original Message-
Thomas F
Sent: Monday, August 06, 2001 2:42 PM
Yeah, that's what I read. I had applied the patch and I don't have Code red
or Code Red II, however it appears that I have something else. It doesn't
seem to have worked but it looks like someone tried to deface our website.
It's just a message that says f--k the us government and f--k
When using first rows, you force the cost based optimizer, in which the
order of the tables does not matter.
Order of the tables only matters when using the ORDERED hint or using rbo
AND there is a tie ranking.
Do not criticize someone until you walked a mile in their shoes, that way
when you
If you are using 8.x + I would recommend looking at Statspack over
utilbstat.
It comes installed with 816+ and available for download on 8.x+.
It is fairly easy to configure and a great utility.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them,
What type of transactions are running, update, insert, delete, or select?
-Original Message-
Sent: Tuesday, August 07, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Take a look at index_caching parameters, they can make a big difference when
using cost mode, Oracle's settings
thanks Christopher, I'll take a look and let you know,
Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-Mensaje original-
De: Christopher Spence [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 10:56 a.m.
Para: Multiple recipients
If the transaction having problem is a SELECT statement and does SORT, then
I think the sort_area_size is too small.
Can you show us the SQL?
-Original Message-
Sent: Tuesday, August 07, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L
Hi there,
Unfortunately you can't
Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months .
Any ideas why ?
Thanks in advance.
SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2 (SUM(DECODE(a.name,'consistent gets',value,0)) +
3 SUM(DECODE(a.name,'db block
Dear gurus !
Finally , they caught me ;-(
I need to implement multimaster replication (asynchronous) among 2
databases.
A couple of general questions before i start :
- Is it a must for the 2 DBs to be of the same version (release) ?
- Is it a must for the 2 DBs to run on the same O/S,
Hi All,
Wondering if anyone has seen anything like this. I have
filed a TAR.
When adding next month's partition to a table a synonym was
used accidently. However, the partition was created and shows
up in dba_tab_partitions. However, I cannot modify of drop the
Friends :
I am installing the database Oracle 9i.
And it have suggested a parameter value 100mb for redo log file.
I am confused with this value, i think it is too big.
The blocksize is 8192
Connections simultaneous is 100
Where am I doing any mistake ?
Eriovaldo
[EMAIL PROTECTED]
Most of the transactions are select, and updates..
Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-Mensaje original-
De: Wong, Bing [mailto:[EMAIL PROTECTED]]
Enviado el: Martes, 07 de Agosto de 2001 11:43 a.m.
Para: Multiple recipients of list
There are two things you can do:
1) turn Oracle auditing on for ddl statements to see who's doing them.
2) if you know the username where things are being messed up, you could
revoke the create session privilege find out who screams.
I'd also look at that table and see who has index
Try this more accurate query:
select to_char(100 * misses / (hits + misses), '9990.00') || '%' miss_rate
from ( select total_waits misses
from sys.v_$system_event
where event = 'db file sequential read' ),
( select sum(dbbget + conget - pread) hits
Andrey,
I am not into cache hit ratios, but got curious about your negative value.
So I casually searched Metalink for 'negative value for hit ratio'. And got
a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread.
You may want to check it out, there seems to be a new
SET ORACLE-L MAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ingrid Diefenbach
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Hi all,
I have a data file of 2G and the free bytes is
1,413,079, the used bytes is only 683,829. I like to
resize it. When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
1.- Go to this link of Steve Adam's site:
http://www.ixora.com.au/scripts/cache.htm
You gonna find a script to estimate the miss rate of
the buffer cache based on the assumptions that certain
operations are not well compute by statistics as
direct path operations.
2.- From 8.X you should rely
100mb for redo log file is not that big? Not big if your environment is
heavy in OLTP.
-Original Message-
Sent: Tuesday, August 07, 2001 10:58 AM
To: Multiple recipients of list ORACLE-L
Friends :
I am installing the database Oracle 9i.
And it have suggested a parameter value
What about TWO_TASK env. variable? Is it set?
Alex Hillman
-Original Message-
Sent: Tuesday, August 07, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
David,
What is your setting for LARGE_POOL and have you tried
decreasing it?
Also, this is frequently caused by 3rd party
Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.
Regards.
--- Jyoti
Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.
Regards.
--- Jyoti
its like the high water mark in a table but its at the
datafile side instead.
if any block in the datafile has ever had data in it, you
can't shrink it below that point.
hth, joe
[EMAIL PROTECTED] 08/07/01 02:40PM
Hi all,I have a data file of 2G and the free bytes is
1,413,079, the used
For us, on 8.1.7.1 with 90MB redologs and about 120-150 connections (100-150
avg TPM), we get log switches every two hours during the day and about every
10-15 minutes during the nightly processing. I guess ideal is to switch
every 30 minutes or so, but we needed to compromise because of the
Update your virus checking software. Patch your software and your OS as far
as you can. Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm
http://grc.com/pw/patchwork.htm ), it catches things the Microsoft
Windows Update seems to overlook.
You may want to get a trojan detector
Probably you need to run the catexp.sql again. This is
100% if you applied a patch. Even if you don't try
running the catexp.sql again. Also the error during
export depends on where you have had it. I mean
whether it has been in one of your tables or in
sys/system objects.
Regards.
--- Jyoti N
MaybeHowever in my experience a shutdown abort and
startup was most of the times quickier than shutdown
immediate and wait for the unfinished rollback.
Remember that one thing is recover because of the
abort and another thing is to rollback managed by the
parameter cleanup_rollback_entries
[via digest]
RE: completely off-topic question...
On Saturday 04 August 2001 16:25, Rachel Carmichael wrote:
putting on armor in preparation for being stoned as a heretic here
I am NOT a fan of Tolkein.
http://www.tintin.com
( http://www.tintin.be/fr/index.html )
Gloriously
Patrice,
I have a friend downstairs who said I should use Fprot to get rid of this
rogue web page, I am going to download it now. I am interested in this
TDS-3 program, can I get that at downloads.com or is it somewhere else?
KK
-Original Message-
Patrice J
Sent: Tuesday, August
NEVER change an optimizer since the application have
some time working with it. I should leave it in CHOOSE
and then analyze what are doing the transactions.
Look up the worst events through v$system_Event or
from time to time through v$session_wait. Issue an
utlbstat/utlestat or statspack. Then
Ran this query under 8i(HP-UX 11)
SQL show user
USER is SYS
SQL select to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
2from ( select total_waits misses
3from sys.v_$system_event
4 where event = 'db file sequential read' ),
5
[via oracle-l digest]
--
From: Farnsworth, Dave [EMAIL PROTECTED]
Date: Mon, 6 Aug 2001 13:01:42 -0500
Subject: RE: computer history stories - Now: Age discrimination?
Most people have a nerd stigma when thry think about physicists,
but as a group,
Kirti, Audrey,
I was under the impression that negative numbers are caused by the numbers
wrapping around i.e., the database has been up for a while and the
statistics pile up and eventually exceed the defined format (e.g. value of
1000+ for a format of 9(3) - to use old COBOL representation !).
Janet,
Possibly there were other tables in the tablespace using space in the datafile and
then some tables were deleted leaving the tablespace fragmented. To completely clean
the tablespace and free the space you have to export the contents of the tablespace(
all tables), drop the tables,
http://tds.diamondcs.com.au/html/intro.htm
http://tds.diamondcs.com.au/html/intro.htm
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 4:36 PM
Hi all,
Was wondering if anyone knows of any software (bedsides pcanywhere or
Citrix) that could be used to give a demo to a company across the ocean. I
know I have seen it before, we went to a url to see a demo, I want to say it
was ms netmeeting but I don't think that is right. any
1 - 100 of 158 matches
Mail list logo