We just bought it and will start using it this month
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 5:28 AM
> Hi there
>
> Been using it on and off for 2 yrs now since the original standard
edition.
> Very good and def wo
tr "[A-Z]" "[a-z]" < lame.sql > lower.sql
This of course hoses any quoted arguments in the where clause,
but those are easy to fix.
Jared
"Johnston, Tim" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/03/2003 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of
JFYI, (it's in Russian and PL/SQL :))
http://www.oracle.com/ru/oramag/june2001/index.html?begun.html
Be careful with standard.replace (<9i) and recursion in PL/SQL.
Connor McDonald wrote:
From AskTom
...
Kind Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
d
FWIW, TOAD includes some version of Formatter Plus, which does a fair job on
simple queries. It doesn't handle subqueries, though. Perhaps that's only
with the separately licensable product. I *think* it even comes with the
freeware version of TOAD: http://www.toadsoft.com
Any other SQL (pronou
Title: RE: Replacing control chars
didn't my script do the same thing ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN In
And people get so pissed when you take the time to do this while they are
standing over your shoulder... I take a perverse pleasure in making them
wait... While we are on the subject... I also get annoyed by mixed case...
I hate the queries that look like...
SELECT *
from MY_table_NAME a,
Sergei,
My first guess will be you are using a loop and you are committing
intermittently. If so, then the rollback segment used is not RBIG20. Any
time a commit or rollback occurs, you are starting new transaction and
hence a new rollback segment may be allocated; in this case it's R27.
The sec
No.
-Original Message-From: Shishir Kumar Mishra
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 03, 2003 1:14
PMTo: Multiple recipients of list ORACLE-LSubject:
SavePoint doubts
Hi List,
One dumb question I want to ask is :
Is it possible to declare Savepoint w
finish the paper please, it's only 3 weeks overdue!
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I don't have code, but an idea. Instead of replacing the unprintable
> characters, could you just extract (using ASCII, CASE and ranges) the
> known
> good characters into a new variable? You migh
Sergei;
Is it a simple update/insert into a single table ??
Does the table have any triggers on it ?
Do you commit anywhere in the update and then do another update/insert ?
How about showing the update/insert code you are running.
-Original Message-
Sent: Friday, January 03, 20
I've seen no problem along those lines.
Dick Goulet
Reply Separator
Author: "Shishir Kumar Mishra" <[EMAIL PROTECTED]>
Date: 1/3/2003 11:14 AM
Hi List,
One dumb question I want to ask is :
Is it possible to declare Savepoint with same name in diffe
Title: RE: strange issue with setting transaction
Sergei, are you committing in your "transaction"? A transaction ends with a commit or rollback. Therefore if you execute set transaction use rollback... then commit, the next transaction will grab whatever rbs it wants unless you specify set
Sergei,
Do you get the same error each time?
Here is what I think is happening (please, gurus, correct me if I am
wrong). Your transaction needs to create a read consistent version of a
block to see if another transaction has modified the row you are interested
in modifying. Thus it
Of course, the savepoint can be any name you
choose; it does not matter if they are the same in different
sessions.
- Original Message -
From:
Shishir Kumar
Mishra
To: Multiple recipients of list ORACLE-L
Sent: Friday, January 03, 2003 2:14
PM
Subject: SavePoi
Sergei wrote:
>
> I am running 8.1.6 on solaris 2.8.
>
> Before running a large update, I tried to set a specific rollback
> segment by:
> Set transaction use rollback segment RBIG20;
>
> The transaction runs for a while and fails with:
>
> ORA-01555: snapshot too old: rollback segment number 2
The reason that I consider it a problem is that I have increased the physical IO on
my database. I see Full Table Scans on these two tables, which are large tables
relative to the others. I moved them to they RECYCLE pool so that they would have
less of an impact on the DEFAULT pool. By doi
Jonathan Lewis wrote:
> The problem is generic, the specific query
> isn't the point. RAC is a massive improvement
> on OPS because block transfer is by wire not
> disc - but it still takes a serious amount of
> time to fling blocks from node to node, especially
> if the blocks have been subject t
I am running 8.1.6 on solaris 2.8.
Before running a large update, I tried to set a specific rollback
segment by:
Set transaction use rollback segment RBIG20;
The transaction runs for a while and fails with:
ORA-01555: snapshot too old: rollback segment number 29 with name "R27"
too
Small
Any id
Title: RE: Perl DBI/SQL question - For those who use it...
Muchas Gracias Tim! I can't thank you enough. I will play with it, it looks like it may meet my needs.
Lisa
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 1:09 PM
To: Multipl
Hi List,
One dumb question I want to ask is :
Is it possible to declare Savepoint with same name
in different session on same database. I just want to know will commit or
rollback vanish savepoint with same name in other session also
.
Thanks and Regards
Shishir Kumar MishraAgni Sof
Thanks Connor.
I think this might do it..
- Kirti
-Original Message-
Sent: Friday, January 03, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
>From AskTom
ops$tkyte@8i> create or replace package body utils
2 as
3
4 g_bad_chars varchar2(256);
5 g_a_bad_char va
Title: Perl DBI/SQL question - For those who use it...
Hi Lisa,
It's been awhile since I've used Perl DBI, but from
what you said, I think you're mixing up two different ideas. Ksh doesn't know
how to talk to a database, so you just use it to invoke sqlplus, which handles
the database commu
Hi,
can anyone on this list provide good links (in English or German) on job
chances in the IT in Sweden?
Do they need developers and Oracle database developers/admins? In which
regions? What is the payment?
I would be greatful for any hints.
Please mail me directly to [EMAIL PROTECTED]
Have a ha
What do you have so far.
You can read in a script like so...
#perl dbicode.pl < script.sql
while () {
chomp;
$sql .= $_;
}
print $sql;
On Fri, 3 Jan 2003, Koivu, Lisa wrote:
> Hi everyone,
>
> This may be a stupid question. If so please humor me with a stupid answer.
> However:
>
> I F
Title: RE: Perl DBI/SQL question - For those who use it...
I think I just answered my own question after reading through Charlie's example code...
The errors that would be spit to the screen would be returned in $DBI::errstr.
Lisa
-Original Message-
From: Koivu, Lisa
Sent: Fri
Sorry,
I can't take credit for improving the query.
The improved time looks like an accident.
The plan now has two scans of OBJ$, rather
than one - it just that the two plans take 4 and 9
seconds - whereas the single scan in the first
plan took 370 seconds.
I guess that the first plan was a maj
All,
I recently did the 9.0.1.4 upgrade from 9.0.1.3 in our development (Solaris
8) instance. We are now seeing all sorts of REALLY bad performance effects.
Subsecond querries are running 2 and 3 minutes. As near as I can tell,
querries using order by and group by clauses now seem to prefer full
Dick,
I did some work on this some time ago, but never got around to fully
implementing it. What it was supposed to do is take a day's worth of stats
from each instance and store it in a table called DAILY_STATS. We take
hourly stats on each instance, so the procedure takes the stats from today'
Title: RE: Centralized StatsPack Repository
Raj
I did this sometime back
but later on somehow this went on to the backburner.. (I also had half-developed
XL based interface to the central statspack data)
In the central repository
create the set of tables that statspack uses to store data
Title: RE: Replacing control chars
REPLACE/TRANSLATE. Go to http://asktom.oracle.com/ and query 'remove control characters'.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Title: RE: Perl DBI/SQL question - For those who use it...
Jared, thanks for your reply.
One last question: Is SPOOL one of the commands that DBI does not understand? I would need to capture any errors spit out by sql*plus (like my famous ora-1410 error). I have a feeling the answer is y
Title: RE: Replacing control chars
Raj,
Thanks
for the response.
Input
is not an HTML text, but the JSP Web page where text can be typed or "pasted"
in. And the pasting from MS Word docs creates the problem.
-
Kirti
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PR
Try
dbish dbi:Oracle:tnsname < commands.sql
The dbish is a "DBI shell" supplied with the DBI.
The version supplied with the DBI is functional but basic.
Tom Lowery is working on an extended version with plugins
adding more functionality. One of his goals is an SQL*Plus clone...
http://sea
>From AskTom
ops$tkyte@8i> create or replace package body utils
2 as
3
4 g_bad_chars varchar2(256);
5 g_a_bad_char varchar2(256);
6
7 function strip_bad( p_string in varchar2 ) return
varchar2
8 is
9 begin
10 return replace(
11 translate( p_stri
Sure. For every instance that you want to include in
the repository, create an account name that matches
the instance.
Setup FGAC so that each sees only it's own data.
Jared
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/03/2003 07:08 AM
Please respond to ORACLE-
Title: RE: Replacing control chars
Kirti,
if the input is going to be HTML, then I have no clue how you'd do it, but if it is just a varchar2 then something like following might help ...
SELECT REPLACE( UPPER(:my_str)
,REPLACE( TRANSLATE( UPPER(:my_str)
Yea same here, column names, table names all on separate lines :)
joe
> >Personally, I always format queries before working
> >with
> >them, otherwise it is too difficult to determine
> >what is
> >being done in the query.
> >
> >Jared
> >
>
> Glad to see a fellow maniac :-).
>
> Regards,
>
I don't have code, but an idea. Instead of replacing the unprintable
characters, could you just extract (using ASCII, CASE and ranges) the known
good characters into a new variable? You might have to examine character by
character, which may slow things down.
Excellent challenge...must think about
Lisa,
No, you can't call a sql script from Perl/DBI, sorry.
The SQL scripts you refer to are for SQL*Plus, and contain
a number of commands that DBI doesn't know what to do with.
Your SQL can be stored in a different file to avoid script modification
for different SQL, but that requires a little
D'oh. Just saw that I was replying to a two-week old message.
That's what I get for taking a vacation! :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Jess
Hello Listers,
I was asked if there is any procedure that could be called from a trigger to replace
(with a blank) or remove all non-printable characters from the text before inserting
it in the target table? The incoming data is from a Web interface and may contain
underline, bold, blink, NL c
Title: Perl DBI/SQL question - For those who use it...
Hi everyone,
This may be a stupid question. If so please humor me with a stupid answer. However:
I FINALLY have the fun fun fun chance to change one of my data loads to use the DBI instead of the procedures I hacked together. In tr
Or it's time spent dealing with Oracle's Context/Intermedia/Text indexes.
And if that's the case, there's nothing that can be done to reduce it
according to Oracle Support. See the other thread you (Seema) started on
the same subject.
Rich
Rich Jesse System/Database Adm
>Personally, I always format queries before working
>with
>them, otherwise it is too difficult to determine
>what is
>being done in the query.
>
>Jared
>
Glad to see a fellow maniac :-).
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Title: RE: Tales Of Big Hammer #10046 (AKA event 10046)
Jonathan,
Yes this code is inside a function inside a pl/sql package. As it is an implicit select, with (of course) no exception handler (who needs extra code anyways), I believe your hypothesis is right. Maybe next week I'll take a loo
I wonder if a file lock is being left in place when the instance crashes,
and the OS does not clear the lock until a reboot. I would think the OS
should clear this without a reboot, but stranger things have been seen with
OS's ... even Unix. This doesn't explain why the instance crashes. I
wond
2 things:
1) don't send attachments to the list, they rarely
arrive unscathed. Yours didn't.
2) why do you think the full table scan is an 'error'?
It could be that an FTS is the fastest access method
for this query.
3) ok, three things. Please make an attempt to format
longish queries so th
Title: RE: Centralized StatsPack Repository
Hmmm... FAGC ??
Jared, I am stumped ... I can't put these 2 & 2 together. I was planning on a new instance called "dbmon". One schema for each production database instance. Statspack will be installed for each schema and other monitoring scripts t
select dbms_java.long_name(object_name) from user_objects
where object_type like 'JAVA%';
Richard Ji
-Original Message-
Sent: Friday, January 03, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L
How do I list java classes that have been loaded into my schema via
loadjava?
John Dun
Title: RE: Extremely Slow Query
Thanks everyone ...
Yes it is RAC (in fact I don't have non-rac databases anymore). Unfortunately this is not my query. TOAD runs this query when it starts-up and it seems like it hangs. As I am in process of deploying newest version of TOAD, I am pretty sure n
Title: RE: Which side of the road?
Mike,
Thanks for the link. I lived in England for 4 years so I have driven on both sides of the road including a LHD vehicle in the UK. Also my old BL Princess had a manual transmission so I can now shift with either hand.
The first day I drove in the UK
Rich
Is it nice to have an operating system that works
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, January 02, 2003 4:
/*+ Object type='JAVA CLASS' ?? */
;)
- Kirti
-Original Message-
Sent: Friday, January 03, 2003 5:49 AM
To: Multiple recipients of list ORACLE-L
How do I list java classes that have been loaded into my schema via
loadjava?
John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com
-
For some Friday afternoon reading on what country drives on which side of
the road and reason for it follow this link:
http://www.travel-library.com/general/driving/drive_which_side.html
I had half an idea but the site is a good read, in a sad trivia kind of way!
Mike.
--
Please see the offici
I also was informed during the iTAR process that they will support a centralized
repository, but you'll have to wait till 10i for it. Heck I've haven't gotten a
play instance of 9i up yet. 10i, maybe by 2010!!! I really don't want to wait
that long!!
Dick Goulet
Reply Separ
Hi there
Been using it on and off for 2 yrs now since the original standard edition.
Very good and def worth while, Alexey also normally releases a new/updated
version every 1-2 months.
There is some great features planed for the future from discussions with
him.
George
_
You have a outer join in yr history table. Also you have a IN condition for
the history table for which the CBO might think a FTS might be cheaper..
Babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 7:19 AM
> Hi List,
Hi List,
I have the below query whose explain plan is showing that it is doing full
table scan on Historie table:
select F1.AMTLICHESKENNZEICHEN
AMTLICHESKENNZEICHEN,F1.OID,F1.VERKAUFSBEZEICHNUNG,B1.FAHRZEUGARTTEXT,B1.FAH
RZEUGHERSTELLERTEXT,B1.FAHRZEUGTYPTEXT,B1.FIN,B1.VERKAUFSBEZEICHNUNG,H1.AUF
Closing a cursor doesn't release the lock.
Think of it in SQL*PLUS. If you issue a SELECT ... FOR UPDATE statment, it
opens an implicit cursor returns the rows and closes the cursor. But it
doesn't release the lock.
Locks can only be released by COMMIT/ROLLBACK
Regards
Naveen
-Original Mess
How do I list java classes that have been loaded into my schema via
loadjava?
John Dunn
Sefas Innovation Ltd
0117 9154267
www.sefas.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 htt
Hi List,
Little confused about the locks. I wrote a plsql procedure as follows:
---
CREATE OR REPLACE procedure b as
cursor sel_up is select * from emp_info for update;
begin
For emp_rec in sel_up1 LOOP
dbms_output.put_line('Hi');
End loop;
end;
---
I am doing select for upd
>In the explain plan what is meant by "cost" ,
>"card" and "byte" ?=0D
>How may they be interpreted practically ?=0D
>Any Docs , Links on the Same ?=0D
> =0D
> =0D
'cost' like in 'cost based analyzer' - compound value which gives the CBO estimate of
how much dreadful it will be to bring
It is not possible to increase the number of
lgwr processes in a single instance until
9.2, and the manuals suggest that (a) you
don't do it, and (b) you only do it if you have a
very large number of CPU and massive stress
on redo generation.
Let me repeat - v$system_event can be very
misleading,
Cost is the optimizer cost. Card is cardinality. Byte is number of bytes
processed in that particular step. Lots and lots of documentation on this.
VIVEK_SHARMA wrote:
Message
In the explain
plan what is meant by "cost" , "card" and "byte" ?
How may they be interpret
At a high level, I think the various pools operate in pretty
much the same way - but there are some differences,
some of which may be affected by various hidden
parameters.
For example, Steve Adams has this note (dated Oct 2000)
on his website as one of several observations on the 'new'
LRU mecha
Title: Message
In the explain plan
what is meant by "cost" , "card" and "byte"
?
How may they be interpreted practically
?
Any Docs , Links on the Same
?
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE
(Cost=6 Card=
The problem is generic, the specific query
isn't the point. RAC is a massive improvement
on OPS because block transfer is by wire not
disc - but it still takes a serious amount of
time to fling blocks from node to node, especially
if the blocks have been subject to very recent update
at the re
Thanks Mogen!
Jared
On Wednesday 01 January 2003 21:03, Mogens Nørgaard wrote:
> Good morning,
>
> A few days ago there was a debate about the issue with
> invoker/definer-stuff. I wrote to Mary Ann Davidson, who's responsible
> for Oracle security things (she's the female guru you may have seen
68 matches
Mail list logo
