Hi Friends :
I work at the company that is looking for a Data Center.
The needs is to put a product that run in internet, (E-procurement).
If you know some internet address , please send to me.
Nowadays the product is developed in Java/Oracle/Linux and i think that
others options will be also a
1) Gaja Wrote :-
"Systems that are Hybrid in nature and need to Support large data intensive Transfers
, it is Recommended to Set this to at Least 1 MB (or even 4MB in some Cases) "
Qs Would there be any NEGATIVE Effect on OLTP operations in particular if the Stripe
Width is OVER-Sized ?
NOTE
Stephane, List
Qs If you mean in a LOOP (as a Cursor maybe) the Real Performance would be Visible ?
Qs What are the General Advantages of Using Inline View Queries Over Ordinary Ones ?
Qs Any Limitations ?
Any Links / Docs ?
Thanks
-Original Message-
Sent: Wednesday, May 22, 2002 4:3
Hi,
I would like to ask, if any one on this list had the same experience as I.
We have several desktop Compaq boxes with Windows 2000 installed. I tried to
install Oracle 8i server and the Apache web server on one of them. I used
the modified installer, as mentioned earlier on this list, to avoid
List,
I am trying to tune a SQL query.
Oracle 8163 , Windows NT 6 SP6.
How can I eliminate DIRECT PATH READ wait events.
I have traced a session (10046, level 12) and find a whole lot of waits for
DIRECT PATH READ.
It waits 200 seconds for this event.
WAIT #1: nam='direct path read' ela= 0 p1=1
Cary,
This is greatness.
Jack
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> I have an example for you (Anjo, I hope you won't
> mind). A prospect we
> visited once upon a time had been fighting a
> performance problem with an
> Oracle Payroll program. They "knew" what their
> problem was: very
Hello Holly,
Make sure and pay attention to the clause that allows
you to skip validation. Don't remember it right off
the top, but it will save you beaucoup time if you are
sure about your data.
Jack
--- "Deshpande, Kirti" <[EMAIL PROTECTED]>
wrote:
> It means partitioning a non-partitioned t
I have an example for you (Anjo, I hope you won't mind). A prospect we
visited once upon a time had been fighting a performance problem with an
Oracle Payroll program. They "knew" what their problem was: very
clearly, v$system_event was telling them that their overwhelmingly
dominant system perfor
It means partitioning a non-partitioned table using "exchange partition"
mechanism, and creating non-partitioned table from partitions of a
partitioned table. You can find detail info in the Database Administrator's
Guide.
Regards,
- Kirti
-Original Message-
Sent: Tuesday, May 21, 2002
Ian,
Probably the O7_DICTIONARY_ACCESSIBILITY parameter which is set to FALSE by
default in 9i is causing you problems.
It defaulted to TRUE in prior releases. When set to FALSE, it will not allow
'select any table' to work on SYS owned tables. However, access to tables
owned by other schemas is
Hello Vasu,
You can find much in dba_tab_privs there is information about
procedures, views, tables, synonyms in it.
Wednesday, May 22, 2002, 9:03:22 AM, you wrote:
VR> Hello All,
VR>I am trying to generate a script to grant privileges on the DB
VR> objects by extracting them from system ta
The alter table exchange partition lets you transfer
data from the partition of a partitioned table to a
non partitioned table. It changes the adress in the
data dictionnary, no data is moved, that's why it is
fast.
For example, I'm using it in a system to exchange old
data with new data. The new
Chris,
You could try "exec" but I'm still not sure what your procedure is going to show.
If it has no parameters then it can't "return" a value as such.
Maybe it shows a value on the screen using dbms_output?
If so, I would doubt this will work over JDBC.
What should your procedure do / show?
B
HEBREW flows right to left dear
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> Yeah, that's a common misconception. You actually have
> to prop the book on your forehead since English flows
> to the left and downwards. I have heard that Chinese
> flows from right to left and upwards or somethi
Mladen,
That IS what I do with the documentation CD. But Jack and I were
talking about REAL books here, you know, those things that are made of
paper, have printing on the pages, words, diagrams all that sort of
stuff
Rachel
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> No, no, no and no! Y
The oratab is provided by Oracle Corp.
We created our own oratab file to handle more
parameters.
--- Babu Nagarajan <[EMAIL PROTECTED]> a écrit : >
All
>
> On one of the database servers we have, the oratab
> file has been changed to include a :
> after each entry and that parameter is used t
Dear all,
What's the meaning of "Partition Exchange"?
tia,
Holly
--
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-- Public Internet access / M
I am in the process of moving a small database to Oracle 9.0.1.3. I have installed my
own space management spaces. It measures growth of objects and tablespace usage and
works well in Oracle 8i. The package does not work well with the 9i SYS tables; it
returns "table or view does not exist"
Hello All,
I am trying to generate a script to grant privileges on the DB
objects by extracting them from system tables. I know that the following
system tables can be used to get the system, role privileges, and table
and column access privileges. dba_sys_prives
dba_roll_prives
db
The problem with Statspack is that it internally pre-defines what waits are
"idle" waits and excludes them from the report. Some of this exclusion, as
well as inclusion of other waits, IMO, is rather confusing. I would like to
see SQL*Net related waits reported (in some situations) and waits relat
Joe,
>From an old posting I made about a year ago (& I hope it is still correct):
"
As for Very Large Memory (VLM) support under NT / Windows 2000 I have a copy
of a document posted to this list (paper called "Oracle8i on Windows
NT/2000: Architecture, Scalability, and Tuning Ap
I am new to his books, three chapters in. The first release of the "Data Warehouse
Toolkit" defines a data warehouse much as a data mart is today. Today we think of a
data warehouse as having a highly normalized structure which stores information from
various sources. We build data marts wi
Has anyone patched up to 8.1.7.4 yet???
Anything we should be aware of???
Regards,
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californ
Title: RE: Data Warehouse experts, a simple question for you
Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Doe
Changing the structure of a vendor required file
is never a good idea.
Jared
"Babu Nagarajan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/21/2002 03:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject
There would be an error value at the end of the call, and the next call
would
be a standard write call ( pwrite I think ).
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/21/2002 02:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
You can ignore them.
See: http://www.ixora.com.au/q+a/waits.htm
"Tom Schruefer" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/21/2002 01:32 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:ID
Title: SQL Server to Oracle DB
Even
without this parameter being set the password is encrypted. What the
parameter does is stop the password from being sent in the clear if logging in
with the encrypted password fails. I believe the encryption is a
54-bit variant of DES. It is very rar
Peter & List,
This is probably one of the most misunderstood parts of ps... Take a look at
MetaClunk note 174555.1.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
The manuals for Oracle are here: http://tahiti.oracle.com
The manual for Life is here: http://www.gospelcom.net
Hi Rafiq,
We have been using 35 percent on our warehouse, even
on our fact partitions. Now that I have thought about
it for a while, that seems like a lot given the volume
of data. If a representative sample can be gathered
with 10,000 or 50,000 or 100,000 rows, and our fact
partitions have milli
Thanks Lyuda and Ron for your help!
--- Lyuda Hoska <[EMAIL PROTECTED]> wrote:
> Something like this would work.
> SELECT GREATEST(FIRST_DATE,
> NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE))
> FROM ;
> Just an idea, you can explore it further..
>
> -Original Message-
> Sent: Monda
VIVEK_SHARMA wrote:
>
> Query using Inline View Query an Ordinary one ?
> Which is Better w.r.t. Performance & Why ?
>
> EXAMPLE - Following 2 SAMPLE Queries give the SAME Output .
> But which would be better ?
>
Second is better because it accesses half the number of blocks. In this
order of
Sure,
MAXTRANS=1, insert 2 or more rows
start 2 sessions
update seperate rows
and voila
Anjo.
Walter K wrote:
> Can someone post an example of how to trigger a
> deadlock (ORA-0060) due to ITL shortage? This is for
> informational/fact-finding purposes.
>
> I've created a test table with MAXT
Hi,
Take HANGANALYZE dump, and upload it to iOraHangAnalyzer at
http://www.ubTools.com/products/iorahanganalyzer/iorahanganalyzer.html.
regards...
"Rodrigues, Bryan" wrote:
> One way is to do a system state dump level 10.
>
> It is done either as svrmgrl or as sqlplus with sysdba privileges. Y
Hello,
Please be careful while reading system state dumps. Because, Oracle's system
state dumping function doesn't make consistent read. I mean you can see a
process which waiting for a lock while there is no holding process.
regards...
"Gogala, Mladen" wrote:
> Next time do sqlplus "/ as sysd
Here we are talking about objects other than tables like package, package
body and procedures etc which are pinned through shared pool package.
To start with you can make candidates such objects which are executed around
100 times and are also loaded frequently. This is a continous process to
Ron - Just don't try to import the system objects into your new database.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 21, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
I need a full export of a 7.3.4 database that will be imported
Put this in a batch file
for /f "tokens=2-4 delims=-/ " %%i in ('date/t') do set filedate=%%i%%j%%k
exp / file=exp_%filedate%.dmp
On my machine this gives "YYYMMDD" but it all depends on the date
format setting in the control panel/regional settings. You may also
change the order of i, j, k abov
Jack - I believe that you are on the right track. If you think about it,
political pollsters randomly assess national populations with only a few
thousand samples, and it works pretty good as long as it isn't biased by bad
questions, lying respondents, etc. And you don't have those issues here.
The most of the list memeber agrees on estimate with 30%
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 21 May 2002 13:43:33 -0800
Hi all,
Did some investigation about statistical sampling this
weekend since we are going
Title: RE: host from SQL> prompt
Thanks to all that replied...inserting into PRODUCT_USER_PROFILE does the trick!
-Original Message-
From: Pass Stephanie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: host from SQL
Thanks for reply, I run the query for number of execution bigger than 50 and
find out few tables in the list, my question is if for example one table
executed more than 100 times can we pined the table into memory, so if YES
what about all the DML on this table.
Thanks
-Original Message-
All
On one of the database
servers we have, the
oratab file has been changed to include a : after each entry
and that parameter is used to determine whether the database is supposed to be
shutdown at a certain time.
It kind of struck me as a
odd way to do this... This created problems
Jarred,
Here is a sample what I get from truss..There are no error messages saying
which indicates that AIO calls are falling back to standard IO calls...Is
there any other way of identifying that?
And also thanks for the book suggestion..I was waiting for a newer release
though, but will go wit
I couldn't find any way to do it, so I had to write a Jared...I mean a Perl.
Sorry, I get those two confused...
-Original Message-
Sent: Tuesday, May 21, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L
Hi Everyone,
I can easily append the date to my export file names in unix. Ca
Arrggghhh. Well that was a easy problem to fix, just define 'wait'
differently.
Now on to the next item on my list.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel
> Carmichael
> Sent: Tuesday, May 21, 2002 5:16 PM
> To: Multiple recipients
Michele -
Tru64? Talk about fighting for deck chairs on the Titanic. Great box, given
us really solid service, too bad it never achieved the market share it
deserved.
Yes, there are kernel parameters similar to Sun, but obviously
different. Look in the Oracle Tru64 Installation Guide unde
Whenever more users logon to the database we get Oracle error 'out of
process memory' and the process fails. It indicates that OS could not
allocate memory for the process. For Windows NT Enterprise Edition a
feature 4 GB Memory Tuning is available.
Anyone know anything about it, does it work, et
Or you can use the method posted by Suzy Vordos on 20/4/02
If on 8i you could use a startup trigger for this. Here's mine:
create or replace trigger sys.pin_db_objects
after startup on database
begin
sys.dbms_shared_pool.keep('SYS.DBMSZEXP_SYSPKGGRNT');
sys.dbms_shared_pool.keep('SYS.DB
Hi all,
Did some investigation about statistical sampling this
weekend since we are going to optimize our analyze
process soon, and would like some input from all you
orabrains on this one.
I opened a TAR with Oracle asking about the sampling
algorithm of stats collection, and they assured me it
And these CD's.are you supposed to eat them one
byte at a time?
Thank you, thank you, tip your waiters and waitresses,
I will be here all week!
/jack
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> No, no, no and no! You are supposed to eat your
> documentation CD,
> preferably with fa
Yeah, that's a common misconception. You actually have
to prop the book on your forehead since English flows
to the left and downwards. I have heard that Chinese
flows from right to left and upwards or something
though - you might consider taking it up as a new
language if you are set on the under
That is a wait for parallel query slave to finish processing.
> -Original Message-
> From: Tom Schruefer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 4:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ID This Wait stat
>
>
>
> You know I could have all the docume
I second Jared's opinion. Ralph's books are clear and easy to read. This is
the fundamentals of data warehousing.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 21, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L
Yup, $60, and worth e
I think if you look at the v$session_event view, you
will find that these are idle waits by the various dbw
slave processes.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon
No, no, no and no! You are supposed to eat your documentation CD,
preferably with fajitas or spaghetti and lots of Tabasco sauce.
There are some versions of habanera sauce which can prepare your mouth
to such extent that it becomes impossible to tell oracle documentation CD
and a chicken wing apar
exp / file=exp_%DATE%.dmp
>>> [EMAIL PROTECTED] 05/21/02 04:43PM >>>
Hi Everyone,
I can easily append the date to my export file names in unix. Can anyone
tell me how to do on NT. An example would be great! I've had very little
NT experience. Thanks for any help.
Shirley :-)
--
Please see
Hamid,
Madhu is right. But comination of execution and load will be more practical
.Run following query and see number of executions...
select substr(c.owner,1,5)"OWNER",substr(c.name,1,25)"name",
round(c.sharable_mem / 1024) K,
c.loads,
c.executions,
c.kept
from v$d
> -Original Message-
> From: Ron Thomas [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: patching 8.1.7
>
>
>
> BTW, looks like 8.1.7.4 has been released for most platforms.
> Just downloaded HP-UX and linux
>
Thanks Gopal,
Next time we will keep that in mind. We are upgrading to 9013 soon to fix
memory leakage related to temp LOBs and smon memory leaks, so let's see if
that changes anything.
Cheers
Raj
__
Rajendra Jamadagni MIS, ESPN In
Next time do sqlplus "/ as sysdba", then "oradebug setmypid", then
"oradebug dump systemstate 10" and then "oradebug tracefile_name" to find
out the name of the generated trace file. That is good enough for oracle.
If your platform is 64 bit HP-UX 11.0, then you need an OS patch. Included
is the
Looking at the output from the ps command on AIX I see
that each of the Oracle background processes, user processes
and the lgwr, dbw0, pmon, reco, ckpt ... is listed as using
about 30 mb of memory (based on the SZ column.
1. Does this value represent both data and code?
2. Is there any way to
Do you have archive logging turned on?
Yes: Is your log_archive_dest full?
Is the directory for your online redo logs full?
-Original Message-
Sent: Tuesday, May 21, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L
Last Friday, our 9012 database froze, I mean the only way w
according to the docs and a friend in COE, slave wait is an "idle
event" -- it means that the dbwr slave is waiting for something to do
in other words, it ain't busy... not a "real" wait
--- Tom Schruefer <[EMAIL PROTECTED]> wrote:
>
> You know I could have all the documentation for Oracle pri
SET PCTFREE=0 and fill the rows in that data block.
Then update two DIFFERENT rows in that block
from DIFFERENT sessions.
You will get the required deadlock !!
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Tuesday, May 21, 2002 1:14 PM
To: Multiple recipie
Kevin,
No it wasn't a problem with log_archive_dest or on-line redo logs, these
locations have more than enough space allocated. As for redo, we weren't
generating much, I mean there were only 2 baseball games going on at that
time. We have managed 7 concurrent games and the DB doesn't even show
Hi Everyone,
I can easily append the date to my export file names in unix. Can anyone
tell me how to do on NT. An example would be great! I've had very little
NT experience. Thanks for any help.
Shirley :-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Taylor, Sh
Hi all,
I am new to the Tru64 flavor of Unix and would like to find out if there are kernal
parameters that need to be set for Oracle (similar to the shm parameters on SUN)?
Also, I would like to know if there are any other differences in terms of an Oracle
installation on Tru64.
TIA,
Miche
Thanks!
-Original Message-
Sent: Tuesday, May 21, 2002 3:27 PM
To: Multiple recipients of list ORACLE-L
Ron,
I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3.
I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints
about different versions.
One way is to do a system state dump level 10.
It is done either as svrmgrl or as sqlplus with sysdba privileges. You would
use the command "alter sesssion set events 'immediate trace name systemstate
level 10';" (if you do not have a large user dump file capacity you can
alter your session to in
You don't need this article if in 8.1.6.
Java installations and upgrades became a lot more complicated as of 8.1.7.
Jay Miller
-Original Message-
Sent: Tuesday, May 21, 2002 11:53 AM
To: Multiple recipients of list ORACLE-L
I don't have an account with metalink, and I can't get to th
Product profile has worked to stop this and others since version 6. It is
very easy to create the table and add a row to disable certain types of
commands. Don't you just love nosey users :)
-Original Message-
Sent: Tuesday, May 21, 2002 12:12 PM
To: Multiple recipients of list ORACLE
Ron,
I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3.
I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints
about different versions.
Mark Stahlke
DuhBA
Denver Newspaper Agency
-Original Message-
From: Smith, Ron L. [SMTP:
Raj:
You can dump the SYSTEMSTATE/PROCESSSTATE using ORADEBUG dump and analyze
the trace files.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Rajendra
Sent: Tuesday, May 21, 2002 1:00 PM
To: Multiple recipients of list ORACLE-L
Last Friday, our 9012 database fr
gee, and here I thought all I had to do was put the book under my
pillow and let the words seep in through osmosis :)
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> I find that if I wrap my books in Saran Wrap, I can
> read in the shower. And if you prop the book up on
> your shoulder, you can rea
I ran 'statscre' again and got the same message again. It seemed to prevent
SQL*Plus from logging into any account. So, I quit, re-started SQL*Plus and
logged in as Perfstat and ran the remaining two scripts, which then
completed without incident.
I have been able to take a couple snapshots wi
You know I could have all the documentation for Oracle printed on my brain,
buy all the books ever written about the subject, but the primary wait
problem that comes up will never be directly addressed.
So, what exactly does 'Slave Wait' mean and what can I do about it?
I am using DBWR Slaves,
> Richard Huntley wrote:
>
> How can I prevent users from typing "host" to get to an OS prompt
> while logged
> into a DB account with an OS account? They can host to a prompt now,
> but they
> can't do anything useful from there, since $ORACLE_HOME is the only
> thing in their
> PATH...just won
I must agree with Jared on this practice. By following this practice, you
never bounce database to just get rid of hanging sessions holding locks as
some listers are complaining about that they had to bounce database to get
rid of hanging sessions becuase they killed process on database level f
Hamid,
what happens , if an object is getting executed once in a while but takes
huge sharable memory, we may not be getting full use of pinning it in the
shared pool, except wasting the memory, So we need to consider the number of
executions also. if the number of executions are high for any obje
> "Burton, Laura L." wrote:
>
> Is there a way to access 'something' that would denote if any rows
> were updated?
>
> Feedback lets you set up how many rows will be effected before a count
> is returned, but WHERE is this number coming from?
>
> I have found a 'Returning' clause of the update
Cherie,
The majority of the documentation is available for download at
http://docs.oracle.com
click on database and then the version and OS you want.
Ron
ROR mô¿ôm
>>> [EMAIL PROTECTED] 05/21/02 02:39PM >>>
I've dumped the Solaris one to:
http://www.westbend.net/~legoman/readme_solaris_8173.ht
BTW, looks like 8.1.7.4 has been released for most platforms. Just downloaded HP-UX
and linux
today.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."
--William Butler
Yeats.
Can someone post an example of how to trigger a
deadlock (ORA-0060) due to ITL shortage? This is for
informational/fact-finding purposes.
I've created a test table with MAXTRANS=1 and can
cause the enqueue waits between two sessions
contending for the same block but I can't seem to
cause a d
I find that if I wrap my books in Saran Wrap, I can
read in the shower. And if you prop the book up on
your shoulder, you can read it backwards in the
rearview mirror during drive time. Also, if you learn
to read in your sleep, you can get LOADS of stuff
done.
;)
hth,
/jack silvey
--- Rachel
You be right!!
Dick Goulet
Reply Separator
Author: "Karniotis; Stephen" <[EMAIL PROTECTED]>
Date: 5/21/2002 11:22 AM
Is Dynix still supported by Oracle? I thought they cancelled support for
that OS.
Thank You
Stephen P. Karniotis
Product Architec
I need a full export of a 7.3.4 database that will be imported into a 8.1.7
database. I know there are several ways to do this.
I would like to import as much as I can, (grants, users, etc...) in one pass
if I can. Will an import full ignore=y work or will
it complain about the different version
I second that emotion. the guy that wrote it is a PhD
and owns Red Brick or something. totally knows what he
is talking about. One of my top five books, best
warehousing book by far I have ever read.
/jack silvey
--- [EMAIL PROTECTED] wrote:
> Yup, $60, and worth every penny.
>
> It may be 4 ye
Last Friday, our 9012 database froze, I mean the only way we could get in
was through sqlplus, no other tool would connect. We needed to bring the
other side up as soon as possible so didn't spend any time running any
queries to see what was the problem. The other side (of the cluster)
wouldn't co
How does one monitor oracle license, is v$license the only option? Is this
useful in case of processor based license?
Thanks
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
it's cheaper on bookpool :)
especially when Borders is out of stock
you guys are killing my credit card! I went out and bought Inmon's
Building the Data Warehouse, BOTH Kimball books and and considering the
Webhouse one as well geez, when do I have time to READ this stuff?
Rachel
--- [EMA
Hi List,
I have run some scripts for Tune up shared pool,here is the result of one
script which i run :
Script:
SELECT name,sharable_mem
FROM v$db_object_cache
WHERE sharable_mem > 1
AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR
TYPE = 'FUNCTION' OR
TYPE = 'PROCEDURE')
AND KEPT = 'NO'
ORDE
>Go ahead an post an informative example of
> how the v$ views don't allow you to diagnose a specific problem,
> and how Precise products do.
> We wanna know, and I don't imagine he'll mind.
Indeed I won't mind. Go ahead, tell us. :)
Jared
Greg Moore <[EMAIL PROTECTED]>
Sent by: [EMAI
Stephane Faroult wrote:
Killing Oracle server processes is definitely bad manners. Especially
if you are using MTS. Even if you are not, the proper way to kill an
Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you
should use the DBMS_APPLICATION_INFO package to set somethi
Yup, $60, and worth every penny.
It may be 4 years old, but the information is still pertinent.
Jared
Joe Testa <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
c
Most of us on the list would probably recommend that you patch
to 8.1.7.2.x, though you probably should check the patch readmes
on MetaLink and check for RMAN bugs.
Jared
"Ruth Gramolini" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/21/2002 05:48 AM
Please respond to ORACLE-L
Silly question maybe, but have you verified that those kaio call are
succeeding?
Their mere appearance in the truss output only verifies async is being
attempted.
If the kaio calls fail, they fall back on standard io calls.
Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, y
Is Dynix still supported by Oracle? I thought they cancelled support for
that OS.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Tuesday
But why would you want to?
If you export using the 7.3.3 database using the 7.3.3 export utility you
should be able to import it into your 8.1.7 database using the 8.1.7 import
utility. It's backward compatible.
You just can't go the other way (import an 8.1.7 export to 7.3.3).
Jay Miller
Hi List ,
at some point of time in our production
database number of bequeth processes becomes very high and tomcat
(application) stops responsing . After bouncing tomcat this becomes okay
.Can somebody hint what are these bequeths and whay they goes so high at some
point of time .
Thanks
1 - 100 of 166 matches
Mail list logo