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 scripts.
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,
Darren,
To check if extents are contiguous query DBA_EXTENTS.
select file_id, block_id, blocks, block_id+blocks-1 from dba_Extents
where segment_name = '&which_table'
and owner='&which_schema'
order by extent_id
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Brow
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: http://w
Hi,
Why using Linux on Sparc ? Solaris is free up to 8 cpus.
Or is the Oracle price different ?
Regards
HEnrik
--
E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501
Sweden
On Mon, 4 Mar 2002, Steven Lembark wrote:
-!-
-!-
-!-> We've got a new database to put together. OLTP,
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 th
And yeah!!! Restore. Imagine the loss on one datafile of 700 Mb, and one of
50Mb.
Raj
Rajesh Rao
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
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 csc
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 appr
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 ORACLE
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 c
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 C
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-
Sen
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 le
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 l
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
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
>
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 wi
> 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
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
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 / Ma
OK, I know we had the debate already but lets have another go at it.
Say you got a tablespace, lets call it RBS and its for rollbacks.
Now, for what reason would you create a 500M file and 4 50M files
for this puppy as opposed to just one file. I just cannot see the reasoning
for this at all. N
I would think 12 to 15 minutes still too high. Damagement would generally
specify
a max of 5 minutes.
Have you found out why it takes 12 to 15 minutes ? Do the File Systems
take so long or
does the Instance Recovery take so long ? Do you have to put a "sleep" in
the startup
scripts [when I s
We have a number of Forms 4.5 environments (against 7.3.4/8.1.6/8.1.7)
where the clients are Unix workstations. Therefore, the Forms they are are
Motif-mode.
We are looking at upgrading to 6i. Has anyone upgraded to 6i Motif
(ie convert, develop and run in Motif) ?
Hemant K Chitale
Principal D
Title: RE: Sun Cluster and VCS failover
Thanks!! Anyone else want to contribute their numbers?
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sun Cluster and VCS failover
Hello Gurus,
As I understand it. In order to provide a read consistent view of the data
while reading a data block, Oracle looks at the SCN in the block header,
and compares it to the snapshot of the SCN taken when the read commenced.
If the Snapshot SCN is less than the SCN in the block header,
Listers,
Some conditions have to be met before a HASH ANTI JOIN can be used (either
by hint or by setting always_anti_join=hash). The ones I have come across
are (1) the column in the NOT IN query must be NOT NULL (or constraining
criteria specified that says NOT NULL for the column, and that's p
I'm still messing with my enqueue waits on an insert. I'm now able to
recreate it on a test database by throwing enough simultaneous inserts
at my table. I was going to make sure which of the tables/indexes was
actually causing the waits by individually raising the INITRANS above
what they would n
I agree with you Jared. On the last job we had TNSNAMES files out to
everyones work station . got to be a pain. Installed Names, created
the right files . bingo, all worked . Very easy.
-Original Message-
Sent: Monday, March 04, 2002 4:29 PM
To: Multiple recipients of list O
Completely removing names from Oracle would be a mistake IMO.
Reason: Name is fairly easy to implement, LDAP is anything but.
Jared
"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 01:38 PM
Please respond to ORACLE-L
To: Multiple recipients of list
> and I was off as well, if your extent size is less than the blocksize
> then you can have more than one extent in a block (divide the block
> size by the extent size and round DOWN)
Huh?
Jared
Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 12:13 PM
Please respon
Hi,
I want to host SSL and non-SSL requests on one physical server
running one 9iAS.
After installing 9iAS the httpd.conf file specifies by default
that it is listening on port . Later on in httpd.conf it
has an SSL directive that says it's listening on port 80 and 443.
Does this mean that
Thanks
tons Kevin, that is the information I was looking for.
Great,
quick response.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent:
Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: replic
I bet if you wowed us with a really good explanation of this new feature
then some readers would be inclined to go check out your book :).
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Tel. (919) 466-
Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.
HTH.
Barb
> --
> From: Nick Wagner[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Monday, March 04, 2002 2:23 PM
> To: Multiple recipients of list
Bunyamin,
OK, some of this may be a little off the wall since I'm at home on a day
off. Can't believe I'm answering the mail on a day off!! But you got to do
something while waiting for the glue to dry!!
Anyway, there are two init parameters that need to be set,
job_queue_interval and
Yes, this one will get a lot of traffic, I'll bet.
I just looked in the 8.1.7 docs (SQL Reference - Storage Clause) and it says
that the minimum INITIAL is 2 DB blocks for non-bitmapped segments, 3 for
bitmapped segments. The minimum for NEXT is 1 DB block.
Unlesss it's a new 9i feature, a DB b
Hi,
I'm working on Oracle 8.1.7.2 , AIX 4.3.3 and haven't got any problems...
had a lot before the patch, but not ORA-600.
I suggest you apply the patch and monitor the instance.
Hope this helps!
Saludos,
Verónica Levin Enríquez.
Compañía Cervecera de Nicaragua.
-Mensaje original-
De:
Hi all,
>From my testing in 8.1.6 and 8.1.7, it appears to me that the ANALYZE
defaults to "FOR ALL COLUMNS SIZE 1". I found this by checking the
DBA_TAB_HISTOGRAMS view before and after an "ANALYZE TABLE bleah COMPUTE
STATISTICS". I then compared those results to a before/after using
DBMS_STAT
Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, so
they have delayed
the removal.
OID (LDAP) is the replacement.
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely
Are the results any different if you say
select * from sonusrpt where subject like '%GENERAL%';
?
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Monday, March 04, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
I am running orac
Looks like you're running into a case-sensitivity issue. Try
select * from sonusrpt where upper(subject) like upper('%general%');
HTH.
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
I am running oracle8i on solaris8. I have a word ( G
select * from sonusrpt where UPPER(subject) like '%GENERAL%';
Rick
"Nguyen,
Case needs to be considered, eg., '%General%' or use of upper/lower
functions.
"Nguyen, David M" wrote:
>
> I am running oracle8i on solaris8. I have a word ( General ) in my column
> named "subject", I try to run SQL using LIKE and % to grep any data having
> the word ( General ) but it displ
Try changing the query to say:
select *
from sonusrpt
where lower(subject) like '%general%'
/
--- "Nguyen, David M" <[EMAIL PROTECTED]> wrote:
> I am running oracle8i on solaris8. I have a word (
> General ) in my column
> named "subject", I try to run SQL using LIKE and %
> to grep any data
David,
If you have General with an upper case G and are looking for general with a lower case
g, you won't return any records. It's that old case sensitive thing.
Try this:
select * from sonusrpt where Upper(subject) like '%GENERAL%';
Jerry Whittle
ACIFICS DBA
NCI Information Systems
Situation: Sun
Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
2 node Sun E6500s w/
8 CPUs
If the primary node
fails, how long does it take before a user is able to connect to the secondary
node, and continue their activity? I'm sure reality, and marketing
times are different... I'm r
I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.
Raj
Rachel
[EMAIL PROTECTED] wrote:
>
>
>in general though, extents are not usually sized as small as the
>database block size
>
should extents be multiples of block size?
--
--
Bill "Shrek" Thater ORACLE DBA
[EMAIL PROTECTED]
-
The search is case sensitive, try something like
select * from sonusrpt where upper(subject) like '%GENERAL%';
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
I am running oracle8i on solaris8. I have a word ( General ) in my column
name
Names
server will be obsolete in 9i, I think.
-Original Message-From: Yahoo
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 11:33
AMTo: Multiple recipients of list ORACLE-LSubject: Names
server
Hi ALL:
Is any one using
names server out there? How the it wo
Think Case .
Is the word actually in lower case ??? Is it upper case G and then lower
case eneral ??
Best way to be sure is
SQL> select * from sonusrpt where upper(subject) like '%GENERAL%';
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of lis
Try,
SQL> select * from sonusrpt where subject like '%GENERAL%';
or
SQL> select * from sonusrpt where lower(subject) like '%general%';
--
Chris J. Guidry P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
> --
Check this note from metalink.
***
Title: Script to compute table size
Disclaimer:
This script is provided for educational purposes only. It is NOT
supported by Oracle Support Services. The script has been
This would be true if and only if you ignored block header space and ignored
free space in blocks.
What do you want to know
The number of blocks under the high water mark?
The total size of extents allocated to the table segment?
The space allocated within those blocks?
The total number of bl
I am running oracle8i on solaris8. I have a word ( General ) in my column
named "subject", I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected. Does someone have
any idea why? Below is my SQL I used.
SQL> select * from sonusrpt where
I usually do
select sum(bytes) from dba_Segments
where segment_name = 'TABLENAME';
HTH
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> How can I know how much space a table occupied?
> Can BLOCKS columns in dba_tables helps?
> Or I have to use dba_extents and dba_segments
> tables?
> Thx
> -Se
nick, you're thinking segments not extents.
and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)
in general though, extents are not usually sized as small as the
database
Seema,
You got it backwards.
If Db Block Size is 8k, and you create a table with it's initial extent of
32k, the you have 4 db blocks making up the extent.
An Extent is composed of one or more Db Blocks. A Db Block is defined when
you create the db (although I heard that different tablespaces
This is what I use. Hope it helps.
spool table_space_usage.log
set pagesize 0
set linesize 80
select substr (segment_name,1,20)
,bytes / 1024 kbytes
,extents
Isn't the minimum extent size something like 5 times the DB_BLOCK_SIZE?
If that's true then maximum .2 extents in DB block.
Or you are looking for this info?
db_block_size Max Extents
-- ---
2K121
4K24
Well, you could open standby DB only for
read only access (8i) whereas in replication, both or
all (more than 2) databases could be up
and open to users all the times.
Each DML causes substantial overhead as
each transaction needs to be propogated and applied
at all the master sites (wherea
Title: RE: EXTENTS?
The Server Concepts manual Chapter on Data Blocks, Extents, and Segments would be a helpful Chapter to read.
-Original Message-
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Why not just Updateable Snapshots?
Updateable Snapshots allow users to query
and update a local replicated data set
even when disconnected from the master
site.
More relevant is the fact that... Updateable Snapshots require fewer
resources than multimaster replication, while still support
I cover this topic and many others in my Oracle9i New Features book :-))
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Ori
Hi
If I have value num_rows and avg_row_len then can I know the size of tables?
Table size(Bytes)=num_rows*avg_row_len
Thx
-seema
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see t
I have
used both.
Replication, like archive log movement , happens whenever you set it up
to happen. That can be anywhere from every minute to once a day to
beyond. It just depends on your needs. In the case of my old job, we
had replication happening at different times for differen
Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema
_
MSN Photos is the easiest way to share and print your photos:
http://pho
Hi ALL:
Is any one using
names server out there? How the it works? Any infor are
wellcome.
None.
The lowest level of granularity of storage in Oracle is a block.
block->extent->segment
Time to hit the books, the Concepts manual in this case.
Jared
"Seema Singh" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/04/02 10:18 AM
Please respond to ORACLE-L
To: Multip
Title: RE: EXTENTS?
I'm going to say 1. I don't think you can have multiple tables in the same DB block.
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: EXTENTS?
Hi
If DB bloc
I just stumbled upon the “Automatic PGA Memory Management” section of
the 9i docs. I’ve never heard of
this before. Does anyone know how
long it’s been around? Anyone
using it found any bugs, concerns, etc.?
Granted, this is intended for *dedicated* server mode, it seems
like a good
-- "Jesse, Rich" <[EMAIL PROTECTED]> on 03/04/02 09:03:28 -0800
> The problem with Linux on Sparc or Alpha is that Oracle doesn't have
> binaries for them. I've requested Alpha binaries, but haven't had any
> response, despite the "1-2 business days" response.
Remember: They're Oracle, you'
you have it backwards... extents don't fit into blocks, blocks fit into
extents
and extent size is dependent on tablespace storage parameters and
objectg storage parameters
--- Seema Singh <[EMAIL PROTECTED]> wrote:
> Hi
> If DB block size is 8k then how many extents in one db block?
> Thanks
>
Eriovaldo,
If you already have a backup script, then you need to test it on the
production machine. The test db you create does not necessarily have to be
the same size as the production db (init.ora params can be smaller). But
what you are testing is that your backup scripts run as expected on
Depends on your extent size
-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema
_
Join
Depends on the size of the extent.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 04, 2002 1:18 PM
Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema
_
Title: RE: EXTENTS?
it´s the other way around... how many db blocks in an extent.
an extent is a number of contiguous data blocks ...
-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 15:19
Para: Multiple recipients of list ORACLE-L
Is
replication faster than a standby database. As I understand it, the standby
database will be receive arch logs at preset intervals. Does replication
have the same functionality and about how much data is sent to the replicated
site.
-Original Message-From: [EMAIL PROTECTED
Yes, thank You.
JP
On Mon 4. March 2002 15:38, you wrote:
> I'm using a Titanium G4 as a workstation, does that count? ;)
>
> I've had marginal luck using products like SQLGrinder (native OSX app,
> uses JDBC for connectivity). Ultimately though, I fell back to using
> Tora X-forwarded back to
I just checked ORACLE OTN site and their has ORACLE Developer 6i Release 2
can download. The CD pack we have is Developer 6i. Can anyone tell me
what is difference between 6i and 6i rel2?
Thanks
_
Get your FREE download of MSN Exp
Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Philadelphia, Pennsylvania company needs an Oracle DBA who also has
Unix Systems Administration experience (solaris preferred).
This is a staff opportunity... No sub-contractors or third parties please.
* DO NOT send your resume unless you have a stable work history.
Candidates whose work his
May be they'll release the source code and distribute it under the GPL
license?
> -Original Message-
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 04, 2002 12:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Linux for Big(ish) Databases
>
>
> The pr
Tom :
I am thinking something like that ..
I have already did the test at another machine ...
It worked right...
but the instance was diferente ...
So, in your opinion i need to create a instance, in the production machine,
with the same parameters of production and apply the test there, righ
1.
It is my understanding that Oracle 7.x has continuous purge
of the propogated deftrans. There is no option of scheduling
periodic purge at specific time. Am I correct?
2.
How to schedule continuous purge of propogated deftrans in
Oracle 8i from command line?
prompt SCHEDULE P
Either need to ftp from the network drive, use samba, or run an ftp server on the
network so you can ftp to it.
-Original Message-
Sent: Monday, March 04, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L
Hi List,
I just want to extent discussion in this thread instead of opening
The problem with Linux on Sparc or Alpha is that Oracle doesn't have
binaries for them. I've requested Alpha binaries, but haven't had any
response, despite the "1-2 business days" response.
GL!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Hi List,
I just want to extent discussion in this thread instead of opening a new
one...
How can we ftp on to a Network drive from unix machine?
We have an issue to automate the ftping of db audit files to a network drive
on monthly basis.
Any help is appreciated.
Thanks,
Surendra
-Origin
Rick, here is how I do it. Contact me if there are any questions.
Make a copy of 'prod' on LAWDB to 'test' on LAWDB from Cold Backup
Introduction
The 'prod' Oracle instance sometimes need to be replicated, on demand, for
testing and/or training purposes. The replication is done using a 'Cold'
If I understand correctly, it sounds like you need a *recursive* self-join.
Depending on the version of your db (certainly in 8i or later) you may be
able to use the CONNECT BY PRIOR syntax to get what you're after.
Have a look at the SQL reference for 'hierarchical queries'. Here's a link
to th
it's doable. You will need to do a number of things before you can open
the database, including recreating the controlfile (to change the sid)
and renaming all the datafiles to new locations (so you don't overwrite
the original database)
The easiest way (but not the shortest time) to do this woul
Take a backup of the controlfile statement by doing a
alter system backup controlfile to trace;
Then use this script to create a new controlfile with the new SID
after u have transferred all the datafiles, redolog files and archive
log files. The first line of the create controlfile script may
> We've got a new database to put together. OLTP, 100-200 users, ~250Gb
> data. We haven't decided on a platform for this yet. Is Intel/Linux
> worth considering for this size of thing?
No reason why not. Might also want to consider linux
on a Sparc or Alpha.
--
Steven Lembark
Hi,
I'm trying to do a join that is best done by a fast full scan of one
index and a lookup in another. Using the rule-based optimizer and
Oracle 8.1.6, I can't get the optimizer to do what I want. Is there a
way? Any enlightenment would be greatly appreciated.
[Yes, we are moving to cost-based,
The
way I see it . the question comes down to whether or not you need two
way replication or just one way. If both databases can update those
tables and you need them synced between the databases then Advanced Replication
would be the route. If all you need are data changes from 1 d
I'm going to take the datafiles from a cold backup and use them for a new
database. However, to do this, I need to change the SID of the new db. I've read
that it's possible, but not how to do it. Is this an easy thing to do, or would
it be better to extract the tables and create the new db that w
you should define the interval
in the snapshot's DDL.
ES. START WITH sysdate NEXT
sysdate + (1/24)/30
- Original Message -
From:
Bunyamin K. Karadeniz
To: Multiple recipients of list ORACLE-L
Sent: Monday, March 04, 2002 1:58
PM
Subject: how are the snapshots refre
In 9i, catrep is now called from catproc, so AR is installed automatically.
At least that's what the "New Features Guide" says. And in the Linux
version, it's true.
HTH! GL! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Internat
1 - 100 of 130 matches
Mail list logo
