Matter of fact, I believe that they are the biggest users
of Trusted Oracle. A product I was forced to deal with when
on a Nato project. I think I contradicted myself in my first
sentence but oh well...
-Original Message-
Sent: Thursday, May 17, 2001 2:16 PM
To: Multiple recipients of
Hi Diego,
I don't know of any way in which using DBMS_PIPE might be related to CI enqueue
waits. However, even if there is something to their suggestion, if your ID
values are 0 and 5 then the CI call you are waiting for is one of the reuse
block range calls.
@ Regards,
@ Steve Adams
@
I have a small datawarehouse that I would like to re-design and re-build.
All the scripts are in place to recreate the
snapshots, tables and associated indexes. But before I delete the existing
one, and create the new one, I need to
retrieve all the users and their associated grants and
Hi Johnson,
I don't believe that tempfiles can be sparse (although I may be wrong) and I am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles until
then. Anyway, can you please post the URL to the
I stand corrected. Obviously there are other countries that don't dismember you for
speaking out.
[EMAIL PROTECTED] 05/17/01 06:10PM
Um, I can critize Canada all I want. Matter of fact, its kind
of a requirement. So your first sentence is wrong. I asked one
of the guys I work with here
Isn't Canada a state in the north of the USA?
grin, duck, and run like hell
|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 6:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: job offer from SAUDI ARABIA
||
||
||
He works with rule based optimizer (cost= in explain plan). Maybe using
choose ad not analyzing. So it does not matter how values distributed -
if index exist rule based optimizer will use it.
Alex Hillman
-Original Message-
Sent: Wednesday, May 16, 2001 6:16 PM
To: Multiple
If you create tablespace like - create temporary tablespace
tablespace_name ... file_name
created file will be sparse.
Alex Hillman
-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L
Hi Johnson,
I don't believe that tempfiles can be
Brian,
Clearly the USA is not perfect, or the end point of social evolution
on this planet (or others). The USA is the outcome of one set of
highly successful (anglo-american) experiments/innovations with
freedom and commerce. American individualism is not particulary
compatible with the other
Hi,
A user has just installed Oracle Clien 8.0.5 on NT 4 machine. She then went to
configure a system DSN in ODBC. She ckicked Od button, highlighted the Oracle ODB
8.0.5 driver and clicked Finish, but then the ODBC 8 Driver setup did not
appear. Anyone experienced this problem? and if so,
I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.
Here is the proof:
$ ls -l temp01.dbf
-rw-rw-r-- 1 oracle dba 209719296 May 17 18:55 temp01.dbf
$ du -k temp01.dbf
40968 temp01.dbf
$ ls -l users01.dbf
reality check.
Consider the poignant implications of the recent anniversary of the
Oklahoma city terrorism.
The simple fact is that a very high percentage of professional women
that have jobs like real estate sales requiring isolated contact with
strangers *are* armed (as you state, many
Luis,
Don't feel bad, this is a valid question.
DROP USER CASCADE is not always the most efficient way to
drop a user, especially a user with a large number of objects.
I've had that command fail a number of times, and had to rerun
it until I decided there must be a better way.
DROP USER
After creating the temp file and shutting down the database, you can use on
Solaris cp temp-file new-file and then
cp new-file temp-file.
After that you can convert it to quick-i/o.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 17, 2001 8:06 PM
To: Multiple recipients of list
Listers,
I might end up on a Data Warehouse and Data Mart project using 8i. I've read
various white papers, Oracle doc's, etc on partitioning capabilities of
8/8i. And I've dinked around on my test machine a bit trying things out. Are
there any books out there that you would recommend for
Hi All,
OK, you're all correct. Tempfiles can be sparse (it seems to be platform
specific). Nevertheless, I'm unclear why Veritas think that is it any more of a
problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file than
otherwise. Presumably Oracle would just raise ORA-7376
Just as a coin has two side, every thing has two sides - I'd say - good and
bad.
What you are is determined by your behaviour
Your behaviour is determinied by your surroundings - be it parents ,
friends or foes.
Similarly, what a nation is determined by its ruler and its neighbours.
So, It
Hi All,
Another correction. That error number has been changed to 7248 since Oracle8. I
think I need a coffee!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 10:01
To: Multiple recipients of
I think that the failure will not be caused by Oracle but by the quick-io
driver itself since it has to have full access to all the physical allocated
blocks and also it depends on how Veritas will communicate back its failure
to Oracle.
Getting rid of the sparse space may be a good idea!
Statistically, handguns bought for protection are more likely to be used
against a family member (intentionally or otherwise) than against any
criminal element.
At 04:05 PM 5/17/01 -0800, you wrote:
reality check.
Consider the poignant implications of the recent anniversary of the
Oklahoma
On Thu, 17 May 2001, Gene Sais wrote:
Only in America, can you rant! Try to criticize China while living
there. I have a friend there, her mail is read before she gets it.
All she can write is general stuff, nothing negative, fearful of her
life. The best thing about America is that you can
Listers,
I asked about this question a while back (9iAS 1.0.2 / Forms 6i Patch 2 /
Apache / connect mode = http / HP-UX 11.0). I thought I would give an update
since a few people showed interested in the subject.
They were seeing the Forms server crash numerous times a day in a test
Steve,
Do you recall doing this about 5 years ago?
I recall doing this same procedure there, but without
benefit of standby database.
Total downtime was less than 2 hours, and we did
it during a slow period. ( probably Saturday night :(
Jared
On Thursday 17 May 2001 13:48, Steve McClure
Doh! I knew there was something else I was forgetting
(shows you how many times I've used it). Thanks Paul
and Rachel and Jared!
-- Anita
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
to carry this forward (hey Paul and Anita!)
you can also look at:
Hei
I'm planning to know some brieft and detail on Data Warehouse and Data
Mart , but I don't know where to start from ? Any site /doc which I can get
the head start from there ??
-Original Message-
Sent: Friday, May 18, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Title: User-define Aggregate Function
Dear Gurus,
Can I build user define aggregate function, like Sum,count,etc..
TIA,
Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
Indonesia
phone : +62 (31) 8708456 ext.113
Steve,
The only files that can be sparse are tempfiles with
8i+ See note 6224.1 ALERT: Sparse Files and Oracle
(don't be fooled by the Oracle6 in the note, it
includes 8i info as well).
HTH,
-- Anita
--- Steve Adams [EMAIL PROTECTED] wrote:
Hi Johnson,
I don't believe that tempfiles can
Title: unhandled user-defined exception
You do a DMBS-OUTPUT the SQLMM , SQLCODE to check
on what might be the coz of error...in you PL/SQL.
-Original Message-From: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May
17, 2001 7:25 PMTo: Multiple
Hi Pablo,
Your shared pool is too big, not too small, and you are parsing too frequently
(probably some literal SQL). Your use of synonyms is an exacerbating factor.
Your reloads are due to the invalidations. They do not indicate that your shared
pool is too small.
Of course, you should worry
101 - 129 of 129 matches
Mail list logo