 | | | Oracle List | | HI
Friends I need output as follows
DEPTNO MAX_SAL MAX_NAME MIN_SAL MIN_NAME
-------- ---------- ---------- ---------- ----------
10 5000 KING 2600 MILLER
Hi All
DB 8.1.6 (both source & target)
OS Solaris
While doing export/import the source JAVA CLASS (invalid classes in
source) did not get imported into TARGET. Is this expected behaviour hi all
TABLE/PROCEDURE 4898102 4781103 0.976113400 2810388 2496178 0.888196932
4898102(gets) > 2810388(pins)
do a gets but not to do a pins ?how to explain Rivaldi
I agree with everything Mark said. But to answer your question there is no
equivalent command because TEMP tablespaces are now untouchable by us mere
DBA mortals.
Create a TEMP tablHi
Friends
Can U please explain
role of SQL & PL/SQL in the liberary cache ?
Regards
Srinivas
--
http //www.freelists.org/webpage/oracle-l
I have gathered some statistics on the RMAN performance problem
although it is difficult to catch it because it happens so quickly. The
main wait event seems to be async disk IO. I also ran sHi.
When I was installing Oracle 10g on Solaris 9 sparc I noted some kernel
tunning options are required before installation. I would like to know
what are the parameters that I need to setup We are considering switching from SQL-Backtrack to RMAN. Has anyone else switched from SQL-Backtrack or other backup software? If so what were your reasons for making the switch? What problems did youA useful link appeared today in the DBA Village newsletter.
There are some pocket guides for Oracle Unix and Linux
at solutionbeacon.com that may be useful.
Click on 'Pocket Guides '
--
Anyone here have experience with Oracle Collab Suite?
Best regards
Jonathan Gennick --- Brighten the corner where you are
http //Gennick.com * 906.387.1698 * mailto jonathan@(protected)
JoiSteve - In answer to question #2 Robert Freeman on page 417 of Oracle9i
RMAN Backup & Recovery says "RMAN backups cannot be used to create a logical
Standby database because RMAN cannot quiesce a A couple of DBAs here are installing 10g on AIX and are finding problems
that it has with our current raw partitions. The problem seems to be
related to the initial offset.
So I was wondering if
--
http //www.freelists.org/webpage/oracle-l
I am using an 8.1.7 database as a gateway to do inserts from a 7.3.4
database to a 9.2 database. The reads are fast enough but inserts take
forever. Updates that should run in minutes are taking hoThe large pool size is set to 16777216.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of David Wagoner
Sent Monday September 27These are two files that I develop to install the security 68 patches for
9.2.0.5 on win2000.
The sql file is at the bottom and it is run from the batch file.
The run assume that an oracle databaseHi
What is the minimum privilege to shutdown/startup the Oracle database.
Thanks
--
http //www.freelists.org/webpage/oracle-l
Hi
What all options I have to connect to Oracle Database without giving the
password. What all should I be taking care of if I don 't want to give the
password to shutdown/startup Oracle DatabaseBob
I can 't answer your questions directly but I think Tim Gorman 's book -
Essential Oracle8i Data Warehousing can.
Re your signature
I just struggled today with an error message It took meDoes that mean we should expect another patchset from Oracle within a week?
-)
Patrice
--
http //www.freelists.org/webpage/oracle-l
--
http //www.freelists.org/webpage/oracle-l
Mark
I did that but I don 't see how it guides me to the size of the shared
pool. For example I ran it against a test db and got the following results
PARAMETER VALUE USATo me it looks like in the first paper he says that Oracle 's implemention
is simply wrong.
In the second paper he adds that the there are there are two kinds of
restrictive relational expressiPaul
U dont have to restartthe Box.. U can Change it Dynamically using Alter System.
HTH
Cheers
Ganesh R
On Mon 27 Sep 2004 10 13 55 +0100 Paul Vincent <paul.vincent@(protected) > wroteOn Sun 26 Sep 2004 19 29 41 -0700 Jared Still <jkstill@(protected) > wrote
> On Sun 26 Sep 2004 14 28 33 -0700 Marc Slemko <identd@(protected) > wrote
> >
> > The current business requirements for Hi List
I 'm facing a little problem here. I 'm working on an installation that has an old 8.0.4 database with corrupted blocks. The situation is as follows
Apparently their database got corruptedU cant delete from the registry too.
Try it it wont affect anything else surely.
It wont allow to delete the service But I havent tried by changing
the value. I donno that just a guess. Can For anyone interested I found some useful things
-found parameter engineResponseTimeOut was introduced to timeout long
running or hung reports that will cause the entire report server to hangYour statement that "Listener is started at both server and client sides. "
leads me to believe that you are more confused than you think -)
There is no listener on the client side. Well there Global manufacturing company in the Ann Arbor Michigan area has several
positions available for
Oracle candidates.
This company is converting several platforms to Oracle using Oracle Financial
Glen
its called "scheduled maintenance " and happens when you have a DVD-ROM
full of patchsets to roll out.
Paul
On Fri 24 Sep 2004 15 30 28 -0400 bernas glen <bernas_glen@(protected) > wrot |
|
|
