In 10i release 1 there'll be around 32 documented (not starting with _) parameters
you can set, I think. In release 2 they're aiming for 22. Those two parameters
you mention sound important enough to make the list :).
Mogens
Jamadagni, Rajendra wrote:
RE: RAC on Linux vs
Title: Which rollback segment is currently active?
Hi,
If you
want to drop one of the the RBS, First you have to check in the application
level. Which user that used the rollback segment.
select
username,name,used_ublk,start_time,sum(waits),sum(gets),sum(waits)*100/sum(gets)from
SUN to Windows ?. Why do you want to used Windows. I think SUN more more
better than Windows.
I suggest please don't used Windows. As you you known the Windows system is
not stable. SUN more more stable than Windows.
I think you have to think more than twice for using Windows.
-Original
Hi,
I am trying to connect to a Non Oracle database from the Oracle database (
Version 8.1.7.4).
i want to do some thing like this :
i have my ODBC set up on an Win NT machine. I have created a heterogeneous
connection set up on Win NT.
Now i want to connect from a Unix machine to the Listener
Title: Which rollback segment is currently active?
Hi
everyone
One of
my development team is working on ORACLE 8 on NT (Because of client requirement
they are working on that version). One Table was created with wrong column name.
Nowthey wanted me to correct the column name. But real
Hello Jai,
Tuesday, February 4, 2003, 4:13:51 AM, you wrote:
Jic Dear friends,
Jic Could someone enlighten me on the steps to be carried out using RMAN
Jic and using OS commands for Recovery if :
Jic 1. A current redo log file is corrupted.
Jic 2. The System TS is corrupted.
Jic Thanks for
Hello List,
I think my question is very simple...
How to execute RMAN command DELETE OBSOLETE from script without confirmation question
to remove obsolete backups
automatically?
Many thanks for your help.
--
Best regards,
Alex mailto:[EMAIL PROTECTED]
Hi All
my machine has been rebuilt, with my outlook file lost, thus I do not have
the mail that describes how to set my account not to receive mail until I
say so. I sent a message to [EMAIL PROTECTED] with content : set nomail
Oracle-L. This came back as an invalid list. Could someone please
Of course it will do full table scans! You're not limiting your join
to any set of values, you are trying to read two whole tables. Because
of the multiblock reads, full table scans and hash join will be more
efficient
then a nested loops plan where one table is read sequentially and the other
Title: Which rollback segment is currently active?
Hi Banarasi
One of my development team is working on ORACLE 8 on NT (Because of
client requirement they are working on that version). One Table was created with
wrong column name. Nowthey wanted me to correct the column name. But
real
Look into the SQL*Plus COPY command.
BanarasiBabu Tippa wrote:
Hi everyone
One of my development team is working on ORACLE 8 on NT (Because of
client requirement they are working on that version). One Table was
created with wrong column name. Now they wanted me to correct the
column
** Welcome to the Oracle-L Mailing List! **
Table Of Contents
-
1) Charter for this mailing list
2) Characteristics of this mailing list
3) How to submit a posting to the list
4) How to unsubscribe from the list
5) Commonly used mailing list server
Alex,
Oracle produce a shell script to do exactly this.
It is called $ORACLE_HOME/rdbms/demo/rman1.sh
HTH
John
-Original Message-
Sent: 05 February 2003 11:49
To: Multiple recipients of list ORACLE-L
Hello List,
I think my question is very simple...
How to execute RMAN command
Can anyone provide any info on deploying forms/reports application on
web using other application servers (specially Weblogic ). servlet or
cgi, any implementation.
i m unable to find a way to create virtual directory to map with cgi
executable file.
TIA
Shuja
--
Please see the official
Try 'set oracle-l nomail'
Jared
On Wednesday 05 February 2003 06:52, Ferenc Mantfeld wrote:
Hi All
my machine has been rebuilt, with my outlook file lost, thus I do not have
the mail that describes how to set my account not to receive mail until I
say so. I sent a message to [EMAIL
Folks
We are looking to present a Talk on :-
Reliability with respect to Oracle 9i DB
How does one even approach this subject ?
What Sub-Topics would this envisage other than the following ?
1) Oracle Architecture of Data Storage
2) Backup Recovery
Do Standby Databases Database
Use:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 9:52 AM
Hi All
my machine has been rebuilt, with my outlook file
Seema,
what do you mean by clustering?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, February 04, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
Hi,
We are looking from migration from Sun box to Windows box.
Is anyone used Windows clustering
I am attempting to RTF google on this, but am not coming up
with much. Does anyone have any suggestions on how to tune/manage
toplink from an Oracle DBA perspective?
Make them stop doesn't seem to be an option, sadly.
So far the problems I've run into are that it doesn't use
bind variables (and
Hi,
I restored the database from cold backup. There seems to be a problem with one of the
datafiles. Since there is no useful data in it, I tried dropping it using...
SQL ALTER DATABASE DATAFILE 'ENTIRE PATH' OFFLINE DROP;
Database altered.
I also deleted the physical file by going to that
Title: Which rollback segment is currently active?
Hi Guys
I'm hoping there is sysadmin in the
list that can help me.
We just received a brand new Itanium Server
to play with
It has 2 U320 disk not striped or
mirrored or anything
Doing test and monitoring them through
glance, is
Title: RE: Full table scan
Venu,
How may records? If it's just a few hundred, a full table scan might be faster.
Throw a RULE hint at it and see what happens then.
What version of Oracle? CBO in 7.3.4 wasn't all that smart.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
Because you can trace DML, not DDL.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 10:59 AM
Hi:
I am trying to understand why sqlplus did not display stats when I run
Title: Partition and primary key
Hi List,
We are using Oracle 8.1.7 (64 bits) with Solaris 8
I have a big table with over 300 millions rows (10 Go),
We have partinionned this table by range of date.
When we try to create a constraint primary key (with dedicated tablespace), we fail each
SET AUTOTRACE only reports on DML (select, update,insert , delete)
statements.
The commands you ran were DDL commands
If you notice at the end you did a count of the plan_table and that reported
statistics
John
-Original Message-
Sent: 05 February 2003 15:59
To: Multiple recipients of
-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L
Folks
We are looking to present a Talk on :-
Reliability with respect to Oracle 9i DB
How does one even approach this subject ?
What Sub-Topics would this envisage other than the
We have had an excellent experience with our Windows2000 clusters. Since moving to a
clustered environment
on our Test, Beta and Production systems over 18 months ago we have had 0 ( Zero )
outages due to
Windows. in fact I have yet to see a BSOD on over 20 database servers since going to
I have this sql query. I am wondering why this query takes so long time, Do I need
more conditions to make it run, or it it just that this query take so long time to
run? Anything wrong with the query?
Please help me with this.
SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0,
it should be set oracle-l NOMAIL
deb
From: Ferenc Mantfeld [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: help set nomail
Date: Wed, 05 Feb 2003 06:52:21 -0800
Hi All
my machine has been rebuilt, with my outlook file lost,
Dave,
I can see how frustrating the new regulations must be for you, and many
others who are accustomed to very lax US regulations regarding foreign
visitors.
I'll be traveling to Italy soon, and I learned that I will have to leave my
passport with any hotel receptionist for a couple of hours
OFCS? If not that, then it's left to a raw FS, correct?
Just trying to get some config possibilities here for an upcoming test
(hopefully)...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
If you want to see if tracing is on:
alter session set events 'immediate trace name events level 1';
(level 2 for process level events, level 4 for system).
You can obviously use the oradebug equivalent, or
the dbms_support package to fire this at another
session.
However - if you can read
Babu - There are two ways I can think of to do this.
1. Write a small PL/SQL procedure.
2. Use the SQL*Plus COPY command.
You will probably use the method that is more familiar to you. Have you used
either PL/SQL or SQL*Plus COPY before?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
What OS? What filesystem?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Wednesday, February 05, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Hi Guys
I'm
NO, you have to do it the otherway around with Heterogenous services. Namely
ODBC on the Unix platform.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 2/5/2003 1:58 AM
Hi,
I am trying to connect to a Non Oracle database from the Oracle
Sunil - I believe your method will allow you to connect from the non-Oracle
DB to Oracle. I don't believe it will allow you to do the opposite, but your
subject line says from Oracle. So I think you will need another method.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
First create the index UNUSABLE - which will
create each index as a single extent at virtually
no cost.
Then for rebuild each partition.
Than add the PK using the index.
(At least, that's what it says in my book ;)
I think you'll find a similar piece of advice in
the PL/SQL packages manual
Folks,
Is there a much better way of writing the following SQL statement, bearing in mind the
performace hits due to the use of functions in the GROUP BY and ORDER BY clauses?
SELECT TO_CHAR(TEST_DATE, 'MON ') XXX, count(*)
FROM TBL_XYZ
WHERE TEST_VAL = DECODE(:P_VALUE, 'BEGIN', 'B', 'END',
When one executes a query, the result set is identified. Fetching the
rows in the result set can be done over a period of time. In what form
does Oracle maintain the result set, and where?
TIA
Paul Baumgartel
__
Do you Yahoo!?
Yahoo! Mail Plus
Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM
Hello List,
I think my question is very simple...
How to execute RMAN command DELETE OBSOLETE from script without
Title: RE: How to dump UGA ??
Jonathan,
Thank you very much ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod
How do you determine the size, in bytes, of a long field?
Please. No tape measure jokes.
Ed
Hi Roland,
Is the query producing right results in the first place?
If there are n tables in the FROM clause, there must be atleast n-1 joins in
the where clause to avoid the Cartesian product (which definitely screws up
performance and rarely produces correct results.)
In the FROM clause of
Hi david,
of course there is something you can do First tell your sysadmin to
stop being so negative !!!
Transfererate is data/time, where time is the sum of three steps
- seek: time to position the heat to the right location
- latency: then r/w head has to wait for the correct sector
-
Title: Hanging query puzzle
We have a query from a 3rd-party tool that seems to either run very quick or crawls to a complete stop.
We can find no patterns to this behavior. The hang can be experienced even when there are no other
processes active in the database. Checking waits, we see a
OK, here's the list of people who said are attending. I am not including the
presenters ;) Anybody else attending ?
Larry G. Elkins
Kirti Deshpande
Rajendra Jamadagni
Charlie Mengler
Ethan Post
Jared are you attending ? It was a maybe couple of weeks back.
Regards,
Denny
--
Please see the
Saying Windows is unstable shows no lack of understanding. It is a fact.
At least a fact for me. I try to keep my Win2000 as stable as possible, but
since the kernel now contains fun things like *video* (not in the original
plans for this New Technology), I must reboot at least once a week or
Maria - Actually, I would think the best time to contact Oracle sales is
when you don't have money. Good sales people can smell money. ;-)
Some software companies are very liberal about providing their product
for development and training purposes. My impression has been that Oracle is
NOT one
Title: RE: HPUX SCSI Performance
HPUX 11i version 1.6 for itanium on vxfs
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HPUX SCSI Performance
What OS? What
Sony,
Don't you mean Database Configuration Assistant? Not only does it create
the database, but configures the listener as required and the registry.
Dick Goulet
Reply Separator
Author: Sony kristanto [EMAIL PROTECTED]
Date: 2/4/2003 7:08 PM
Try
this,
Select
table_name,column_name,data_length,data_type
from
dba_tab_columns
where
owner = ''
and
data_type='LONG' ;
--
Babu
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of
Majid,
1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
create database TESTDB
maxdatafiles 1021
maxinstances 1
maxlogfiles 8
maxlogmembers 4
character set WE8ISO8859P15
datafile
There is no join condition between first two tables (PBK.UNDERLAG,
PBK.VARUKORGEANREL_ULAG) and last four tables (rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L
forgot couple things, add this database to your oratab and added it to
your tnsnames.ora
Joan Hsieh wrote:
Majid,
1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
create database TESTDB
maxdatafiles 1021
Jonathan:
How about calling the DBMS_SYSTEM.READ_EV procedure?
I think this is simpler than going to the UGA dumps..
THe restriction with DBMS_SYSTEM is, you can not get
the event settings of the other sessions. But Dumps
can.
Best Regards,
K Gopalakrishnan
-Original Message-
Title: RE: 9i Reliability means ?
Reliability would have to include Standby, Data Guard, RAC - pros/cons of all and when you might use one versus the other. Also, go to the Freeman book as a start on new options and look through the new features and decide what could lead to more reliable
Maria,
You found the fly in the ointment. Since training is your business then you
end up paying for the software just like the rest of us. Now if your doing
training in-house, for your own company, then things are different.
Dick Goulet
Reply
What version
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had
an open tar on since November - Support has finally called up and said other
people are having the same kind of problem - especially in regards to parallel
processes. I am supposedly getting a test
List,
I have a developer that I want to grant access to change another schema
owner's packages in TOAD. I have granted connect, resource, and roles which
incorporate DML on the tables and execute on the packages. When he goes
into TOAD he can see the package spec but not the package body. How
Title: Message
Man,
what a buzz-kill you are.
-Original Message-From: Ed Bittel
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003
6:53 AMTo: Multiple recipients of list ORACLE-LSubject:
Size of a Long Field
How do you determine the size, in
bytes, of
Title: RE: Oracle License for Training
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Maria - Actually, I would think the best time to contact
Oracle sales is when you don't have money. Good sales people
can smell money. ;-)
Heh.
Some software companies are very liberal
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users
This rman would be the secondary recovery solution (Timefinder is the
first).
Anybody know time frames I might be
Sorry, running 8.1.7.2 on AIX
4.3.3.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 2:09 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Hanging query puzzleWhat version
are you running - I have a similar problem on 9.2.0.2
Roland,
A quick look suggest you have cartesian joins unless rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp all have only one
row.
Iain Nicoll
-Original Message-
Sent: 05 February 2003 14:53
To: Multiple recipients of list ORACLE-L
I have this sql query. I am
Did you ever consider that your (prospective) trainig candidates get the (for testing
purposes freely downloadable) oracle software themselves and install it themselves (or
assisted by you) on a good (linux - one might hope ;-)) box and then you assist them
by getting along with this?
I think
What is the value for WAIT_TIME ? This may not be an IO problem
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I
would suggest running some utility like tusc (HP), truss (Sun), strace (Linux)
and check it from the OS side. Since this is a third party tool, it
Create the new table, and then use the sqlplus 'copy' command,
as it can handle longs.
Jared
On Wednesday 05 February 2003 02:23, BanarasiBabu Tippa wrote:
Hi everyone
One of my development team is working on ORACLE 8 on NT (Because of client
requirement they are working on that version).
Title: another possibility for running Oracle / UNIX at home
A few days ago someone had asked about what options are available for running Oracle (database) on UNIX at home.
I just saw this article:
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html
Installing Oracle 9i on Mac
Title: RE: Hanging query puzzle
Still sitting there, while we try to figure out exactly why it's waiting.
SID Username EVENT WAIT_TIME STATE SECONDS_IN_WAIT
- -- -- --- ---
1 pmon
Ed - Look up the function VSIZE in the documentation.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L
How do you determine the size, in bytes, of a long field?
Markus - That is what I call a creative solution! I'm no lawyer either, but
excellent!
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 05, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L
Did you ever consider that your
Title: RE: How to dump UGA ??
KG,
That's what I am looking for ... which sessions have trace enabled ...?
Developers *forget* to disable tracing in their code when they move it to production ... so I have to investigate ...
Raj
__
Ed,
Perhaps you could use the DBMS_SQL Define_Column_Long and Column_Value_Long
procedures to manipulate the Long?
Converting the Long to a LOB using To_LOB function, then manipulating it
with the DBMS_LOB package might do, too.
Jack C. Applewhite
Database Administrator
Austin Independent
Hi:
I am trying to understand why sqlplus did not display stats when I run
analyze table ... and create index ...?
TIA.
Guang
--
SQL set autotrace on statistics
SQL analyze table gene_upr compute statistics;
Table analyzed.
SQL desc gene_upr;
Name
Paul Baumgartel wrote:
When one executes a query, the result set is identified. Fetching the
rows in the result set can be done over a period of time. In what form
does Oracle maintain the result set, and where?
TIA
Paul Baumgartel
If I understand well your question, I don't think
i was successfull in connecting to a Non oracle database from Oracle on unix
through the Listener on Win NT.
this situation arose b'cos we did not have a ODBC setup on Unix.
So we had to do the ODBC as well as the Heterogeneous services setup on Win
NT. and then try to connect from databse on Unix
Dennis,
Using VSize on a Long results in:
ORA-00997: illegal use of LONG datatype
Just tried in on Trigger_Body in DBA_Triggers. (8.1.7.0.0 on HP-UX).
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL
Not easy. If your LONG is shorter than 32767, then you can, in a PL/SQL
function, fetch it into a VARCHAR2 of this size (allowed in PL/SQL) and
aplly LENGTH() to this VARCHAR2. Assuming the suitable Oracle version, I
think there is somewhere a function to convert LONGs to CLOBs - to which
you can
Did you try tracing it from the OS ? Any error messages in the OS system
log ? Is it always one datafile/mount point ? A while back, I had seen a
similar problem when an array had gone bad. You may want to try using dd to
read and write some files and check the timing.
Regards,
Denny
If I try to connect to a database from server a to server b using sqlplus
and a database link and that database does not exist the connection attempt
seems to hang. Is there a way to set the timeout so it will not hang?
R. Smith
If you are not the intended recipient of this e-mail message, any
What is the exact error message, including text?
It could be failing on the temp segment initially created in
the index tablespace, and not necessarily running out
of sort space.
Jared
NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/2003 06:52 AM
Please
I am attempting to RTF google on this
RTFG?
Yeah, I like it. ;)
Jared
Sarnowski, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/2003 08:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Vivek
To me reliability means won't break. Difficult to get hard data.
You might consider changing the name to availability, which to me
covers not just reliability, but all aspects of my application being
available to my users. Things like dynamic parameters can be very important
because I
This command is used to put a datafile in recovery mode, not for
dropping the datafile. Now you either need to do recovery, or drop the
tablespace completely and re-create it.
Simply put, you cannot drop a datafile.
Suzy
Sesi Odury wrote:
Hi,
I restored the database from cold backup.
OCFS = Oracle Cluster File System. An open source project lead
by Wim Coekaerts from Oracle. There is no such thing as raw FS,
it's just raw (without any file system). And I just learned about
this NBD (Network Block Device) from this list. So that's a third
option.
Richard Ji
-Original
Very cool! I was wondering about this the other day.
See: http://www.oracle.com/start/apple/intro.html?src=1439096Act=5
Developer's release of 9iR2 EE for MAC OS X.
Jared
Jacques Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/2003 11:30 AM
Please respond to ORACLE-L
Does any have a script that shows actual # of used and free blocks in an
extent? I would like to determine the maximum # of contiguous
free blocks within an extent
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Stole right from asktom. Thanks Tom. :)
We do not build the result set anywhere in general.
If you do select * from one_billion_row_table -- we fetch the data from the
table as needed -- the results start coming back IMMEDIATELY not after we've
fetched the last row.
For certain types of
Just a warning for the future - this is no longer true
on all versions of Oracle 9 because the wait_time
column is a copy of the underlying x$ timing
column rounded from microseconds to hundredths.
Hence the wait_time can show a zero when the
actual time is non-zero.
You should depend only on
Hi Listers,
I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2
However unfortunately I do not have access to a 7.3.4 database
Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?
Thanks a lot
Cyril
Dennis,
PL/SQL cannot directly deal with longs 32k.
There *is* a way to do with global temporary tables
and the to_lob() function, but it won't be nearly as
fast as just using 'copy'.
Jared
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/05/2003 06:52 AM
Please respond
Do Standby Databases Database Replication come under the subject
Reliability ?
Yes, this would come under the topic of High Availability
Heres a ppt that might give you some more ideas:
http://www.darc.com/ncoaug/presentations/2001-summer/Bondra.ppt
HTH
Ed
-Original Message-
Dear List,
Life was pretty easy here before they came up with
this euro symbol :-( We had WE8ISO8859P1 (the default
I bevieve) as a char set on all Unix and MS (sorry we
have those as well) DBs accross the board.
That was also the client side char set (part of
NLS_LANG) - most clients here are on
Title: Partition and primary key
You need
tohave 15 to 20gig temp space to do this, assuming you are
equipartitioning the primary key index.
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05,
2003 6:53 AMTo: Multiple
Unfortunately, I am not attending.
Having to choose between IOUG and HOTSOS, I opted for IOUG
as I haven't been since 2000.
I feel fortunate at that, as I know a number of folks that won't
be able to attend any conference this year.
Jared
Denny Koovakattu [EMAIL PROTECTED]
Sent by: [EMAIL
Do you mean something like this:
select max(bytes) from dba_free_space where tablespace_name = 'NAME';
-Original Message-
I would like to determine the maximum # of contiguous
free blocks within an extent
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Windows is cheaper than SUN. Linux is cheaper than Windows.
Quoting Tony Johnson [EMAIL PROTECTED]:
We have had an excellent experience with our Windows2000 clusters.
Since moving to a clustered environment
on our Test, Beta and Production systems over 18 months ago we have
had 0 ( Zero )
Jeremy - I should probably have been more specific. :-) Years ago I worked
for a software vendor. They wanted to port their product to Oracle. They
expected to receive complimentary licenses in order to do this. Most vendors
bend over backwards to have you port to their product. Oracle expected
It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.
You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU. Perhaps truss (or the AIX
equivalent) might show your process
You will only know what your system is capable of
It is very dependant on the disk arrays and no of scsi or fibre channels
you have to support those disks
Also RAID level will be a big contributor
How long does it take to copy say a 500MB file from location to location.
check it out this
1 - 100 of 147 matches
Mail list logo