Hi DBA gurus,
One of the application is going live .At presenr data is 15GB and will
grow more by 10 GB in year time. What is the right approach of
tablespace design having more files of smaller size(10 files of 2 GB )
or less file of bigger size (3 files of 8 gb ).
No tables in this
One of the most important rules - to use difficult/criptic passwords. That's
true for any system. Simple passwords - 90% of succesful attaks. You can set
up you own procedure to check quality of passwords in Oracle.
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L
hi, list friends:
I have a oracle 8.1.7.4 database in redhat linux 7.2,which is used to support
a development datawarehouse project.Now i hit some strange error message about date
format through dblink
The error only appear in oracle warehouse builder, it cannot be reproduced in
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
Hi
Tim Wrote
Buying an NVRAM unit would probably be more sensible, since
at least then you have some probability of the file-system
on such a unit surviving node failure or restart.
Qs Such Units are available on which machines , Operating Systems ?
Any Model Numbers , Links , Other Info
Alexandre Gorbatchev,
As far as i know, you cannot recover from drop using logmnr.It is internal dml to
data dictionary, maybe in 9i it will work, i am not sure.But in 8i, it won't work.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
===
Dear Gurus,
Could you please help me out with this - I want to increase the maxextents of below segment.
TIA,
SQL select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS 2 from dba_segments 3 where ((max_extents-extents)/max_extents)*100 40 and max_extents != 0 4 /
OWNER SEGMENT_NAME
I don't wantto sound too obvious but isn't the
answer in the error message ?? .
RTFMtime.
As an aside, why do you need to extend your system
rollback segment
Lee
-Original Message-From:
Jonny Delmont [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002
10:53To: Multiple recipients of
Do you mind if I ask why? Do you have any other rollback segments in place
other than the SYSTEM one?
In answer to your question though, look at the error message.. You missed
out the word segment.
alter rollback SEGMENT sys.system storage (maxextents 1024);
HTH
Mark
Jonny Delmont wrote:
Dear Gurus,
Could you please help me out with this - I want to increase the
maxextents of below segment.
TIA,
SQL select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS
2 from dba_segments
3 where ((max_extents-extents)/max_extents)*100 40 and
ORA-01902: SEGMENT keyword expected
alter rollback segment sys.system storage (maxextents 1024);
regards,
Mike
-Original Message-
Sent: 28 August 2002 10:53
To: Multiple recipients of list ORACLE-L
Dear Gurus,
Could you please help me out with this - I want to increase the
For 9i:
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/
a90117/logminer.htm#18681
For 8i not sure. Has anyone tried DROP undo in 8i? (8i docs are very poor on
LogMiner)
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Mark,
Thanks, your command doesn't help. To answer your question, Database was setup'd by previous DBA. Still i've never seen this type of segment...
SQL alter rollback SEGMENT sys.system storage (maxextents 1024);alter rollback SEGMENT sys.system storage (maxextents 1024) *ERROR at line
If on 9I, access the db using the new Enterprise Manager Console, go to
schema, pick the user name, and locate the view in the tree.
In the right pane you will see the view's code, and if you press compile the
text will change colour at the point the error occurs. (It may already be
colour
Jonny
The SYSTEM rollback segment is/was created initially on a database build,
and the recommendation has always been to add extra rollback segments
straight away for normal transactional processing. You really *should* have
other rollback segments available for your users.. What output do you
PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL
I've tried to find this in the docs to no avail.
If I'm writing out an RMAN backup to one disk(yes this is not ideal), then
does it make sense to allocate multiple channels?
Are multiple channels related to CPUs or to destinations?
thanks, joe
We will be building an environment (multiple hosts and environments) that
will be used for reporting. And we will be using the Oracle suite of
products (9iAS, iDS). I'm tasked with determining some of the architecture
of the environment. And primarily for the Oracle 9i environment used as a
The message tells you already
Alter rollback segment sys.system etc
i.s.o. Alter rollback sys.system
Jonny Delmont
I've worked on such units in HPUX environments, first in the1996 timeframe
until about 2 years ago. I don't know if it was HP's own product or a
3rd-party, but it was used on HP T-class and K-class servers. Maybe call an
HP rep and ask about it; that'll get a more helpful response from the Sun
Hi,
I would like to know which datatype is best to use for storing text data
of around 50 lines.The data is basically a variable length user
feedback.I am in confusion whether to go for VARCHAR2 or LONG type.
Also in CLOB and NCLOB, can somebody clarify me about CLOBS store
single-byte
First things first. NEVER use a LONG datatype. Oracle says so too but alas
uses it in a lot of data dictionary tables. Long has many limitations.
The data in VARCHAR2 and CLOBs is stored according to the charcter set
defined at the time of database creation. The data in NCLOBs is stored
Raj,
Thanks for your
input.
From what I understand with profiles,
the session will be terminated once a
threshold is reached.
In this particular case, I
cannot
terminate the session. I need to be
able
to control the CPU usage of a session,
without
ending it.
If this cannot be done
Joe,
I have the same situation.
I my case I used 2 channels, and
so around a 25-30% decrease in
thebackup time for a 30gb database.
Once I increased it to 3
channels
the payback was minimal. It also
became very cpu intensive,
so I kept the setting at 2.
- Original Message -
create a rollback tablespace, create new rollback segments IN the
rollback tablespace and take the rollback segment named SYSTEM
offline. Do NOT use it.
Having an active rollback segment in your system tablespace is like
allowing users to create objects there. Especially listen to Stephane
and
Sankar,
Use Varchar2 for storage of character data up to 4000 characters in length.
Never use LONG datatypes.
Use CLOBS for characters data 4000 bytes up to 4Gig in length.
I'm not sure why anyone would use NCLOBS.
Hope this helps
Tom Mercadante
Oracle Certified Professional
Rman channels are like processes, and you can have multiple channels writing
to one disk and reading from one disk in a restore, If your server has the
horsepower, then multiple channels will increase the speed of backups and
restores,
HTH,
Ruth
- Original Message -
To: Multiple
Eric,
For one whenever I do an import I keep a log file. If a view is invalid the
sql to recreate it is in there. Also look in user_views and/or dba_views the
text field will provide the sql. When quering these views it helps to set long
1000 and column text format A70 word. Makes
Joe,
We only write out to tapes, so one channel
equals one tape drive, each extra channel goes and gets another drive. Not too
sure about disks, I guess it depends on I/O bandwith. Two channels will be
faster than one, if the disk can cope with the input from two channels then
maybe it
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
Hi All,
which is the best PL/SQL editor available
as a trial version .
the editor should support Oracle sql,PL/SQL
and may or may not
support debugging.
The tool
Also it helps to use create or replace instead of drop and create. First it's
one statement vs two and second it retains any grants.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 8/27/2002 2:24 PM
Eric
set long 2000
Rachel,
Then why did you not put it that way in the first place? Damn I hate those
$1,000,000,000 words that I don't understand.
Dick Goulet :-)
Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date: 8/27/2002 5:58 PM
accents over
Oracle 8.0.5
AIX 4.3.3
I Have following statement, which takes forever and does lots of physical
reads
**
insert into test_table
SELECT v1.engagement, v1.YEAR, v1.period, MAX (v2.net_fee_earned_ptd)
,
Yep its me answering a question for you for
a change - I was able to bounce your questionoff of Dinis (our RMAN
guru)and he said: ( Yeah I could have pretended that I knew
the answer but I don't think you would have fallen for that!)
Channels are streams. Basically when you
have multiple
we're currently looking into this, too
Our developers like TOAD, but the licensing cost is pretty steep - $700 a
pop for the most pared down version. Quest was willing to offer us a
one-time half-price offer, but for the 50 users we were considering it still
comes out to over $15,000.
PL/SQL
Title: RE: How to notify the password expiration in oracle?
The 8.7.1 SQL*Plus does not handle ORA-28002 warnings when connecting to an
8.1.7 database account that is in the grace period (dba_users.account_status =
'EXPIRED(GRACE)'). It is listed as BUG# 1326865 on MetaLink, with a patchset
Dick,
But I DID put it that way originally... in my initial email. Which was
at the bottom of yours :)
Besides, my goal is to make programmers who speak English actually
learn to use the language EG
Rachel
--- [EMAIL PROTECTED] wrote:
Rachel,
Then why did you not put it that way in
Why didn't you tried TOra?
http://www.globecom.se/tora
I like it very much and I use it together with SciTE (text editor).
JP
On Wednesday 28 August 2002 16:18, you wrote:
we're currently looking into this, too
Our developers like TOAD, but the licensing cost is pretty steep - $700 a
pop
Thanks all for your help.
Jonny
Rachel Carmichael [EMAIL PROTECTED] wrote:
create a rollback tablespace, create new rollback segments IN therollback tablespace and take the rollback segment named "SYSTEM"offline. Do NOT use it. Having an active rollback segment in your system tablespace is
Alexandre - Thanks for posting the link. I read the document. It describes
how to track the DDL statements. Unless I overlooked something, it doesn't
say you can UNDO DDL. I think the reason was explained earlier on this post,
that Oracle doesn't write any redo records. For example, in the case
Zhu - I compliment you on your preparation. You have avoided the normal
pitfall and posted a great deal of information about your issue, which I
hope will allow one of the experts on the list to diagnose your problem.
The query you post is select 1 from dual@dblink. Is this really
the
gee, this is so cool. The authors I used to read in flesh and blood, and
actually giving away a signed copy!
I'm gonna make sure I drop everything and answer the next query Rachel puts.
(And then pray hard its right and I get a copy too!)
With Warm Regards,
Manav.
- Original Message -
Take a look to TORA, I prefer it over Toad and has a free version too.
Ramon
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 9:18 AM
we're currently looking into this, too
Our developers like TOAD, but the licensing
Trying to accomplish it through the OS will
do what you want on rare occasion, but on many other occasions, it will cause performance
problems that will, for all outward appearances, seem to be deadlocks. The
behavior will be random. Theres lots of discussion about this on the
list from a
Which would Perform Better ?
1) Having an SQL Query Doing a Join between 6 Tables
2) Running 1 SQL Query on a Single Table , getting the Output Values in a Cursor
passing the Cursor Values as Arguments to the where Clause of a 2nd SQL Query
Running on a 2nd Table thus so on ... thereby
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
Hi All,
which is
cool - so the freeware version checks the v$session view and counts the
existing number of TOAD programs/modules?
-Original Message-
Sent: Wednesday, August 28, 2002 10:31 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Bill,
You said One note about the Freeware version of TOAD
WOW!!!
Thanks a lot. Someone from Big Blue is not speaking
the truth.
Pete
--- Ji, Richard [EMAIL PROTECTED] wrote:
Peter,
That sounds pretty strange that they only support
thin but not
the OCI driver.
Anyhow, the bottom of this page seems to have OCI on
the support list.
if properly written the first one would be faster because even if you
optimize the second solution, you can NEVER get rid of context switches
between SQL and PLSQL code. There will always be overhead in second
solution.
Raj
__
Rajendra
I would like to schedule the creation of statspack reports with DBMS_JOBs.
The statsrep.sql script does not take any arguments and seems to require
user interaction. Has anyone here tried to automate the creation of these
reports? I am being asked to produce these reports by other people in my
I'm trying to consolidate some numbers generated by a PL/SQL report vs. a
Java based report and these seem to be out due to rounding errors on
negative numbers.
In PL/SQL if I for example, round to 2 decimal places:
SQL select round(-0.875,2) from dual;
ROUND(-0.875,2)
---
DENNIS WILLIAMS,
hi, thanks for your answer. First i appolygize for input so much data in the
mail.
As i said,the query runs well in sql*plus.But in OWB(Oracle WareHouseBuilder,
it just refused to work. As i posted in the trace file:
*** SESSION ID:(8.21) 2002-08-28
VIVEK_SHARMA wrote:
Which would Perform Better ?
1) Having an SQL Query Doing a Join between 6 Tables
2) Running 1 SQL Query on a Single Table , getting the Output Values in a Cursor
passing the Cursor Values as Arguments to the where Clause of a 2nd SQL Query
Running on a 2nd Table
Oracle definitely *does* generate redo and undo for DDL. The reason you
can't roll back a DDL statement is that each DDL statement is actually
a macro for a sequence of DML statements on the data dictionary; that
sequence of DML statements ends in a COMMIT. You cannot roll back a
committed
We get ORA-03120 errors when using Windows SQLPlus 8.0.6
connecting to a 9.2.0.1 Database and querying across a DB-Link to an 8.1.7
database.
Server Database : 9.2.0.1 on Solaris 2.8
Client SQLPlus : 8.0.6 on Windows
Target DB which DB-Link connects to : 8.1.7.2 on Tru64
A Public Database
There is a way of undoing DDL and it is described in the RMAN manual.
The solution is simple: recover the database to the point in time before
the problematic DDL.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:49 AM
To:
If your purpose is to slow down query
execution instead of killing a query (or a process), then you cannot use
resource profiles. Using resource profiles you can only kill a statement
execution or kill a session. An OS resource manager might have a feature that
just slows down a CPU
Stable international company in north Atlanta Georgia area seeks a Sr. Level
Oracle DBA
with people management experience to join its North American headquarters.
The selected candidate will be managing a team of 6 individuals.
Relocation Assistance could be provided for the right candidate.
Beware ... TORA is not free on Windows platform ... it is free however on
Linux ... Funny no once has mentioned Oracle's built-in editor that comes
with Forms ...
My preferences are
1. Vi
2. Vim
Raj
__
Rajendra Jamadagni MIS,
Before taking the system rbs offline, contact tech support. I recall
(perhaps incorrectly...I don't remember whether or not I have tested this)
that the system rbs is used by the kernel for normal operations and by other
transactions if the other rbs are too full. The system rbs should never be
Sure to start a discussion. ;)
http://ask.slashdot.org/askslashdot/02/08/27/2030205.shtml?tid=109
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
It is a known problem; see note 19796.1 on MetaLink
-Original Message-
Sent: Wednesday, August 28, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
We get ORA-03120 errors when using Windows SQLPlus 8.0.6
connecting to a 9.2.0.1 Database and querying across a DB-Link to an 8.1.7
Pawan - The gurus are sleeping in this morning, so you're stuck with the
aspiring guru. According to Oracle's documentation, v$waitstat breaks
buffer waits down by block class. You may be better off starting with
v$system_event and v$session_event and if this shows a lot of buffer busy
waits,
Bruce:
Actually I have seen this. My server installations were at 8.1.7.3 and I
applied the 8.1.7.4 patch to it. The version still says it is 8.1.7.3 and
the package STANDARD is invalid.
This was on AIX 4.3.3. On the Solaris installations, I have not had a
problem. Check out my TAR on
Well, since someone else cares to mention it, I do use Procedure Builder,
Oracle's PL/SQL development tool from Developer and I like it a lot. The latest
version even does syntax highlighting, indentation, and click on the error
I'll show you where it is.
Dick Goulet
Reply
Application Programming Interface ...
http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't
I would think -0.875 would round up therefore -0.87 is my guess.
Rick
Bill Buchan
On Wed, Aug 28, 2002 at 08:52:03AM -0800, Erik Williams wrote:
I would like to schedule the creation of statspack reports with DBMS_JOBs.
The statsrep.sql script does not take any arguments and seems to require
user interaction. Has anyone here tried to automate the creation of these
reports?
Bill,
I haven't tried it with negative numbers but I found round to create
error where commission dollars are concerned. I use the trunc function
to give the results in two decimal places where the extra half cent
makes a difference over the period of time.
total = trunc(sum * %,2)
Select
Ed,
The only way your going to do this is through Oracle Resource Manager.
You'll need an 8.1.x Enterprise database. Then you can setup your resource
plans and groups to manage who gets how much CPU at a time. Any of the
operating level tools out there cannot get down to the level of
Peter - A couple of issues come to mind:
1) So you are saying that connection failover is your prime interest at this
stage? I was thinking database failover when I saw your question.
2) So what is wrong with thin client? At my site we are tending to go with
thin so we don't have to install
Benthicsoftware has a good series of editors.
They are all about US$30 a piece or so.
Not as powerfull as TOAD but if you are just doing PL/SQL Development they
work great.
From: Magaliff, Bill [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
I think, he's talking about Emacs - huge and powerful OS without text editor
:-)))
JP
On Wednesday 28 August 2002 17:43, you wrote:
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list
Vivek - Offhand I'd say it depends. If there are 10 rows in each table,
I'd vote for the 6-table join. If there are 10 billion rows in each table
and you only need one row from each, I'd vote for the individual queries.
Another factor would be how option 2 is accessing the database. If it is in
a
I have read a lot about the term API. I have searched
the web and documentation and cannot find "API" is an abbreviation
for?And, I cannot find a definition of what an API is?If
someone could help me on this I would appreciate it. All the documentation
I have assumes that the reader knows
I'll second that -- I haven't used Benthic's PL/SQL editor very much, but
I use Golden almost religiously as a replacement for SQL*Plus because it
is small and fast and has a tabbed window interface with spreadsheet style
output that works well for me.
--
Philip Douglass
Internet Networking Group
If it appears as though this might perform better than a single query,
then it's probably because the existing query's execution plan is
sub-optimal. Fix it and forget about splitting it up. If you feel
compelled to split it up, then consider that act as an exercise in
learning how to optimize
haven't looked at that in a while, but don't you have to install Developer
to use that? (It's not available standalone, is it?)
-Original Message-
Sent: Wednesday, August 28, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
Well, since someone else cares to mention it, I do use
Johnny,
Sorry to point out the obvious, ;)
but the error message is telling you what to do.
It's ALTER ROLLBACK SEGMENT ...
Jared
Jonny Delmont [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/28/2002 02:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list
Joe -
1) Why do you feel writing RMAN backup to one disk is not ideal? Is it
the one disk, or disk vs. tape?
2) I would watch the I/O while it is running to see how close you are
coming to maxing out your I/O subsystem.
3) I suspect, but haven't investigated, that RMAN defaults are
Pete:
This surprises you?
I know better than that.
Jared
Peter Barnett [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/28/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Fail Over
My guess would be that neither is wrong, but just using different rounding
methods. If you are concerned about both returning different results, you
could add (or subtract, based on sign) .0001 before doing the ROUND.
SELECT ROUND(mynum + SIGN(mynum)*0.0001) FROM DUAL;
Of course, this
wow -
what a great web site! thanks!
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 28,
2002 2:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: What is an API?
Application Programming Interface ...
I am getting this error: ORA-01731
Saying that I can't do it because of circular view, I can't create a view
from another view;
What's the workaround?
Denis Vasconcelos
DBA - Fábrica de Software
Portais Brasil Tecnologia S.A.
( 0 XX 81 3465 - 3211 Ramal 37
* [EMAIL PROTECTED]
- Original
API stands for "Application Programming Interface".
An API is the rules that must be followed in order that the program you are
writing can interface with the program whose API you are writing against. An API
usually means that the developer of the application has given you the developer,
Beyond what the acronym stands for I would add that it's an
interface to the 'guts' of COTS (Commercial Off-The Shelf)
packages. Two examples I have worked with personnally are
1) WinFax API - ships as a set of DLL's that allow you to
interface directly to the WinFax OLE object so that you
Nope ... actually Procedure builder is a deprecated (sp?) product.
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:
What's CPIM?
ltiu
Jamadagni, Rajendra wrote:
Application Programming Interface ...
http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API
http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API
Raj
__
can you please post URL's for these? thanks
-Original Message-
Sent: Wednesday, August 28, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
I'll second that -- I haven't used Benthic's PL/SQL editor very much, but
I use Golden almost religiously as a replacement for SQL*Plus
Well, I will throw our hat in. Compuware has a tool called DevPartner DB
Tuner Debugger that can be used to create, optimize, tune and debug both
SQL PL/SQL. Great tool (yes I do use it quite a bit) for PL/SQL profiling
and debugging of code.
www.compuware.com
Thank You
Stephen P.
API -
Application Programming Interface
An API
is a series of functions that programs can use to make the operating system do
their dirty work. These are nice for functions that many programs may have
to use so the programmers do not have to reinvent the code.
Dave
-Original
hm, it might be that I was thinking of the second rollback segment
you had to create in the system tablespace before you could create any
other tablespaces
remove that might, that sounds more along the lines of what I was
thinking.
sorry for the confusion. I bow to the redo/undo/rollback
Erik - Two thoughts for you.
1) If you are looking at regular collection of STATSPACK statistics, take a
look at Don Burleson's book Oracle High-Performance Tuning with STATSPACK.
He offers many scripts for reporting on selected STATSPACK statistics over
time, rather than just point in time
Thanks much to all of you who let me know what API stands for and how it is
used. Also, thanks to those who sent me the URL for acronyms.
CPIM stands for Certified in Production and Inventory Management by the
American Production and Inventory Control Society. This certification has
been
Application Programming Interface
Regards,
Mike
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: 28 August 2002 18:08To:
Multiple recipients of list ORACLE-LSubject: What is an
API?
I have read a lot about the term API. I have searched
the web
I am an Oracle Certified DBA(in 8 and 8i) with 7 years
hands-on experiences. I am currently looking for an job
in Portland, OR. Anyone can help?
Thanks,
-Lily Zhang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Design tablespaces with more files of smaller size (2Gb is a nice size). Use this
rule unless the number of datafiles in the database will get unmanageable. You
describe a 15Gb database that will grow to 25Gb in a year -- this is not a large
database, stick with 2Gb or smaller datafiles.
FYI-
FWIR, it is no longer required to create a second rollback segment in SYSTEM at
database creation.
This requirement was removed at version 8 (or possibly even 7.3.4).
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy
Has anyone seen this pricing guide yet?
http://www.infoworld.com/articles/hn/xml/02/08/16/020816hnoraguide.xml?0816f
ram
Oracle to publish pricing guide on Aug. 28.url
Description: Binary data
Erik,
I don't automate creation of any reports, but I do automate creation of the
snapshots. I have a script that is set up to take snapshots every hour and delete any
snapshots over 7 days old. That way I always have a week's worth of snapshots taken
every hour. If there is a problem and
1 - 100 of 121 matches
Mail list logo
