Mark,
The (GLOBAL_DBNAME= l1000.)
entry looks strange. Should there be a '.' in there? I've never seen this
entry in this file. What does : lsnrctl status & lsnrctl services show?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16, 200
Firstly Arslan, it should probably be pointed out that this is an Oracle
list, not SQLServer. But, seeing as I deal with both database types, I'll
have a stab at this..
You can create jobs under the "SQLServer Agent". If you open up SQLServer's
Enterprise Manager, and navigate to your "Server", th
Try to have the SQL Server DBA fired.
>- --- Original Message --- -
>From: <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Fri, 16 Jan 2004 04:59:26
>
>Hi ,
> How can i create a job in sql server ?
>
>Rgds.
>Arslan.
>--
>Please see the o
Ramon,
Take a look at the DBMS_RANDOM package. You can replace the name with a
random number. That ought to do the trick.
Good Luck
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16, 2004 7:49 AM
To: Multiple recipients of list ORACLE-L
> Hi
Hello Mark,
all 3 instances are listening on the same port.
Cheers
Barry.
-Original Message-
Mark Leith
Sent: 16 January 2004 11:14
To: Multiple recipients of list ORACLE-L
Hi All,
I'm helping out a friend of mine who's having problems with connecting from
an NT system to an HP system
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and costs the earth to maintain?
--- "Noyce, Robert A SITI-ITPSIE" <[EMAIL PROTECTED]> wrote:
> Apparently to celebrate his new marriage, Larry is releasing the new
> Oracle 10G Marriage Builder pro
can't beat them, join them...
:)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
> Excellent reasoning Nuno. I hadn't thought of that.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
INET: [EMAIL PROTECTED]
Fat City Network Service
Chris,
I've worked on a large Powerbuilder App for a number of years. We used CBO all
the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se
requiring RBO is rubbish.
Cheers,
Chris Dunscombe
Quoting Chris Stephens <[EMAIL PROTECTED]>:
> I'm working with a 3rd party vendor
1. that
Set oracle_sid=
Sqlplus user/password
Works on terminal server.
2. I like the workspace memory management features as well.
3. trace file timings in microseconds.
4. Cursor_sharing=similar (still has the odd bug).
5. HTMLDB is marketed for 10g but will install on 9.2
Nial
> I'm having an ora-1555 under Oracle9 database and not
> sure what I can do to get rid of it. I had some
> recollecions from Oracle8 days , but the things like
> adding a new rollback segment or shrinking the
> segments I don't think are applicable under the auto
> undo management. Besides separat
Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G
Marriage Builder product, it requires plenty of tuning and costs an absolute fortune.
Other features include Parallel nagging, a new wifemon process that never clears
anything up and after 3 months the whole product
If the datafile is off-line? (Not tested, just a guess.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Fri 1/16/2004 12:04 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Checkpoint ...
All,
Whenever checkpoint happens datafi
racle DBAOracle Certified 8i
DBA
-Original
Message-From: Teresita Castro
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
The CD's that we have said Oracl
racle DBAOracle Certified 8i
DBA
-Original
Message-From: Teresita Castro
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
The CD's that we have said Oracle 9.
ltiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
ott.af.mil> S
comments in line...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 11:04 AM
>
> Wow, your buffer cache hit ratio for this query is better than
> 99.99%! With a BCHR like that, how could you possibly tune this
> qu
Title: RE: alter table rename error
Eric,
No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: eric
On 01/15/2004 09:54:36 AM, Chris Stephens wrote:
> There response was that it's a limitation of powerbuilder. I don't buy that
> for a second. ...anyone know for sure?
I have slight experience with supporting Powerbuilder apps in 1996 and,
later, in 1998. At that time it was completely possibl
This is a good question. We've been running 9i instances for 18+ months
now. Here are my impressions:
I would say RESUMABLE, especially for bulk loads, export/import,
sqlloader is #1. This has saved HOURS!!!
Dynamically modifiable SGA parameters have helped us with reliability.
Less need to ev
Repost ...
-Original Message-
Sent: Wednesday, January 14, 2004 9:14 AM
To: '[EMAIL PROTECTED]'
L&G,
Has there been any issue monitoring and administering 8i databases using 9i
tools? I am seeing some strange behavior when using 9i OEM tools to monitor
8.1.7.0 database and unfortunatel
nsultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of DENNIS WILLIAMS
> Sent: Tuesday, January 06, 2004 3:54 PM
> To: Multiple recipients of list ORACLE-L
>
Powerbuilder is a GUI. just like forms. This is what typically happens with
3rd party apps. They develop them some time in the past. Oracle adds new
features, they dont want to spend the money to test to see if it works. So
they tell customers not to use them. Its how they keep costs down. New
deve
Title: Message
Rewrite the query without specifying the owner name and it
works.
Alter
table emp to employee;
-Original Message-From: eric king
[mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004
12:00 PMTo: Multiple recipients of list ORACLE-LSubject:
alter tab
Comments inline
On 01/15/2004 04:14:27 PM, Ryan wrote:
> I was flipping through Tim Gorman's Data Warehouse and he has a short section on
> using named pipes to kick off > sql loader when you send files to your data
> warehouse with ftps.
Tim is a resourceful guy. I scripted it once for export
Brad,
- External Tables have the potential to be WOW and when properly used
instead of SQLLDR can meet #1 & 4.
- Resumable transactions
Stephen
>>> [EMAIL PROTECTED] 01/15/04 10:14AM >>>
Hey listers
I am doing some research and would like to get (in very short answers)
features of 9iR2 tha
You cannot specify a schema in the rename clause. Simply change your
statement to "alter table scott.emp rename to employee". The table will
stay within the scott schema even if the command is executed by another
user.
Title: Message
Eric,
Try:
ALTER
TABLE scott.emp RENAME TO employee;
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to compensate him for what he is not, and a sense of humor was
provided to console him for what he is." --Unknown
-Or
try again...
-Original Message-
Chris
I know from a previous assignment that PowerBuilder has no issues running
queries against a database using the CBO. In fact, PowerBuilder doesn't give
a rats backside what the database does to the query as long as it returns
what's expected.
As for "
Chris
I know from a previous assignment that PowerBuilder has no issues running
queries against a database using the CBO. In fact, PowerBuilder doesn't give
a rats backside what the database does to the query as long as it returns
what's expected.
As for "redundant" constraints, they will increas
Title: Message
He's
right, accessing the database is expensive. So is accessing from an app
server if you have to support concurrency, updataing, transaction
control, etc. Only if you consider the ACID properties of databases
of no use for your application is this line of argument correct.
ita Castro
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 15,
2004 12:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Hi!! Veritas Backup
Question
Hi!!
The CD's that we have said Oracle 9.2.0.1.0, but I
did not see any that said RMAN,( when I asked the DBA the ve
Brad,
We're primarily using 9i with a third party time accounting system, so I
haven't had too much time with a lot of 9i, but the resumable transactions are a REAL
time & energy saver. The Time accounting system has to do bulk data loads from our HR
system as well as it's own batch pr
If you have the room, I would suggest doing a daily export of the
database until you get all the problems ironed out with Netbackup.
Especially if you are trying to do incremental backups. That way you
will at least have something to restore with if you find out your
Netbackup plan wasn't working.
ely.
Jared
"Jonathan Lewis" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/14/2004 11:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Reset sequence a
Teresita,
You've gotten some good comments...even a quick tutorial on backups. My
recommendation to you (especially if you don't have any backups at all) is
that until you're more familiar with the tools you have that you should
initially avoid the complexities of incremental backups and immedi
Hi!!
The CD's that we have said Oracle 9.2.0.1.0, but I
did not see any that said RMAN,( when I asked the DBA the version of Oracle that
we have and he said 9.2.0.2.1.) the RMAN is inside a specify
CD?>>> [EMAIL PROTECTED] 01/14/04 09:49PM
>>>
Teresita,
What your
DBA is talking abou
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file
remotely. But you need to make sure that the user who fires off the copy command has
write access on the shared destination directory.
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred Stat
Arslan,
Per the OTN webstie..
Q: How do I change the e-mail address in my membership profile?
A: OTN's membership management system does not let you change your
email address in your membership profile. Please create a new account
with the new email address you wish to use.
Ron
>>> [EMA
Teresita,
The first thing I would do is
to make sure and make full, cold backups by
shutting down the database and doing a tape backup of the disk
your database files are on. This will keep you out of trouble
immediately.
Then, since you said you were
using Oracle 9.2.0.2, set up your b
Hernawan,
Is this a custom or standard Concurrent request? If this is standard, there
may be a patch out for your module/level. If not, I would use a 10046 level
12 to look at the issue. As you can see from tkprof, you have a huge amount
of LIO... Is your init.ora parameters kosher as per Oracle 1
I have just done an Amazon search, I guess that Melanie Craft's book 'A Hard-Hearted
Man (Intimate Moments, No 870)' will bring some terrific change to my usual reading
list. Although one of her other masterpieces, 'Trust Me' looks terribly reminiscent of
the Oracle doc, doesn't it.
SF (almost
Make a new account with a different username.
They funny like that...I think I have about three of four old OTN
accounts...
Brad
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:24 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Do you have any
Well, at least he didn't marry Lara Croft. That would do him in
faster then Bill Gates.
On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote:
> Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry
> Ellison. This is from an article is today's WSJ print edition page B4.
You should get nightly cold
backups working first as it is the easiest. Then look into setting the database
to do archive logging.
Right now you don't have
any valid backups and if you crash and your DB fails to start you are
potentially screwed.
Also you should do a full
database export R
Jared/Bruce:
Is this still being worked on? I'm not seeing a lot of volume nor
anything I've sent recently.
Stephen
>>> [EMAIL PROTECTED] 01/14/04 07:54AM >>>
Folks,
It seems that a fair number of emails are not
being retransmitted to the list. Some of mine
and a few others have not appeared
Wow, your buffer cache hit ratio for this query is better than
99.99%! With a BCHR like that, how could you possibly tune this
query to be better??
Now, seriously, since I know nothing about your application or
environment, and you do not show execution plan, I can only offer some
general t
To hire a better DBA or enlist the help of the Hotsos Corp.
would be the most appropriate advice I can think of.
On 01/15/2004 09:59:25 AM, "Ehresmann, David" wrote:
> List,
>
> I have to be involved in a conference call this afternoon concerning a
> client. They want advice on how to "tune" th
-Have them run a stress test and monitor on a non-productional system with sufficient
volume of data : CPU, memory, disk utilization. (show newbie as you do this)
-Look at how the database was put together for maintainability - best practices, etc..
-Look at some of the SQL related to their main
Hi ,
I think that their dba should be adviced with following link.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/toc.htm
Rgds.
Arslan.
-Original Message-
Sent: Thursday, January 15, 2004 3:59 PM
To: Multiple recipients of list ORACLE-L
List,
I have to be i
On 01/14/2004 04:49:52 PM, "Jesse, Rich" wrote:
> Expect to pay about the same for PostgreSQL support as you would for Oracle.
15% of the purchase price/year?
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PRO
read the docs. otn.oracle.com
click on search. do a search for hash join.
The docs are very good. read them.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 8:34 AM
> Dear all,
>
> I understand join is for joining
Obviously. The issue has been whether or not Oracle's data caching
worked well - and was read for prime-time in earlier versions.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of RyanSent:
Wednesday, January 14, 2004 5:14 PMTo: Multiple recipi
To do incremental backups of Oracle databases via NetBackup you need to
purchase the Veritas Agent for Oracle, which is an add-on to the NetBackup
client. Veritas charges for this component, per server. You have to hand
over more money to Veritas. This may not be an option at your site.
Without
I am from the old school, doesn't use RMAN, but soon will w/ our 9i
upgrades. I recommend to use RMAN if you are starting out and buy this
book.
http://www.bookpool.com/.x/dt3bpjmwz1/sm/0072226625
hth,
Gene>>> [EMAIL PROTECTED] 01/15/04 03:14AM
>>>Teresita Castro wrote:> > Hi!!> My
nam
Ideally you should filter current sid/serial# ... else you'll get error .. no?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, h
hi
you write query in order of largest,larger,large table fashion
and input parameter column may be indexed
tlw
hernawan wrote:
> Hi all,
>
> I have process in Oracle apps 11.5.8 which need
> very lot CPUs and long time to complete.
> for about 17,000 invoices it takes 28 hours !!
>
> I have
that's what I get for not testing but just reading the manual :)
remind me not to answer questions when I don't have a database
handy.
sounds like Dan's going to have to add a column.
--- Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote:
> Rahcel, Dan:
>
> I played with such things a long ti
jwiegand wrote:
Good Day.
Has anyone succeeded in this and care to share? I've tried sharing out
the directory containing the Oracle backup, tried setting the Oracle
services to run under a Windows domain user, but continue to get
failures.
Hello,
Oracle on Windows don't support network drives.
Teresita Castro wrote:
Hi!!
My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle
just to make queries, funtions some updates and create indexes or
tables, that all.
Now I am in a little difficult situation, here we have a DBA that do not
have much experience. He has been wor
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC - OU
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 15, 2004 4:04 AM
Hi,
I've been asked by management to explore the pros and cons of Mysql vs Oracle. The
database in question will be a web
based text and multimedia retrieval sy
The only way I see is using a system-maintained ( through a before-insert
and if necessary before-update trigger ) field that is set to
to_char(,'mm') and then range partition on that.
At 03:24 PM 1/14/2004, you wrote:
Pardon if this is a duplicate, but the original has not shown up
on the list
Dan,
Good question, but unless I'm misinterpreting the results, the answer is
no...
SQL> show release
release 902000100
SQL> create table test
2 (a date, b number, c number)
3 partition by list (to_char(a, 'MON'))
4 (partition pJAN values ('JAN')),
5 (parti
Teresita,
What your
DBA is talking about is Oracle's RMAN backup utility. There us an
interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian
for the backups. The first thing I'd suggest is finding out what version
of Oracle your using. There are significant
OK, Teresita, what is your question? Do you have MLM? Did you put the database in the
backup
mode? Did you save archives? How about the control files? Did you backup control
files? I doubt that
this forum is an appropriate place for a backup & recovery course, but it seems that
you have a good
create procedure kill_your_session (in_sid in sys.v_$session.sid%type,
in_serial# in sys.v_$session.serial#%type)
as
row_count pls_integer ;
begin
select count (*)
into row_count
from v$session
where username = user and sid = in_sid and serial#
First time I've seen this post. And from the fine Data Warehousing
manual:
here's an example of range partitioning. Note the "to_date" in the
values clause. I don't see why you couldn't use
to_date(date_column,'MONTH')
Rachel
CREATE TABLE sales
(s_productid NUMBER,
s_saledate DATE,
s
an.com.au> cc:
Sent by: Subject: Re: Application Server
Caching
[EMA
[EMAIL PROTECTED]
> Cc: Kaing, Leng
> Subject: Re: read-only simple snapshot/materialised view refresh
> Importance: High
>
>
> Leng,
>
> You didn't mention the frequency of the refresh.
>
> I also don't see mention of wh
One more thing which you can tell your boss: MySQL
and Oracle are not comparable, at least not with any trustworthy results. (the
same goes with MySQL and DB2 or Access and SQL server...)
Tanel.
- Original Message -
From:
Mujeeb Chowdhry
To: Multiple recipients of list
Ryan,
Our application does a certain amount of application server caching, and
infact has a pretty advanced cache mechanism to deal with out of date
objects, etc.
On a more simple level - Common reference records are loaded at start up
and cached, error messages are cached, etc. In a similar
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Ryan
> Sent: Thursday, 15 January 2004 09:05
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle vs Mysql
>
>
> i thought postgre was a for profit company? how d
There is a commercial arm of PostgreSQL (or at least a partner) for
businesses that require support. Surf on over to:
http://www.pgsql.com
Expect to pay about the same for PostgreSQL support as you would for Oracle.
I don't know of any support for DBI other than the Perl DBI mailing list
(which
i thought postgre was a for profit company? how do they generate revenues?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 4:19 PM
> 1) DBI is a perl module to handle the communication with various
databases.
> 2) Postg
Ryan,
He has a point. If you look at 9IAS's architecture
there is a cache database at the apps server. The trick is to know when
the data your looking for in cache is no longer valid. A certain
children's apparel/toys site did that to me back in October. I'm still
torqued at them.
I'm suspicious about using MySQL or Postgres with a database 100 gigabytes
in size.
(Especially, when their main website appeared to be down when I wanted to
check some of their recent references).
Anyway, if you have availability requirements which don't allow you to take
down your system for bac
; To: Multiple recipients of list ORACLE-L
>
>
> Rick,
>
> I forgot about shared_pool_reserved_size and the min_alloc parameter
(hidden
> since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John
I don't think MySQL is free for commercial application, for dev and test
purpose it is free.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 14, 2004 4:29 PM
> DBI is an extension to perl language which can then be used by per
parameter
(hidden
> since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John Kanagaraj [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 13, 2004 2:59 PM
> >To: Multiple recipients of list ORAC
DBI is an extension to perl language which can then be used by perl to talk with
various databases. DBI stands for "database interface". With DBI you also have to
load in a specific database driver which is called DBD. For instance for oracle you
have to install DBI and DBD::Oracle. Its reall
1) DBI is a perl module to handle the communication with various databases.
2) Postgres is free. I believe that you can buy commercial support, but I don't know
where. May be Rich can jump in with that.
3) DBI is free and so is perl. I'm cheap & easy, but not free.
On 01/14/2004 02:34:52 PM, R
146599.1 Diagnosing and Resolving Error ORA-04031.
>
> John
>
> >-Original Message-
> >From: John Kanagaraj [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, January 13, 2004 2:59 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: RE: Shared Pool fragment
what is DBI?
is postgre free? Is it like linux where you pay for support? I cant find any
licensing info on the website. Most shops dont need oracle, sql server,
sybase, or DB2.
Most applications are small. I was on a project where the government had an
Oracle EE license on windows. They didnt ev
I'm going to make Mogens clean my garage ... I'm sorry, I meant further
team building ... when he visits for the Symposium in March!
Gary
(817)424-3443 Office
(817)296-8000 Cell
-Original Message-
Mogens Nørgaard
Sent: Tuesday, January 13, 2004 10:39 PM
To: Multiple recipients of lis
idden
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
>-Original Message-
>From: John Kanagaraj [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, January 13, 2004 2:59 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Shared Pool fragmentation
&
I heard from an Oracle instructor that some idiots were bragging about how
they passed the OCP without logging in once. This distressed some important
people, so this requirement was added. I asked if this meant each instructor
was tasked with ensuring each student logged in, and he just smiled.
Thanks Brad, Thanks Steve, The problem fixed after our DBA drop and
rebuild the primary key. It is so great to have people like you on this
list.
Thanks again,
--
Original Message
Date: Tue, 13 Jan 2004 08:59:24 -0800
>At first stab...I would
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Why does he quit? I thought he likes to
fight...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 14, 2004 1:59
PM
Subject: RE: Sorta OT:
I guess jokes about Preferred Oracle Partners would be in bad taste...
Patrice.
-Original Message-
Sent: January 14, 2004 2:24 PM
To: Multiple recipients of list ORACLE-L
Dang ... he now shares my wedding anniversary (not the year) ...
Raj
-
Interesting, I've actually had to do this before.
Be forewarned that this is not a good method to use for a very busy
app, as it does introduce some level of serialization.
control access to the sequence through a package
Within the package use a function that sets a lock via dbms_lock.request
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Very True ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have
On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:
> If you have the choice, look at PostgreSQL in addition to MySQL. From what
> I've seen, it's more mature than MySQL.
I second that. PostgresSQL supports transactions and uses perl as its
scripting language. From what little I read and saw (just
Title: RE: Sorta OT: Uncle Larry's no longer Chairman!
Raj,
If Uncle Larry's other 3 marriages are any indication of a trend, he won't be sharing your wedding anniversary for long
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
Dang ... he now shares my wedding anniversary (not the year) ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opin
drop sequence
create sequence
but why do you want to do that?
--- Oracle <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a sequence which i want to reset to 0 at midnight everyday.
>
> What is the best way to do this?
>
> Db version - 9.2.0.1.0
> Thanks
>
> Imran
> --
> Please see the official
It comes out of the total memory of the server - separate from the shared pool - it is
allocated per session - if running parallel processes in a DSS environ. can quickly
consume memory avail. be wary wary careful.
-Original Message-
Mladen Gogala
Sent: Wednesday, January 14, 2004 11:54
To use program which will supply numbers, possibly as an external routine,
and not use an oracle sequence as it wasn't designed for that purpose.
On 01/14/2004 12:04:26 PM, Oracle wrote:
> Hi,
>
> I have a sequence which i want to reset to 0 at midnight everyday.
>
> What is the best way to do t
If you have the choice, look at PostgreSQL in addition to MySQL. From what
I've seen, it's more mature than MySQL.
My $.02,
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: W
Leng,
You didn't mention the frequency of the refresh.
I also don't see mention of which database is generating
the ora-1555 errors.
Jared
"Kaing, Leng" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/13/2004 09:34 PM
Please respond to ORACLE-L
To: Multiple r
Yes. Note that when you use MTS, sort area is taken from the SGA,
specifically, from the LARGE_POOL if defined, or from SHARED_POOL, if not.
With a dedicated server, sort area is a part of the process address space.
On 01/14/2004 09:34:26 AM, [EMAIL PROTECTED] wrote:
> Hi all ,
>
> is sort a
701 - 800 of 71998 matches
Mail list logo