http://www.linuxnetmag.com/en/issue5/m5xserver1.html
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Read section 2.2 of Note 123718.1.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
Ben Poels [EMAIL PROTECTED] 05/03/2002 06:03 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
you create the db (although I heard that different tablespaces can
have
different Db Block sizes in 9i - correct anybody?)
yep I've even tested it :)
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
Seema,
You got it backwards.
If Db Block Size is 8k, and you create a table with
Robert,
I guess you are looking in 'itc' in block dumps which shows the ITL Count.
And yes.. There is an upper bound for number of ITLs based on the block
size.
The transaction slots (and other headers) can not use the more than 50% of
the
space available for data in the data block. Each ITL
sigh...
someone shoot me. I am spending WAY too much time being unemployed
these days.
extents are made up of blocks.
now I'll shut up before I embarrass myself anymore :)
Rachel
--- [EMAIL PROTECTED] wrote:
and I was off as well, if your extent size is less than the
blocksize
no reason. I can see creating multiple files under those conditions
only because you want to keep files to a specific size.
Now, I did once find that the rollback datafiles were a bottleneck on a
system I had. So we built TWO rollback tablespaces, with datafiles on
different mount points etc and
We use Oracle Names big time.
Our approach is to keep using it until it *really* does not come on the
Install CD.
It will be a mistake to get rid of something that has now stabilized very
well.
- Kirti
-Original Message-
Sent: Monday, March 04, 2002 4:29 PM
To: Multiple recipients of
That being said is there anything wrong with having one 4G data
file for a tablespace. I personally cannot think of any. There
were the days when 2G was the limit but that sure isn't the case
anymore.
The only thing I can think of is for backups. However, I am always
going to backup on at
Other than I/O load balancing.. I can't see any other reason.
But again, why those tiny 50MB files?
Are these on the same disk? I hope not..
If there is no I/O bottleneck issues, I would build just one 700MB file.
And then monitor how it works out..
- Kirti
-Original Message-
Dear all,
I want to prepare my self for oracle 9i upgrade exam . Much appreciated If anyone can
tell me any sites or books for the preparation of this exam,
Regards
Chuan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chuan Zhang
INET: [EMAIL PROTECTED]
Fat
In a UNIX system it is better to have more small size datafiles than a few
or one large datafile: The reason is that UNIX aquires an exclusive file
write lock and therefore if you use multiple files you will avoid a
situation where multiple simultaneous writes to data files become
serialized and
Hi All,
Following is my observation on UNIX Server. Except for this CLIENT
Connections and individual connections from around the world and servers
work without any problems.
Just to add.. With Names Server life and management is easy...
-
This test was performed with
Try this site
http://www.oracle-base.com/Articles/9i/Articles9i.asp
-Original Message-
Sent: Tuesday, March 05, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle 9i upgrade exam.
Dear all,
I want to prepare my self for oracle 9i upgrade exam . Much
Rajesh,
Other than the Transaction ID,UBA and Commit SCN (or csc.. Cleanout System
Change)
there is something called 'lock byte' in the ITL entry. THis gives the
details
about the locked (!!) rows. I have dumped few blocks and have an half
written note
with me which explains the lock byte and
If it were a data or an index tablespace, laying out a tablespace across
multiple datafiles could help in striping data or partitioning. And as
Kirti said, could be to balance the I/O across multiple disks.
Raj
And yeah!!! Restore. Imagine the loss on one datafile of 700 Mb, and one of
50Mb.
Raj
Rajesh Rao
Hi,
I have also an other question.
Do you you why they did not test postgressql ?
Regards
Henrik
--
---
E-mail :[EMAIL PROTECTED]
On Thu, 28 Feb 2002, Jesse, Rich wrote:
-!-Anybody happen to see the cover story on
Hi,
Works fine for us on Solaris 8 Oracle 8.1.7
20 Dbs in the Nameserver.
Regards
Henrik E.
--
On Mon, 4 Mar 2002, Yahoo wrote:
-!-Hi ALL:
-!-Is any one using names server out there? How the it works? Any
-!-infor are wellcome.
-!-
--
Please see the official ORACLE-L FAQ:
Well. you could look at Note 134284.1 on MetaLink.
I've never tried iAS with anything other than Oracle's Apache distribution
so I can't say if this document suffices.
[You could also look at Note 132466.1 on the Oracle Plug-In for IIS to
run Oracle PLSQL applications through IIS. Again,
We have a small problem.
Oracle has been installed on Windows Advanced Server.
Other software on the system include Microsoft Cluster Server.
Oracle software has been installed on the local drive (E:) using silent
installation.
Database has been installed on Shared Disk (RAID) (D:) using
101 - 120 of 120 matches
Mail list logo