Deshpande, Kirti wrote:
Hi Joe,
Here is a blurb from the 8.1.6 Concepts Guide (Chapter 11, under 'Prefixed
and Nonprefixed Global Partitioned Indexes'):
'Nonpartitioned indexes are treated as global prefixed nonpartitioned
indexes'
I ran into the same stupid question not too
So, does anyone remember WHY it's called Oracle 8i?
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
Sent: Wednesday, June 06, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
M I am just curious about to know for what that i stands for in Oracle
M 8i.
i = Internet. I
Yosi,
Thanks for your input !
No, there is no reference to a sequence. The offending statement is
SELECT
SUBSTR(INTERFACE_LINE_ATTRIBUTE6,1,LENGTH(INTERFACE_LINE_ATTRIBUTE6)-4),
SUBSTR(INTERFACE_LINE_ATTRIBUTE7,1,LENGTH(INTERFACE_LINE_ATTRIBUTE7)-4),
LTRIM( TO_CHAR(
Patrol is pretty good, but they still have the problem of eatting up a
decent portion of the resources. There are products out there that have
better efficiency. But BMC is a good name when it comes to montitoring.
Walking on water and developing software from a specification are easy if
both
Jim,
RUN ON SENTENCE (it's easier this way)
Why don't you consider joining me in the near immposible task of organizing
fellow O-DBA's to stop flaming people on mailing lists for ten minutes and
get them to adopt one measly portion of a small section of the OCP DBA exam
to produce high quality
Chris,
Thanks for your input !
One difference between our prod and QA instances is that the QA instance is
relatively idle - while average load on the prod instance is about 175
users, with less than 5% hitting the database hard at any given point in
time. I am unable to figue out why there is
Title: PARTY LINE: SUMMARY: Thanks everyone - tru64
OK Ross, here goes: NT all the way!
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: SUMMARY: Thanks everyone - tru64
Yea,
Lisa,
Please! Have a glass of a decent (or at least cheap) Merlot and come back
to the dark side - UNIX BIGOTS UNITE!!!
Scott Shafer
San Antonio, TX
210-581-6217
And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you
I use both Toad and EZSQL. Mostly Toad.
Lately I have been drilling down into the many neat things
EZSQL does and discovering hidden gems.
We paid $500 for Toad and $50 for EZSQL. EZSQL is a true bargain.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Lewis
Title: RE: PARTY LINE: SUMMARY: Thanks everyone - tru64
Best bumper sticker:
DYSLEXICS UNTIE
Have a great day all!!
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 4:50 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE:
You need to start using Exception coding in your sql.
Basiclly ...
Begin
coding
...
Exception
When Error
Then
Do this
End;
Encase your sql statements in the begin/exception/end construct and code
accordingly. Here is an example. In this case, on thye update
Hi,
i am running following code
declare
cursor c1 is
select nm_enum_data from t_enum_data where id_enum_data in
(select distinct id_view from t_acc_usage_1
union
select distinct id_view from t_acc_usage_2
union
select distinct id_view from t_acc_usage_3
);
enum t_enum_data.nm_enum_data%type;
He wasn't. It was Dan Quayle.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 4:53 PM
To: Multiple recipients of list ORACLE-L
Deshpande, Kirti wrote:
Hi Joe,
Here is a blurb from the 8.1.6 Concepts Guide (Chapter 11, under
'Prefixed
and Nonprefixed
Hi,
Since every word requires a vowel and if Y is not one,
then I guess in the words FLY or SKY ... F, L, S or K
must be :)
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Mark
Srini,
I am sure you have lots of users in Prod compared to QA :)
Anyway, the point is that you are suffering from hot block contention which
reflects itself in latch waits on 'cache buffer chain'. I remember that
Steve Adams has a SQL at his site that identifies blocks that are 'hot' - I
have
depends on it's usage.
Mark Leith wrote:
Not being funny, but when did y become a vowel?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 07:47
To: Multiple recipients of list ORACLE-L
Actually, I think they are following a logical progression of english
Ok folks here's whats happening when I run 'sqlplus foo/bar@DEV':
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 6 17:02:49 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2:
Paul,
The W2K idea from Mark sounds good.
Another alternative I have read about which should work on either NT or W2K
is to make the OMS dependent on the other Oracle services.
From a Metalink posting:
reboot
I worked around this problem by using a feature in WINNT.
1. Start REGEDT32
2.
Hi,
I am running the code containing following statements
name1 :='t_pv_'||substr(enum,i+1)||'_1';
name2 :='t_pv_'||substr(enum,i+1)||'_2';
name3 :='t_pv_'||substr(enum,i+1)||'_3';
dbms_output.put_line(name1);
dbms_output.put_line(name2);
dbms_output.put_line(name3);
str :='update'||'
Thats a pain in the rear errer caused by DBMS_OUTPUT. DBMS_OUTPUT buffers
all its data up and then ships it to you at one time. For this reason you
need to define the buffer large enough to handle all your output.
In your code, put the line
DBMS_OUTPUT.ENABLE(2);
or some such number to
Hi all,
We have been running PATROL Agent on AIX (HP-UX, DEC/Compaq Alphas) for
over 2 years now to monitor Oracle databases. We have not found the Agent
Program taking up any considerable portion of any resources. The CPU % is
around 2-3 most of the times. We do not montior the OS using this
John,
Thanks for your input !
Unfortunately, this issue seems too weird ! (I know, I know, I shouldn't
be saying that as a DBA !!).
We have run that process three times today in prod in an effort to try and
isolate the issue. We have run it when only one other user was hitting the
prod database
LMGDAO!!
I am actually just reading Hannibal right now!! Damn u a nasssty man Dr.
Lecter!!
-Original Message-
Sent: Wednesday, June 06, 2001 09:53
To: Multiple recipients of list ORACLE-L
Oh, no doubt! I fully intend to get into
touch in the somewhat unlikely event i fly
over the
Lisa,
If you want an exact echo of Kevin's statement, count me in. We had a
similar situation in a far-away, tiny country called Brunei. AIX is the best
UNIX OS I have seen - at least for the SA. And the S80 is a lean, mean
monster.
John Kanagaraj
-Original Message-
Sent: Tuesday,
The reason is the limitation of your output buffer.
You should say 'SET SERVEROUTPUT ON SIZE 100' or give
the appropriate dbms_output.enable comand and it will work.
-Original Message-
Sent: Wednesday, June 06, 2001 6:06 PM
To: Multiple recipients of list ORACLE-L
Hi,
i am
Try with the PRAGMA EXCEPTION_INIT and EXCEPTION. That might
be a good start, as well as reading the fine manual.
-Original Message-
Sent: Wednesday, June 06, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am running couple of ddl statements dynamically
problem is
Harvinder,
You must have a carriage return at the end of the enum variable. Try
rtrim, like this:
name2 :='t_pv_'||substr(rtrim(enum,chr(10),i+1)||'_2';
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL
i am creating a report that involves several tables
(15) but for me to get the right result I have to
create a plsql statement that creates a table that
queries a couple tables. This table wil be used to
create another table queried with another table and so
on. I was reading the plsql
Hi Srini,
isolate the issue. We have run it when only one other user was
hitting the
prod database heavily using a select stmt on unrelated tables - but the
problem still persists. There were no concurrent requests
running at the
time. The issue does not seem to be related to contention of
I have big growing tables has default PCT_USED 40%, But we delete data
some
times one year or 2yrs data. What is optimum value for this parameter?? I
may consider my database is oltp. So how can decide a correct value for
this???
PCT_USED might not have any effect for you at all.
If you
What commant should I use to automatically logout uses in oracle who has
been idle for more than 30 minutes?
We have UNIX as an OS.
Thanks,
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Liggayu
INET: [EMAIL PROTECTED]
Fat City Network Services--
Srini,
How did you refresh your development instance, with an export and import?
Is it possible that in the process you've eliminated some chained/migrated
rows and/or rebuilt your index - essentially done a reorg? What comes out
of dba_tables on the two instances for these two tables?
David
In addition to the reason for your error, which someone else has pointed
out, this piece of code has another problem -- you never close your cursor.
This will get you into no ends of trouble at some point in the future, so I
though I should point it out. Also, a cursor for loop would be much
Mark,
Do you have a corresponding query for a Forms type environment where a user
can have more than 1 statement running at the same time.
For example,
In forms I can open 1 form and start an update - the query below will show
that as the current cursor.
If I then swap to another form and do an
My goal was to strongly favor indexes and make CBO behave like RBO.
Mladen,
I would have considered setting optimizer_goal=first_rows and would
appreciate hearing your ideas on why you decided to set
OPTIMIZER_INDEX_COST_ADJ to 30 instead. Thank you.
- Greg
Sorry if this is a duplicate ...
The parameter should be open_links
- Ethan
-Original Message-
Sent: Wednesday, June 06, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L
Off the top of my head I would say that you have a parameter
called open_link in your init which is not valid.
-Original Message-
Depending on your version of Oracle, you can use the DBMS_SQL package or
EXECUTE_IMMEDIATE to execute SQL DDL commands.
-Original Message-
From: Mark Liggayu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 6:56 PM
To: Multiple recipients of list ORACLE-L
Subject: creating
Thanks to both of you for these posts. I am passing it
along to team members...very helpful
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/6/2001 7:56 PM
Lisa,
If you want an exact echo of Kevin's statement, count me in. We had a
similar situation in a
Obtaining the triggering statement is beyond my ken. If I use a before trigger
and a cursor,
select
lower(replace( q.sql_text,' ',null))
from v$sql q, v$sql_cursor c, v$session s
where s.audsid=audsid and
s.prev_sql_addr=q.address and
q.address=c.parent_handle;
.
I get back
select
:)
I never read the books...bailed on McLecter #2, but the
whole profiling thing, Master Criminal thing is very
interesting...
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/6/2001 7:18 PM
LMGDAO!!
I am actually just reading Hannibal right now!! Damn u a nasssty
You might consider Dave Ensor's suggestion to set PCTUSED = 0! As inserts
occur, entire blocks are filled, but never put back on the free list until
they are completely empty - saving on the on/off/on/off/... freelist shuffle
that would mix records from different periods in the blocks and making
Quite a few products store dates as elapsed seconds after '01-JAN-1970:00:00:00' GMT,
but users here want to see the local time of the stored date. Of course PST is 8
hours behind GMT and PDT is seven hours so a hard coded offfset will not work. Also
the dates on which the change is made
Alex,
The answer to your question is: get several certifications
and become a consultant! grin, duck, and run like hell
Ross
p.s. anyone certified (or certifiable) who is deeply
wounded by this senseless attack is encouraged to contact
me offlist, where I will supply a heartfelt apology,
Can I cut in for a while.
After reading revealnet explanation on the REF CURSOR , I still feel confuse
on the usage of ref cursor and the actual CURSOR itself , what is the
different ?
-Original Message-
Sent: Wednesday, June 06, 2001 1:11 AM
To: Multiple recipients of list ORACLE-L
Thanks Danisment and Suzy. I have forwarded your suggestions to my friend.
Regards
Long
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, Long (ITS, Limestone Ave)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Hello friend , Gurus
I just start my Oracle developer job in April 2001, I feel interesting in
Oracle Dba jobs but my current job is stuck with only application
development .How can I build up my DBA skill if I did't have chance on doing
the related jobs ?
But I manage to build up a
Hey, i resemble that remark, damn, i wasnt supposed to tell anyone i was
certified.
I'm going to indulge in hostess snack cakes as a punishment.
joe
Mohan, Ross wrote:
Alex,
The answer to your question is: get several certifications
and become a consultant! grin, duck, and run like
Joe,
I can tell by your 'devil may care', 'will o' the wisp', 'ne'er do well'
response that you are *not* deeply offended. Congratulations.
Eric will be delivering a full Barbie set to your home shortly.
- Ross
p.s. I had three doughnuts in a row the other day, and let
the sugar and
On Wednesday 06 June 2001 16:56, Mark Liggayu wrote:
What commant should I use to automatically logout uses in oracle who has
been idle for more than 30 minutes?
We have UNIX as an OS.
Thanks,
Mark
Mark,
You can create a profile that has an idle time limit.
The problem with that is
Got it, I misunderstood your previous post.
If nothing else, I got some more good reading
out of the tuning manual. :)
Jared
On Wednesday 06 June 2001 02:36, Connor McDonald wrote:
Hi Jared,
My post was to meant to imply that (say) if (in a
single query - and thats the important bit I
Jim - We ran into this on Solaris. If you don't want discoverer, comment
out the last (4 I think) lines in
$9iAS_HOME/Apache/Jserv/etc/zone.properties and ignore the errors. If you
do want discoverer check out Note 131662.1. It says there that you need to
run the installer from the 'Solaris
Hi,
Kindly help me solving the following problem.
I have 2 table as follows,
TAB1
1. CUST_ID Number(6), --- PK
2. Name Varchar2(50),
3. curr_AmtNumber(12,2)
TAB2.
1. Tran_idNumber(3),
2. Tran_dtDate,
4. CUST_IDNUmber(6) --- FK to TAB1
5. AMT
Tim,
As SYS, run ?/rdbms/admin/catexp7.sql on the
Oracle 8 database.
You then use the Oracle 7 binary for exp to
export data from your Oracle 8 database.
You will then be able to import the resulting
file into your version 7 database.
Used it several times, works fine.
Exports created with
Dear Oracle-L Listers,
After 7 months of hibernation, it feels good to be
back. Thanks to many of you for your continued support
and encouragement over the past months. Some of the
interesting threads were forwarded to me in the past
few months, just so that I don't miss out on the fun.
Talk
This can be done using Profiles, check the Oracle Admin Guide chapter on
Managing Users Resources.
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/toc.htm
Mark Liggayu wrote:
What commant should I use to automatically logout uses in oracle who has
Do you want a paper to say you are marginally qualified to be a DBA or do
you actually want to learn database administration?
If it is the latter, my opinion is:
0) Learn as much as you can about Oracle in general. Being an exceptional
developer means understanding what your code does inside
The general theory about increasing PCTUSED is that blocks will be fuller,
but they may go on and off the freelist more often and that will hurt DML
performance.
But in reality what is the overhead of this? Isn't the need to bring more
blocks in and out of the data buffer greater than the
201 - 257 of 257 matches
Mail list logo