Mark,
The obvious redundant indexes are the ones the n columns of which happen to be, and
in the same order, the nth first columns of another index. There is not much which can
be said besides. First of all, I would question your definition of redundant as
never used by Oracle. Some indexes
eh?
Try the key next to '1' (to the left)...all depends on how your keyboard is
setup, nationality (of the os, not you :O).
-Original Message-
Sent: 23 December 2002 06:44
To: Multiple recipients of list ORACLE-L
Dear List,
I have Korn shell Script that show the date of
execution.
Hello Stephen
We are in the process of converting the use of tnsnames to oid.
Just yesterday, Deborah from Oracle Israel was here and created
replication environment, with failsafe between two oid servers.
You can contact me directly if you want more details.
Yechiel Adar
Mehish
- Original
There is also the issue of keeping an index that is
not used in any explain plan, but is required to
prevent a foreign key locking problem.
hth
connor
--- Stephane Faroult [EMAIL PROTECTED] wrote:
Mark,
The obvious redundant indexes are the ones the n
columns of which happen to be, and
Hi Jonathan
Would like to have Tests done for BOTH Small Big DB_BLOCK_SIZE ,
if possible , as mentioned below
Thanks
-Original Message-
Sent: Wednesday, December 18, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L
I think there are too many generic arguments
available for
Needless to say, it's on another key on my own keyboard ...
Ashraf, you may locate more easily that universal sign, $, and parentheses. In Korn
shell, you can also write
echo $(date) - Start shutdown of oracle DB.
HTH,
SF
- Original Message -
From: Thomas, Kevin [EMAIL PROTECTED]
To:
More More people are Accessing the Oracle Database Thru Java Calls , programs etc.
What basics , related Database performance issues etc. are part of this Java game with
respect
to the Database ?
How can a structured learning be done on this ?
Total Novice on Java here though familiar with
Cary,
I assume that using stored outlines will achieve No 2 in your list. Would
that not be an easier approach?
If you altered the system to have CREATE_STORED_OUTLINES=true and ran for a
period when all scripts are likely to be run, say a month so that all
month-end processing was completed,
John.
Our current problem has been narrowed down to two possabile troubles.
1 is the PERC controller card. The sysadmin missed the message that the
battery needed to be reconditioned a week or so ago. They reconditioned
the battery and the errror messages stopped and the connect time
improved
Title: RE: Happy Holidays
Some gifts are best left unwrapped ... you know what I mean ... (NO !!, you Sir ARE naughty indeed ...)
Happy Holidays
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Hi Stephen - you wrote -
I'm not orawoman, so I won't plan on join a girls night out, but I
hope there will be a list-wide gettogether with no gender discrimination.
I'm sure they will. And anyway, I wouldn't object to men at orawoman
night, I just think it would be fun to have us (orawomen)
Title: RE: Row cache locks on INSERTs with a sequence
If I stated dc_segments in my original post, I apologize, I *did* mean to say
dc_sequences. At any rate, as usual, the problem was poor application code.
The row cache lock no longer shows up as one of the top 5 wait events per
statspack.
Not 100% what you mean, but I have worked on several projects without VB and
.Net if you can give me some examples I'll see if I can help.
The biggest issues we have been facing with VB is dealing with dates and
numbers where the application and web server hate none IEEE formats.
- Original
list,
Cron server os RedHat 7.2
Database server os OpenVMS 7.3-1
Database Oracle 8.1.7 rel 3
Rman server os OpenVMS 7.3-1
Rman Oracle 8.1.7 rel 3
On the Cron server I have created a script that will backup the
database server and catalog the action on the rman server. When I try to
have
I also amnot sure what you mean.
I am currently on a VB project. One thing that we have developed as a
standard is to only perform database updates using Oracle PL/SQL stored
packages and procedures. VB does not perform any updates at all.
Queries are all performed using PL/SQL as well,
All,
Given that connections to SYS have to be done as sysdba, does anyone
know what the JAVA syntax looks like to connect to the sys user? I'm
writing a procedure for compiling any invalid objects and, while a system
is ok for 99% of the problems, it doesn't have permissions for fixing
sys
Are you executing (or running) the env variable script; then running the
backup script? If so, then the env script sets the variables OK ... in the
sub-shell that ran it! When that sub-shell finishes the env script, then
your variables exit with the sub-shell. If this is what you have going
Ron,
my guess is that your profile file is not being executed by the cron process
properly.
try changing your test.sh script to explicitly point to your profile file.
paths are not set properly by cron because the cron job is executed by a
system account, not the oracle account. secondly, try
Hello,
I am looking for mailing lists for MS Windows
NT/2000/XP Administration which is similar to ORACLE-L
from fatcity.com.
Thanks in advance.
Bob
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Ron
try altering test.sh to read
. /alphaprd/profile [ notice the extra space ]
That should set the environment in your current shell which isn't happenijng
at the moment.
Regards,
Mike Hately
Oracle DBA
-Original Message-
Sent: 23 December 2002 14:24
To: Multiple recipients of
We assessed this and discarded the option, and now I can't remember why
(I'll get back to you after I ask Jeff Holt, who did the study). At
best, using stored outlines is a replacement only for steps 2 and 4. The
really hard part is step 1.
Cary Millsap
Hotsos Enterprises, Ltd.
Ron,
Try setting your environment variables in your test.sh script. I'm not a unix guru,
so I can't tell you why your profile isn't being used when the script is run from
cron, but my guess is that is what is happening.
Jay
[EMAIL PROTECTED] 12/23/02 09:23AM
list,
Cron server os RedHat
I suppose I should add that you can also have the backup script dot the
env script.
For example:
- backup_script.ksh -
#!/usr/bin/ksh
. /path/to/env_script
etc.
etc.
etc.
---
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent:
First do you know how to program? Really program; not talk about how to
program but actually type in code and get what you want.
If you do then learning 85% of java or any language won't take too long.
I sugest you download some JDBC examples and try them out. Change stuff
then try again.
On Mon,
Please don't laugh. What is the equivalent of a Right() function in
Oracle? I want to be able to sort a column numerically whose string
contents takes the format v1, v2, v3, v4. I was after something like:
ORDER BY Cast(Right(lt_tk_id, Length(lt_tk_id - 1)) as int)
but it's not playing nice.
http://peach.ease.lsoft.com/archives/winnt-l.html
Hello,
I am looking for mailing lists for MS Windows
NT/2000/XP Administration which is similar to ORACLE-L
from fatcity.com.
Thanks in advance.
Bob
__
Do you Yahoo!?
Yahoo! Mail
Ruth G is definitely not a male Guy H? who was a contributor on the
Oracle_l list used to sign as Guy Ruth H? is think. I don't remember his
last name, but I think it began with H.
Ruth g
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
Title: RE: Java to Database Basics
From: Alex [mailto:[EMAIL PROTECTED]]
First do you know how to program? Really program; not talk
about how to
program but actually type in code and get what you want.
If you do then learning 85% of java or any language won't
take too long.
I
list,
Received this today.
Ron
[EMAIL PROTECTED] 12/21/02 06:08PM
Oracle Security Product Management Issues Security Alert #47
This e-mail contains a critical, technical alert which is being sent as
a service to all Oracle MetaLink users.
Oracle Security Product Management team has issued
Just as a side-line observation - when I realised
that the problem should have been with the sequence,
I set up a small test on a multi-CPU box to run multiple
concurrent copies of:
begin
for i in 1..10 loop
insert into t1 values (test_seq.nextval);
end loop;
is this what you're after?
Steve
tsoadm(14)@SMP l
1 select substr ( 'left or right', -5) right
2 , substr ( 'left or right', 1, 4) left
3* from dual
tsoadm(14)@SMP /
RIGHT LEFT
right left
1 row selected.
- Original Message
Sorry,
It was a rhetorical question.
Detailed results come under the heading
of company confidential - generic results
come under the heading of repetition.
You just have to list the set of point (see my
earlier point) about why smaller or larger blocks
MIGHT make a difference that you could
Come-on Ruth, you had the operation. we know it. you escaped to the dark
side.
-Original Message-
Sent: Monday, December 23, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Ruth G is definitely not a male Guy H? who was a contributor on the
Oracle_l list used to sign as
Step 6 should be fun -
It is possible to come up with code where plan A is
better than plan B in low concurrency systems,
but plan B is better than plan A in high concurrency
systems.
Similarly, plan X is better than plan Y if no updates are
taking place concurrently, and plan Y is better than
SUBSTR(char,m[,n]) A subtring of char beginning at byte m, n bytes long (if
n omitted m to end of char)
i.e. If a = 'ABCDEFGHI'
substr(a,7,3) = 'GHI'
substr(a,7) = 'GHI'
-Original Message-
Sent: Monday, December 23, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Please don't
Laugh at you? Never, well once in a while.
As for your problem, first thing I'd like to know is the version of Oracle
your using. 9i I know has added several functions that do not exist earlier.
Since 8.1.7.4 in my latest instance the 'right' function does not exist, so I'd
suggest using
The equivalent will be substr in one of it's many forms
SUBSTR(char, m [, n])
Returns a portion of Char, beginning at character M, N characters long.
If M is positive, Oracle counts from the beginning of Char to find the first
character.
if M is negative, Oracle counts backwards from the end of
Guy Ruth Hammond. who as it turns out is a friend of someone I now work
with here, so I do get to hear of him on occasion. I miss his recipes!
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
Ruth G is definitely not a male Guy H? who was a contributor on
the
Oracle_l list used to sign as Guy
order by to_number(substr(lt_tk_id,length(lt_tk_id)-1))
Brilliant. Thanks to everyone that mentioned substr.
--
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
OK, NOW can we laugh with you!!
Dick Goulet
Reply Separator
Author: Aidan Whitehall [EMAIL PROTECTED]
Date: 12/23/2002 9:44 AM
order by to_number(substr(lt_tk_id,length(lt_tk_id)-1))
Brilliant. Thanks to everyone that mentioned substr.
--
Aidan
I believe 1998 was the last year they provided CDs with papers and
presentations. Does anyone still have the 1998 CD and is willing to
share it?
Please mail me directly off list: [EMAIL PROTECTED]
Thanks,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L
Title: RE: Row cache locks on INSERTs with a sequence
Jonathan,
The inserts were into a staging table. After the staging table was
loaded into the live tables, they were using delete and not truncate
to flush the staging table. So of course the table and index were
acquiring an excessive #
Ah, yes, Jeff has restored my memory (below). If your application does
not use bind variables, then you have many more distinct SQL
statements than you actually *should* have. ...Which is another reason
that collecting the SQL is such an important step. If you do it with too
simple of a matching
Yeah - I remember that Guy used to churn out _very_ yummy (and chocalately)
recipes once a week. So where is he now Rachel?
John
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 23, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L
Dennis -
1+2;) The current project will be build with the classic relational data
modell. On top of it sits a OR-Mapper (not a
full-blown-vapor-ware-application server though ;) and the software will be
developed in java. The software development team is VERY experienced with
object oriented
Hi
I hope not, but I'm having more and more difficulties to find valid points
for a good old database centric approach except for data integrity ...
which, after looking at how a lot of people act, might not be so important
after all ;)
Regards,
Stefan
-Original Message-
To: Multiple
and when you're done with that, start improving the JBoss code.
and when you're done with that, have yourself shipped off to the asylum
;).
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/23/2002 5:38 PM
From: Alex [ mailto:[EMAIL PROTECTED]
mailto:[EMAIL
Title: RE: Out of topic -Unx question
The cheap easy way
Is to have a cron job that runs at midnight and echo's today's date to a file called today.date
But before that it copies that file to yesterday.date
Then all you have to do is cat yesterday.date to get the date.
It may not be the
Hi Glenn
Now that's some interesting information. It looks like a lean-mixture
(isn't that what we all run on ?;), respectively sql/xml, xml-db is the way
oracle is headed at. wasn't there an xml-db feature in the latest oracle mag
issue ? looks like I have to take a look at it.
happy holidays,
Phew, finally I found something meaningful to do over the holidays. And I
was already afraid that I might have to spend time with family ;).
No seriously, thanks, I also think I have a copy of his book at my office,
so I'll start there.
happy holidays,
Stefan
-Original Message-
To:
Here is a book I put beneath my pillow:
Prentice Hall, SUN Series, Core J2EE Patterns (esp. from page 388 on:
Integration tier patterns) by Alur/Crupi/Malks, ISBN-0-13-064884-1
Also alot of specs and papers from the sun java site, like EJB, JTA/JTS
(Transactions), JMS (Messaging), JDO (Java Data
Forgot something: For a general understanding, I like the books by Peter
Coad and Bruce Eckel. These guys really know how to explain stuff and how to
think.
regards,
Stefan
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/20/2002 8:38 PM
Jeremy - Our developers
If anyone has a conference program or other documentation with session
listings from 1998, could you please contact me off the list.
Really interested in the who's who of Oracle 7.3 tuning!
Thanks!
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ:
On the other hand, the business logic would be found partially in the
database and partially in the application server.
This sounds dangerous and non-performant/scalable.
Dangerous because data could easily be changed outside of the
application and be unaffected by your carefully crafted
he's still in England, just busy and no time for the list these days
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Yeah - I remember that Guy used to churn out _very_ yummy (and
chocalately)
recipes once a week. So where is he now Rachel?
John
-Original Message-
From: Rachel
my unix sysadmin was kind enough to give me following few monts ago. Works
great and can be used for creating any date in dd-mon-yy format
DAY=`perl -e 'use POSIX qw(strftime); print strftime(%d-%b-%y,
localtime(time() - 86400)) . \n ;'`
HTH
Shaleen
- Original Message -
To: Multiple
Thank you...
--- Thomas, Kevin [EMAIL PROTECTED] wrote:
eh?
Try the key next to '1' (to the left)...all depends
on how your keyboard is
setup, nationality (of the os, not you :O).
-Original Message-
Sent: 23 December 2002 06:44
To: Multiple recipients of list ORACLE-L
Title: RE: Happy Holidays!!
Indeed is Vey mutual . Like Fems too (more the merrier) .
ha ha
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Saturday, December 21,
2002 12:16 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Happy
Guys,
i want to export table data into a CSV file.
i am using the script below to do the same.
--
set wrap off
set linesize 2000
set feedback off
set pagesize 0
set verify off
set termout off
spool ytmpy.sql
prompt prompt
Hi Listers,
Could someone give me simple explaination how to installed 'Oracle
Application Server', I have Oracle 9.i database on my server and I wonder
why it always failed when I connect into Oracle after I installed
Application server, do I make any mistakes in setting or configuring it, how
60 matches
Mail list logo