Hamid - Are these small tables? Have you considered caching them in memory
using Oracle's KEEP pool? This may not be as pertinent to your immediate
design as your other questions (like IOT), but it does bear on your question
about putting them in a separate tablespace. If you cache them in
Hi
Here in my company we are planning to put together a disaster recovery plan
using RMAN would like to test various recovery scenarios using RMAN.
Couldanyone provide the information on the procedures followed in a
testing like this?
TIA
DCD was invented and implemented for 7.1 of Oracle because of the
strange and wonderful handling of timeout stuff in Unix. Typically, it
can take between 8 and 80 hours for Unix to discover that a session
should be killed since it no longer has a connection to the Oracle
database. The problem
Title: RE: How to calculate user load on the system
Then
you're in luck. I'd recommend starting withOracle Response Time
Analysis from www.orapub.com. Although
it won't give you exactly what you need, it will help you get to the next
step. Once you understand a session's response time
Hi
Currently we
are using Unix scripts to do backups.We keep last 2 days of backups on the disk
and also take the backups on tape daily. We are planning to use RMAN for
backups and would like to maintain the the same policy of 2 days backup on disk
and daily tape backups. Is it possible to
Star query uses it, but was not mentioned in the original post.
The query in the original post also does not look like a star
join to me.
The following is also from MetaLink.
Doing cartesian products is normal expected behavior from the CBO as it
sometimes is cheaper (in CBO terms and also
You asked which of two outcomes will occur if you partiton tables after
development:
1. ...do we have to change the code for accessing diffrent partition...
or
2. ...this will handle by oracle itself.
Of your two proposed outcomes, 1. is the former and 2. is the latter.
Oracle will handle
But in my case if DCD is set up and the browser is closed will the web
server know that the connection has been closed and will it tell Oracle to
kill the session?
TIA
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002
you could turn auditing on on the table and count the number of times
it was selected
--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
Hi,
Oracle 7.3.4 on Unix.
The database has dozens of little lookup tables. I'd like to cache
those
used the most. Is there a way to see how often
Kevin,
You can also use Resource manager to limit the CPU usage on certain user
groups .
It's pretty cool.
HTH
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 1:42 PM
Thanks, Ron, I will try it.
Kevin Wang
-
This error occurs when you are trying recovery on an open database.the
database should be in MOUNT mode for recovery.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 4:25 AM
Hi All,
I'm in the process of
hi, DBAs...
i'm using Win2000 Advance Server,
with Oracle Enterprise Edition 8.1.6.
by using task manager,
i found tat the ORACLE.EXE is using about 58,556K
memory for one db,
which is start manually.
and ORACLE.EXE for anotherdb is only about
10,000K,
which is start automatically when
Hi Shuan,
This has nothing to do with how your service is started and everything to
do with the
value of the initiazation paramaters that are used to start the database.
The simple
answer is that you can get oracle to use less memory by reducing the value
of these
parameters. The most likely
Shuan,
The
oracle.exe process memory usage is dependant on the size of the SGA.
The
difference in the memory used for each of the oracle.exe processes is due to
the different SGA sizes.
Regards
$uhen
hi, DBAs...
i'm using Win2000 Advance Server,
with
May I please have a copy of this paper?
Thanks
-Original Message-
Sent: Wednesday, January 16, 2002 00:38
To: Multiple recipients of list ORACLE-L
Hi,
WAFL is Write Anywhere File Layout...
Its the file lay out used by snapshot supported storege Devices(NetApp
Storege Etc), This is
hi! john...
while i installed the first db, it only consumes
10,000~20,000K memory.
afterthe error occurred(ORA-12638, which solved
now), it becomes memory sucker.
that's why i'm curious about it.
and..i'm learning oracle, so my pc will b quite slow
if oracle consumes too many memory.
and
Hi,
I am not sure... what your exactly plan to
do...
But,
You can configure RMAN to backup on DISK and use
some TAPE MANAGEMENT UTILITY or SYSTEM UTILITY (If it is there) to backup from
your DISK. Also that utility can delete after successful backup from DISK to
TAPE depending on
101 - 117 of 117 matches
Mail list logo