Could you give me more information on this. I do not have the Oracle 7.3 doc's
Hi
I hope it doesn't matter. We have been using dynamically created create
controlfile for years now to copy production DB to test/developnment.
I believe the files are alfabetical in our case.
jack
Hi
I did not learn for it , was working with ORACLE for two years, failing the
Oracle self tests, but PASSED the Brainbench test while having spend just
half hour for all Questions during lunch hour.
Draw your own conclusions
Jack
Hi,
Thank you very much. It solved my problem.
Zsolt Csillag
Hungary
At 12:38 2002.04.11. -0800, you wrote:
Hi Zsolt ,
check /etc/oratab, you may need to replace N by Y
hth
Vadim
-Original Message-
Sent: Thursday, April 11, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
You could try setting event 10391,
levels 64, 512, and 2048 are likely to be
the most informative for you problem.
Add the values together to run all three
at once. The level is a bit flag that goes
up to a total of 8191 - but when you set
8191 it looks as if a couple of the flags
may disable
Hi All,
I'm currently in the middle of a tar with Oracle about duplicating without
set until time/scn According to the doc's it must be possible but when
trying I get an error message about an archive log file that it needs but
is not yet there.
Any of you duplicating without set untill
xxx_DEPENDENCIES would probably be a better starting
point.
hth
connor
--- [EMAIL PROTECTED] wrote: Darn E-mail package.
Every once in a while I get a
message as I'm deleting one
or more I don't want one I do want goes as well.
Well, I guess that's
IBM/Lotus for you.
Anyway, someone
Jack,
Of course you can duplicate a db using RMAN without using the
'set until time' feature.
Are u sure all the archived logs which have been backed up by RMAN
are present i.e. none of the logs have been accidentally deleted ??
RMAN will use the archived logs to apply the changes and open the
Hi,
I have read up quite a lot before posting this message so please
bear with me if this question is trivial.
I have table which stores session information of users. I have to develop a
report which gives me the number of times users have logged in ( which is
straightforward ) as well
Gavin,
select username, max(access_time) last_access_time, count(*) no_of_logins
from session_info_table
group by username
should do it
Iain Nicoll
-Original Message-
Sent: Friday, April 12, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have read up quite a
Try the max function to pick the latest timestamp. I assume the column is of
type date
John
-Original Message-
Sent: 12 April 2002 11:43
To: Multiple recipients of list ORACLE-L
Hi,
I have read up quite a lot before posting this message so please
bear with me if this question
Never even heard of it.
If it's a valid test (as in - if it measures what it purports to measure)
then it's interesting, but if employers have never heard of it it's useless
in that regard.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent:
SELECT user_id, COUNT(user_id), MAX(last_connect_time)
FROM user_ses GROUP BY user_id;
JP
On Fri 12. April 2002 12:43, you wrote:
Hi,
I have read up quite a lot before posting this message so please
bear with me if this question is trivial.
I have table which stores session
Thanks alot Iain
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 4:58 PM
Gavin,
select username, max(access_time) last_access_time, count(*) no_of_logins
from session_info_table
group by username
should do it
Iain
I've got a few BB certifications, purely for my own benefit. It doesn't
appear as if many employees (in the UK or Scotland anyway) appear to take
them seriously.
Kev.
-Original Message-
Sent: 12 April 2002 12:58
To: Multiple recipients of list ORACLE-L
Never even heard of it.
If it's
Wow, this is scary thinking.
Look only at expenses, not at the need that needs to be filled.
Here's another example of that:
http://www.vnunet.com/News/1130760
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Jeff,
We have dba privileges granted to schema owners in devl databases, test
database mimics the prod, so they just have appropriate roles. In prod, no
schema level access, everyone goes in with their own id, and no one has
those ANY privileges.
In next couple of months, we are cutting off
Jonathan,
This behavior is partly because ANSI standard states that treatment of NULL
is implementation specific.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
[EMAIL PROTECTED] wrote:
is there any value to OCP?
here we go again.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program like you don't need the money,
You gotta
Jeff,
Developers should only have access to stuff
they need. This does not include SYS stuff. Basically, do you want
to be restoring the development database just because somebody was playing with
something? Further, who will be blamed for the developers not being able
to do their job
Like I said this is test. In prod, they only have select
access.
However, since in test have "any" rights, were able to get a sys
object. [EMAIL PROTECTED] 4/12/02 9:13:19 AM
Jeff,We have dba privileges granted to schema owners in
devl databases, testdatabase mimics the prod, so they just
Gavin,
We have a similar situation. We simply maintain two tables - one to maintain
login-history and another to record the latest-login. The latest-login table
would be updated by a trigger on the history-table.
A procedure checks both tables and returns approppriate info.
-Madhu
From:
Jeff,
I agree with Raj. Further to what I said before, I have four database -
dev, user test, training and production. Training and Prod are always at
the same application release level. Developers have total access in dev;
and query-only access in the rest.
Tom Mercadante
Oracle Certified
As little as they need. I, as a
general rule, only grant to the objects they are actually using. One way
to look at it is you will always know which grants to move over to test and
prod. Now, the group I work with grant select on any table which I have
mixed feelings about. With the amount
Tom,
That's all well good. I believe in keeping people be they developers or
end users out of matters that they cannot do anything about or just plain have
no reason to be mucking about in, like SYS. Now would someone please tell all
of those third party apps folks the same thing. I've
I vote we skip the debate. There is really not much to add to it as pretty
much everyone
voiced their opinion on that one already:-)
-Original Message-
Sent: Friday, April 12, 2002 6:23 AM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
is there any value to OCP?
Hi all,
We are running a kind of hybrid mode, mainly RBO with some tables analyzed
(mainly for intermedia). Last week we had an interesting situation, when
tuning a huge SQL, we created an index and the query worked fine, but later
in the day developers complained that their queries are running
1. The user has connected, but not issued a SQL statement.
2. The user has been connected a while, issued a statement some time ago,
but that statement has been flushed via the buffer under the LRU algorithm.
Any more?
HTH
Mark
===
Mark Leith
I grant them full access to their own
schema. The production schema owner inTEST databases is still controlled
by DBAs. I do grant them selected '... any ...' privileges as needed, in
theTEST databases excluding 'select any table'. No one gets it. Instead I
grant them select_catalog_role to
Tony,
Image may have been a network database, but when HP Turbo'd it they made the
change to the hierarchical model. Sorry to correct you, but it says so right in
the manual. In the What is TurboImage section they do acknowledge the
background in Image, though there is no mention of TOTAL
...guess I should have added the emoticon. I meant it as a response, not a
question...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 8:03 AM
I vote we skip the debate. There is really not much to add to it as
pretty
Hi,
My co-worker is looking for suggestions on how to accomplish the following.
A user has SUID access on a set of tables while in a application.
Outside the application we only want that user to have select privs only
when using sql*plus.
They could have the application changed to reset privs
Hi Raj, my two cents, fwiw:
Interesting. I have worked places where hints were frowned upon (why is
Oracle not doing it's job? Hey, you, DBA, you fix it. No, I don't like
your hint. Fix it)
However I feel the opposite way. I have also worked in very liberal
environments (make it work!
8.1.6 NT TOAD
I have a developer assign a default value to a column, and they don't want
it anymore. I can reset the default to be NULL (the default default so to
speak) but they are able to see the fact that there is a default in TOAD on
that column and of course the other columns don't have a
Create a role that has the suid privs, assign the role to the user who needs
it, BUT DO NOT MAKE IT DEFAULT. Within the application enable this role for
the user as soon as they log in, so they get all access for that session.
Outside of this, as the role is not default, they won't have access.
Got to www.google.com and search for Oracle 7.3 documentation.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 2:03 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rule based
Hi friends and gurus,
Anybody has had (or has heard from friends of) any bad experience with
Oracle 8 running on Solaris 8. I know that the first supported version on
Solaris 8 is 8.0.5. If you know of some I would appreciate f you could
share it, and specify which version and patch release.
Has anyone taken this exam? If so, I would like your
feedback.
Thanks,
Ken Janusz, CPIM
My experience has been that RMAN will try to restore the database right up to the
current point-in-time of the production database. So if you are on a remote system,
it will be looking for data in the current redo logs (or logs that were archived since
the backup), which it can't access.
Hi
We used to use the protocol.ora file to restrict access to the database,
on oracle 8.0.5
However since moving to Oracle 8.1.6.3 this doesn't work.
Am I missing something or is there something wrong.
TIA
--
Sajid Iqbal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
I am not sure, outlines do require CBO (me thinks) and we are not there yet.
Also there is a general resistance around here for that. Now that you have
asked me, I will probably take it up to my manager once we move to CBO
completely (sometime before Universe stops expanding judging by current
I think your theory is correct. I have the same experience, I have to
use SET UNTIL, otherwise RMAN complains about the archivelogs. Oracle
8.1.7 on IBM AIX.
Robin
Jay Hostetter wrote:
My experience has been that RMAN will try to restore the database right up to the
current point-in-time of
Thanks for replying.
I've seen your post on a similar question on metalink.
I've already tested with the constraints enabled
novalidate using the default exchange mode (with
validation). The exchange is taking 3 seconds.
We'll go this way since we're replacing completely the
target tables with
Make sure you build the controlfiles on the clone with noarchivelog. That
will keep you from having the problem of set until time.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 12, 2002 11:59 AM
I think your theory is correct.
No. CPU utilitization averages 40-60% across 4 CPUs.
--- Mohammed Shakir [EMAIL PROTECTED] wrote:
No enough inserts to bog down the CPUs?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
Thanks, Mohammed and Anjo, for your replies.
Now my question is this: given that the table structures
There are lots of versions of this around, but this reports
the sum of the allocated extents. My problem is that the
creater of this db made a huge extent and I don't seem to
have a way to track growth within the extent.
On Thu, Apr 11, 2002 at 07:13:31AM -0800, Ruth Gramolini wrote:
Not really required. This is clearly explained in both Oracle 8i and Orace
9i manuals:
Oracle8i Designing and Tuning for Performance - Chapter 4 The optimizer
Oracle9i Database Performance Guide and Reference - Chapter 8 Using the
Rule-Based Optimizer
John Kanagaraj
Oracle Applications DBA
If you trace the listener you will see that it is looking for
.protocol.ora with a leading period. This is a documented bug. Just
copy protocol.ora to .protocol.ora.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 12 Apr 2002, Sajid Iqbal wrote:
We used to use the protocol.ora
I have Oracle8 running on solaris8 for more than a year and don't see any
problem.
David
-Original Message-
Sent: Friday, April 12, 2002 10:26 AM
To: Multiple recipients of list ORACLE-L
Hi friends and gurus,
Anybody has had (or has heard from friends of) any bad experience with
Ken,
If this is the 9i upgrade exam then there was a
discussion on this recently (about 3-4 weeks ago)
Search the archives for a post by Mike Hateley and
responses from Robert Freeman.
If is not the 9i upgrade which exam is it?
John
-Original
Message-
From: [EMAIL
Instructing people to put hints in all of their code is the same as
usingCBO full-time, because CBO hints automatically enable the CBO.
Using CBOfull-time and not analyzing everything is asking for
trouble...Using RBO is unnecessary if you are using Oracle8 v8.0 or
above. The CBOoutperforms
Check Metalink Note:114959.1. Also check if all of the OEM components
were installed by running the OUI, sounds like something is missing
because on Unix you should have OEM Client, Console, and OMS.
Reddy, Madhusudana wrote:
No I was trying to start the OEM console , which requires OMS,
Ruth,
When I startup nomount my clone, no files exist, except the init.ora. I then
duplicate using:
run {
set until time to_date('040120020214','mmddhh24mi');
allocate auxiliary channel ch1 type disk;
set newname for datafile 1 to '/u03/oradata/BSCSD/system01.dbf';
...yadda yadda...
Suzy,
You are much too generous.
I always have found that asking for a change control form delays things by a
few days!!
John
-Original Message-
Sent: 12 April 2002 18:43
To: Multiple recipients of list ORACLE-L
I generally give developers access only to the schema's they are
I generally give developers access only to the schema's they are
developing for. In some cases, they might also get select_catalog_role.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
I worked at one consultancy/software house where you were not supposed to
use hints under any circumstance. This was because they wanted to make the
code truly portable (I believe SQL Server ignores Oracle hints as if they
were comments anyway, correct me if I am wrong).
I found this very
Thanks Tim,
At-least now I know I shouldn't tell them to start putting hints. This was
my problem to tell them or not to tell them. This still doesn't solve the
problem for me though, as everyone is still reluctant to move to CBO. And
this is exactly where it gets getting complicated.
Raj
David,
Solaris 2.8 (why they call it Version 8 and specify it as 2.8 I don't know)
is in use for production at a lot of sites. I am sure there are bugs and
problems with it the same as any other O/S but generally I think it is a
safe bet to install Oracle on Solaris 2.8 .
Just ensure you check
Hi, all. Sorry to be such a pest, but I'd like to ask another question
about my insert performance problem.
An example of the trace output for the two machines is shown below.
There are many other traces containing the same insert statements, and
the values are very similar:
Machine
Hi,
I'm trying to load a table with 37 columns, from a flat file. I'm getting
ORA-06502 error after about 400 rows have been added to the file. When I
read read from other tables this works fine (although they don't have as
many columns). I've tried using the overloaded UTL_FILE.FOPEN procedure
I always rebuild the controlfiles for the clone and make it noarchivelog. I
am still on 8.0.6.3 so I can't duplicate the database, I have to fool rman
be renaming the clone to the orginal and restore. First I so a backup
controlfile to trace on the clone, then I set name to the orginal and make
Raj,
Keep in mind that the CBO will be defaulted whenever the following is
present:
· Partitioned tables and indexes
· Index-organized tables
· Reverse key indexes
· Function-based indexes
· SAMPLE clauses in a SELECT statement
· Parallel execution and parallel DML (i.e. presence of DEGREE on
Using RBO is unnecessary if you are
using Oracle8 v8.0 or above. The CBO outperforms RBO in any
situation except queries against the data dictionary (because you cannot
analyze the data dictionary).
Never
say never and Never say always.
I have
found the above statement to be true
Guess I should clarify... developers only get access to dev, and for
test prod they get nothing. I've encountered very few with a
need/desire for select_catalog_role, and they have to ask first :)
John Hallas wrote:
Suzy,
You are much too generous.
I always have found that asking for a
Kieran, I have to wonder... why are you using utl_file instead of
sql*loader?
Lisa Koivu
Oracle Database Tank
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Kieran Murray [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 2:13 PM
To: Multiple recipients of
[EMAIL PROTECTED] wrote:
David,
Solaris 2.8 (why they call it Version 8 and specify it as 2.8 I don't know)
is in use for production at a lot of sites. I am sure there are bugs and
problems with it the same as any other O/S but generally I think it is a
safe bet to install Oracle on Solaris
Another (and hopefully final) Rman question for the community...
If you decided NOT to use Rman and you opted for either another
product, can you share with me why you decided not to use Rman.
Was it the complexity, lack of documentation, or a really good
software salesman?
Robert G.
Raj,
I don't remember what version you said you were using but you might want to
investigate
stored outlines. If you have a full-size test environment, you could save
away the current
RBO-based execution plans, switch to CBO and gradually get rid of your
RBO-based stored outlines by tuning
John Kanagaraj wrote:
If I have missed anyone - apologies, and please let me know! Charlie, can I
request you to think about a nice place to meet later?
Apologies accepted. If anybody is interested in how to make their
applications search smartly information managed by a LDAP server
Raj,
I shall comment on no 3.
1. Developers do not put hints in their SQL statements.
2. They implicitly reply on a set of indexes that have worked for them.
3. Due to reasons of 1 and 2, no new indexes can be created because it will
make their queries run slower.
I had gone through the same
I am assumming the table is contained within one extent.
If you did an analyze table, wouldn't that show the amount of data (num_rows
* avg_row_len)
within the table (extent) which could be used to monitor growth.
-Original Message-
Sent: April 12, 2002 10:04 AM
To: Multiple
Tim,
Have you ever found yourself needing to use the DBMS_STATS.SET_XXX_STATS
routines to get your desired plans? And if so, did you do this on a trial
and error basis, or did you use something like a 10053 trace to see inside
the CBO's head to help you determine what values to use?
Just
The
promise/threat to treat empty strings differently from nulls has been in the
documentaion since at least Oracle 7.3.
Ian
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 11,
On Fri, Apr 12, 2002 at 12:13:25PM -0800, Browett, Darren wrote:
I am assumming the table is contained within one extent.
If you did an analyze table, wouldn't that show the amount of data (num_rows
* avg_row_len)
within the table (extent) which could be used to monitor growth.
Yep, but
Thanks Cherie and Rafiq,
I am on 8061, but probably directly jump to 9.2 (whenever that becomes
available that is, so far I have heard many dates).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Hi Fellow DBAs,
I and a fellow DBA are currently debating about how insufficient space in
the archive destination freezes up the DB. He claims that as soon as the
ARCH process is unable to write to the disk, the db freezes. I am of the
opinion that it does not. It will only report an error (Any
My view of the AS/400 will always be
framed by one project I heard about.The Pepsi Bottling Group in the mid
80s, was looking for a solution that would tie all of their branch offices
around the country to the Bottling Group headquarters in Purchase NY. IBM of
course sold them an AS/400
Hi Jonathan,
Yes - my phrasing was incorrect. The list was off the Tuning/Perf Guide, but
I should have phrased it correctly.
John
-Original Message-
From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
Raj, either way you are in deep doo doo until the problem is solved. The
error code is ORA-257 - Archiver error. Connect internal only, until freed.
From metalink:
ORA-00257: archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to
H, 9.2. Did you mean 9.0.2?
As we all know 9i is really 9.0.1 I think we will see 9.1, if for no
reason other than we had an 8.1. But I'm already seeing/hearing about 10i
(aka The Beast Master, Wiz Bang, All Knowing, All Seeing, Ai, Dilly
Dally). But 9.2, never, I take odd's on
As Daffy Duck says - http://www.dailywav.com/0700/dcorrect.wav
The archiver freaks first, and will keep trying to write/recover/looking
for space. But the database will not hang until all the redo logs are full
and none remain that have been archived (ie: all redo logs need archiving).
The
Brian,
We are production on 9012, can't get 9013 compiled on Aix 64 bit though. We
will be getting 9.2 (9i release 2) soon. But then it all depends on how you
define 'soon'.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
After reading the other postings I better add this one too;^) (If ya didn't
learn something new today, it's because ya didn't do anything today).
ORA-00257, archiver error. Connect internal only, until freed.
Brian P. MacLean
Oracle DBA, OCP8i
Its not a Upgrade exam.. in fact its the first exam in Oracle 9i OCP core
series
-Original Message-From: John Hallas
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 12, 2002
12:58 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: 1Z0-007 Exam
Ken,
If
this is
Does OCP really help? I am thinking about gettting OCP,
yet still skeptical about it. I am a web engineer, and have very little dba
"work" experience. I know PL/SQL and have worked with MS SQL 2000, mySQL, etc.
And have been messing around with Oracle 9.02 on my linux box. also been
Here we go again :-)
--- Duk Lee [EMAIL PROTECTED] wrote:
Does OCP really help? I am thinking about gettting OCP, yet still
skeptical
about it. I am a web engineer, and have very little dba work
experience. I
know PL/SQL and have worked with MS SQL 2000, mySQL, etc. And have
been
If you
play around with a database while studying for the OCP it can help in that
way. It will most likely get you past some HR folks but the more folks
that get out there that have an OCP but only got the tests from memorization
will start to give the OCP a bad name (ok for some of you out
Title: RE: OCP Question
Meaning ... been discussed millions of times already? :-| Should I just search the archieve?
-Original Message-
From: Joe Raube [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OCP Question
INDEX
ORACLE-L
I would suggest analyzing everything anyway. If any of the conditions occur
which John K was so kind to document earlier (thanks John!), they'll be on
CBO whether they like it or not, whether they know it or not.
I think you can prove to them that they are using CBO by looking in
V$SQLAREA
cool!
- Original Message -
From:
Toepke,
Kevin M
To: Multiple recipients of list ORACLE-L
Sent: Friday, April 12, 2002 1:28
PM
Subject: RE: SQL statement with hints or
without hints (LONG)
Using RBO is unnecessary if you are
using Oracle8 v8.0 or
the '2.' prefix has been dropped in favor of just the '8'. This change was
started with Solaris 7 but there is still a lot of mixed documentation
around. The '2.' really served no purpose anyway.
the '5.' prefix refers to the SunOS version underlying the specific Solaris
'2.' version.
- Paul
Hi all,
I have 1gb physical memory and over 2gb swap space on my Solaris box
(Solaris 8).
My SGA is about 300mb. When I startup my instance (8.1.7) the amount of
free
memory (physical ram) dropped as expected but the swap usage also
increased by 300mb. I am little puzzled over this as I don't
Anyone using Oracle 8.1.7 Client and/or Oracle
Access Manager for CICS on OS/390 connecting to an 8.0.5 database server (on
Solaris in our case)? I'm planning to upgrade the OS/390 Client from version
7.3.4 and Access Manager from version 1.3 (which works fine against the 8.0.5
server) soon
94 matches
Mail list logo