Hi ,
Do anybody have the oracle application training document for a fresher who
might be knowing oracle and Developer 2000.
If anybody has some material do forward would appreciate for the same .
Regards
Kirtish P. Gaonkar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Hi ,
Do anybody have the Developer 2000 training document for a fresher .
If anybody has some material do forward would appreciate for the same .
Regards
Kirtish P. Gaonkar
Kirtish P. Gaonkar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtish P Gaonkar
INET:
Can you clarify a couple of points for me.
The SDU (session data unit) is presumably the
packet size that the Oracle client and server
want to pass back and forth - which is presumably
the maximum size the one synchronous dialogue unit
will be.
The TDU (transport data unit) is presumably the
But the last time I looked at it, you had
to enable supplemental logging at the
database level if you wanted to use logical
standby. Two side effects -
1) As you said, you need a unique/primary key,
and database supplemental logging copies
such a key into the redo for every change to a row:
but
I concur.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 11:44 PM
Excellent slide show Tanel!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/10/2003
Hi,
This might be a rudimentary question. I'm trying to download patch 3095277
(9.2.0.4) from windows workstation behind a proxy.
Is there any way I can use ftp to download the same rather than using the
standard browser based download which seems to be a but slower?
Regards
Naveen
Take a look at user_tab_columns -
your choice of:
method_opt = 'for columns'
On a quick test on 9.2.0.3 this seems to
leave the columns with null statistics.
(check
select column_name, num_distinct
from user_tab_columns
)
In passing, computing histograms with 75
buckets for all
That won't help, as the cursor would still
be held open in the pl/sql cursor cache -
despite the explicit close.
It's also more efficient to use the implicit
cursor in pl/sql for a single row fetch in
the user's version of Oracle.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The
Title: Message
Tnsnames is used to resolve aliases - we are currently looking at the
global_names parameter
-Original Message-From: Hybart, Clive
[mailto:[EMAIL PROTECTED] Sent: 10 December 2003
15:19To: Multiple recipients of list ORACLE-LSubject:
RE: Dblink
He is talking about Veritas NetBackup which is different from BackupExec.
Anyway, Veritas client just provide output option for RMAN.
It is RMAN that perform the backup, so it can be hot or cold. It depends if
you are serving coffee or mineral water.
Yechiel Adar
Mehish
- Original Message
Hi Jonathan,
Can you please elaborate on this 75 buckets issue.
I had an advice from an oracle consultant to implement analyzing
Like this. BTW column statistics are there but it makes no difference
In plans. I also added optimizer_index_caching=90 and
Optimizer_index_cost_adj=40 both also
Little competition for you all :)
It's a two part question:
What's wrong with the
followingpiece of expert analysis?
Which well know "Oracle Guru"
published this (and continues to display it on his web-page) ?
"Sadly, Oracle9i doesnt allow you to specify the
value for PCTFREE
Are there any TOOLs
for converting Sample Code (like the following) from MSSQL into Oracle?
SAMPLE :-
DECLARE @entity_id
char(32), @branch_id char(9)
DECLARE cur_temp_GEMT
CURSOR FOR select
branch_id,entity_id
from GEMT where other_party_name='' and entity_type='D'
Well, Googling this statement, one can easily find the source of this
statement :-)
Naveen
-Original Message-From: Richard Foote
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003
5:09 PMTo: Multiple recipients of list ORACLE-LSubject:
Little competition
Little
Title: Message
Don
King
SQL create table 2
test_table 3 (c1
number) 4 tablespace 5 asm_test
6 pctfree 20 pctused
30;
-Original Message-From: Richard Foote
[mailto:[EMAIL PROTECTED] Sent: Thursday, December 11,
2003 1:39 PMTo: Multiple recipients of list
try oracle
work bench from Oracle.
HTH
ShivaM
-Original Message-From: VIVEK_SHARMA
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003
5:19 PMTo: Multiple recipients of list ORACLE-LSubject:
Code Conversion from MSSQL into Oracle
Are there any
TOOLs for
Well, I guess it's all about self-tuning, all
this parameter stuff is out of date...
:)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Little competition for you all :)
It's a two part question:
a.. What's wrong with the following piece of expert analysis ?
b..
Life would be worse w/o PCT_FREE.
create table
test_table
(c1 varchar2(1000))
pctfree 20
;
select pct_free from user_tables where table_name='TEST_TABLE'
PCT_FREE
--
20
rw
Little competition for you all :)
It's a two part question:
What's wrong
i meant automatic segment management has fragmentation issues.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little competition
Little competition for you all :)
It's a two part question:
who wrote that?
automatic undo management has fragmentation issues. Niall Litchfield posted a test
case a couple of months ago.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little
"so are they really new versions or just minor
upgrades to the 9i version?"
let's see. Otn is a marketing tool. From a
marketing point of view, what's better - changing the name to make it look like
it's brand-spanking new, or making what is obvious obvious - that they are
simply
hopefully i wont sound like a complete idiot, but what is wrong with wanting to be
able to handle your own pctfree and pctused. Ok oracle handles the next and initial
extent sizes...(which causes fragmentation).
I use transportable tablespaces and in order to increase the time it takes to copy
Duh !!!
It is oracle ...
create or replace public synonym "Application Server 10G" for
"Application Server 9.0.4"
/
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are
Mark,
I just met Elvis behind local Wal-Mart parking lot, we discussed the same topics ...
funny you mention them. Oh ans we did talk about investing in Enron too (got a hot
tip, the stock is going to go up).
Raj
Richard,
Don't know about the "guru", but sorry to hear that David Bowie is sick
with Influenza.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD:
Title: Re: Little competition
I can cut 45 minutes off my load times by shrinking the data file?
And how much overhead gets added to DML statements as blocks madly shift on and off the freelists with each operation? Priorities, priorities, priorities...
If youre using 9i or above, the table
Hi Raj,
David Bowie? Didn't he publish something regarding
'space' management a long time ago? ;-)
I may (as usual) be totally wrong here.
Greetings,
Guido
[EMAIL PROTECTED] 11.12.2003 13.49 Uhr
Richard,
Don't know about the guru, but sorry to hear that David Bowie is sick with Influenza.
Title: Re: Code Conversion from MSSQL into Oracle
10 years ago or so, I wrote a 105 line script for the UNIX sed (a.k.a. stream editor) command to convert Teradata BTEQ scripts into Oracle SQL*Plus. Painful, yet thrilling, and it took only about a day of concentration with the OReilly Awk and
Title: Pipelined functions
Yes, I sent out another message shortly after that 'set arraysize 1' was
the key.
Thanks
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are
No, you are not but I think Richard from down under is a big David Bowie fan !!
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Thursday, December 11, 2003, 6:39:26 AM, Richard Foote ([EMAIL PROTECTED]) wrote:
RF a.. What's wrong with the following piece of expert analysis ?
I don't know what's wrong with this analysis. There's not
much really there. The claim is that it's bad not to be able
to specify PCTFREE, but
On UNIX 8.1.7 global_names = true
On Zos 390 9i global_names = false
Is this causing a mismatch perhaps ?
Regards
Clive
-Original Message-
Sent: 10 December 2003 12:10
To: Multiple recipients of list ORACLE-L
inv
Clive,
during the upgrade has the global_names parameter somehow been
Title: Message
As
stated earlier, service pack 2 for XP will turn the personal firewall back
on.
http://msdn.microsoft.com/security/default.aspx?pull=/library/en-us/dnwxp/html/securityinxpsp2.asp
Patrice.
Title: Re: Little competition
Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause. They are independent of it. That is why the error was thrown, not because PCTFREE is invalid with ASSM...
Essentially, an erroneous interpretation of the error message.
If it was really going
Jonathan,
I've been coming to the same conclusion as you have. In all of my databases
that I have ever worked on, there are only a select set of Oracle params
that are really required. And with space management the way it is, a lot of
the 'create table' params are really not needed for the
Ive been working on 'large' distributed databases lately and its not as high as alot
of arrogant people make it out to be. Its just different. Im not sure tuning a
database with alot of data and fewer transactions like in a datawarehouse necessarily
'harder' than tuning a higher transaction
It might be held in the cursor cache, it may even be
held in session cursors cache but it will not be counted
as an open cursor. My suggestion had diagnostic purpose only.
The problem is, probably, with the tool which explicitly closes
cursors too frequently and insufficiently sized shared pool
We are purchasing a software package from a vendor. The vendor states that the
package includes sufficient Oracle licenses. Since I'm supposed to keep on top of our
licensing costs, I'm trying to make sure that there are no surprises down the road -
such as additional Oracle support fees or
Yup. The new version will not get out until the books are written
and their buddies are ready to start selling grid consulting skills.
On 12/11/2003 07:44:33 AM, Mercadante, Thomas F wrote:
so are they really new versions or just minor upgrades to the 9i version?
let's see. Otn is a
yeah typical burleson carelessness then. anyone can make that mistake, but if your
going to publish you should be more careful.
should have known.
From: Tim Gorman [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 08:34:32 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
1) Pctfree and pctused are not storage parameters.
2) Oracle allows using both of those parameters as shown by
the next example:
SQL select tablespace_name from dba_tablespaces
2 where segment_space_management='AUTO';
TABLESPACE_NAME
--
CWMLITE
DRSYS
EXAMPLE
kinda like how 9ir1 was really 8.2 :)
joe
Mercadante, Thomas F wrote:
so are they really new versions or just minor upgrades to the 9i
version?
let's see. Otn is a marketing tool. From a marketing point of view,
what's better - changing the name to make it look like it's
brand-spanking
I have a wild idea but maybe you can check with the vendor if it can be
done.
1) Create a table that will hold only the other fields.
2) Create a second table that will have the same PK and long raw field.
3) Create a view that will combine them by the PK.
4) Since I am not sure in a view with
#1. these instances are still on 8i. We are supposed to go to 9i, but its not my call
#2. its read only for the users. We do batch loads at night and I did not notice any
slow down in the loads. I run statspack regularly. no problem. Just gotta do an alter
table move periodically when we get
Thursday, December 11, 2003, 8:44:43 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
rcn The biggest thing about working on database in the
rcn multi-TB range is that its a nice buzzword for your
rcn resume. Its not necessarily harder.
This brings back some memories. I remember back when I moved
Thursday, December 11, 2003, 8:34:32 AM, Tim Gorman ([EMAIL PROTECTED]) wrote:
TG Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause. They
TG are independent of it. That is why the error was thrown, not because
TG PCTFREE is invalid with ASSM...
Oh my. I'm so blind! I
Not that he needs it, but I can confirm Jonathan's claim that the
method_opt clause you are using does not collect column statistics:
SQL @delete_table_stats tp1
PL/SQL procedure successfully completed.
SQL @tblstats tp1
I have been thinking of using ipowerweb.
http://www.ipowerweb.com/
Rob Pegram
--- [EMAIL PROTECTED] wrote:
Sorry for the off topic, but I don't have any one
locally to ask this of.
My co-workers that are developers tend to be
somewhat MScentric.
Can anyone recommend a good, inexpensive
Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com).
You could have used wget when the ftp server was there. That is the primary reason
I had to purchase a cable modem connection.
On 12/11/2003 03:54:24 AM, Naveen, Nahata (IE10) wrote:
Hi,
This might be a
Clive,
If the GLOBAL_NAMES parameter is set to true, then you must create the
database link with the same name as the database to which it connects.. Is
that the case?
Mark
-Original Message-
Hybart, Clive
Sent: 11 December 2003 12:24
To: Multiple recipients of list ORACLE-L
inv
On
Yes, I know. That David Bowie stuff comes up every few
weeks / months in several c.d.o. groups.
But what are 'fans'? In my opintion they make wind ;-)
Anyway, I like this competition thread - mostly because
there's nothing but bulls**t coming from me.
Greetings to the list,
Guido
[EMAIL
Try using updates.oracle.com.
-Original Message-
Mladen Gogala
Sent: Thursday, December 11, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L
Nope. Not since oracle killed the ftp server they used (ftp://oracle-ftp.oracle.com).
You could have used wget when the ftp server was there.
Run your test case, and check the contents
of v$open_cursor. Unless my memory has
got it backwards,
the pl/sql cursor cache is counted towards
max_open_cursors, but the cursors that have
been held open by the 'dirty tricks department'
are closed as required if the limit is
Yes. The name must be equal to select name from v$database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:54 PM
Clive,
If the GLOBAL_NAMES parameter is set to true, then you must create the
I managed to emulate Don Burleson's problem:
SQL create table test_table
2 (c1 number)
3 storage (pctfree 20 pctused 30);
storage (pctfree 20 pctused 30)
*
ERROR at line 3:
ORA-02143: invalid STORAGE option
But when I read the error message, and
corrected the error that was
Title: Message
I use
PHP Webhosting for all of the sites I manage.
http://phpwebhosting.com/
Kevin
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:
Wednesday, December 10, 2003 6:40 PMTo: Multiple recipients of list
ORACLE-LSubject: OT: Web
Good points Jonathan,
The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of
the features anyone could want for most environments. After that we've had a
succession of 'nice to have' features.
Don't get me wrong, some environments absolutely demand these new features
and
List...
SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
I use this proc to generate statistics:
create or replace procedure get_statistics as
cursor get_users_list is
select username
from dba_users
where username != 'SYS'
and username != 'SYSTEM';
begin
for i in
Title: Re: SQL Area Reloads
Shared
pool is free all the time.
There
are no DDLs executed, no analyze or no package compiles still there are
SQL AREA reloads.
The
database is on 9i RAC. The reloads are appearing on RAC
instances.
-Original Message-From: Tim Gorman
List...
SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
I use the proc at the bottom to generate statistics.
It seems to work, but if I check statistics with:
select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;
the tables have the
Thursday, December 11, 2003, 8:44:32 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED])
wrote:
HML PS Yes, I'm aware that there will follow a list of post-7.3.4 features that
HML people consider absolutely vital. =)
And therein lies part of the challenge. I'm sure too, that
every product manager
after running the block, do you actually spool the output and run that??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Um...the PL/SQL script at the bottom of your e-mail doesn't
DO anything other than output a line. Do you use this
in a subsequent command file?
Cheers,
Mike
-Original Message-
Sent: Thursday, December 11, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
List...
SunOS 5.8,
Our apps that use Oracle come with an Application license. By the terms
of this license, we get to use that Oracle DB for that app and that app
alone. The DB support comes from the app vendor and not Oracle. Not
feeling particularly comfortable with this arrangement, we purchased
separate
What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
PCTFREE and PCTUSEDare not part of the storage
clause.
SQL create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
OK, fair enough.
Something to consider: the concept of reload probably
also includes the concept of initial/first load. I don't
know whether this is the case for certain, but one way to
check might be to query the number of items in the V$SQLAREA
(i.e. select count(*) from v$sqlarea). After
Steve Perry from this list produced a perl script to read a import file (rows=n) and
produce formatted DDL.
Whilst it is not perfect (as Steve agrees) it does give a good basis of where to start
with processing and transforming a text input stream into a text output stream whilst
making a small
Take their word - in a contract that specify that they are responsible in
case Oracle ask for more money, and then check with Oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:14 PM
We are
Thursday, December 11, 2003, 8:44:25 AM, Mercadante, Thomas F ([EMAIL PROTECTED])
wrote:
MTF And I think a condensed documentation set is a great
MTF idea. I wonder if there is a market for it?
If I just wrote the book? No, I doubt it would sell in
high-enough numbers. The Oracle book market is
Jay,
I would call your local Oracle Sales office and run it by them.
As my old boss used to say - ALWAYS cut the cards.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, December 11, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
We are
The proc generates the 'exec dbms_stats ' statements for all the users. Are yousaving theoutput and running it manually or not.IT would have the same statements that you run one by one. Jose Luis Delgado [EMAIL PROTECTED] wrote:
List...SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).I use the proc at the
Rule of thumb, NEVER trust the third party vendor to have it right. Call YOUR Oracle
sales rep get his/her advice. We've had an application sold to us with Oracle
licenses when the third party vendor was not licensed by Oracle to do so. Mind you
as long as the contract between you and the
put it into a a dbms_output to see what is passed as variables
then wrap it in execute immediate. your doing dynamic pl/sql. i think that will work.
From: anu [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 11:54:35 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:
create table
test_table
(c1 number)
tablespace users
pctfree 20 pctused 30
/
Works for me. ;)
( USERS is ASSM)
Richard Foote [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/11/2003 03:39 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL
oracle literature is really lacking in entry level docs anyway. The concepts document
is way too large to be digestable by someone new to the topic.
What we really need is:
simple SQL book for newbies
simple PL/SQL book for newbies
Architecture book
automatic features
Beginning Oracle
Oooppp...
Sorry... I sent the testing proc... this is the
original...
procedure get_statistics as
cursor get_users_list is
select username
from dba_users
where username != 'SYS' and username != 'SYSTEM';
begin
for i in get_users_list
loop
dbms_stats.gather_schema_stats(ownname=
My bad. IGNORE PREVIOUS.
It should be the same as: select * from global_name.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 5:34 PM
Yes. The name must be equal to select name from v$database.
The /3GB does not work for the simple reason that in W2K
you have 3GB as max address space. At least that what my sysadmin tells me
(after checking with MS).
Yechiel AdarMehish
- Original Message -
From:
Paul
Drake
To: Multiple recipients of list ORACLE-L
Sent:
you need to contact oracle sales to make certain. The obligation is on your company
double check.
i doubt what they are saying is true. please post what you find out.
From: Jay Hostetter [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 09:14:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
Just to thank all who replied ( sure did not expect
that much replied): Taner, Tim, Kevin, Murali,
Jonnathan, Jesse, Michael, DEnnis, Jamadagni, Mladen,
Pete, Thomas, Kenneth. Sorry if I forgot anyone.
Gene
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
Hi all,
Thanks for the pointers that you have all supplied. Sage advice that they
shouldn't have changed Oracle whilst changing their OS at the same time.
I also did some checking up on the /3GB switch before it was mentioned
(having seen it on here in the past) - Windows 2000 does in fact
On Thu, 11 Dec 2003 [EMAIL PROTECTED] wrote:
oracle literature is really lacking in entry level docs anyway. The concepts
document is way too large to be digestable by someone new to the topic.
What we really need is:
simple SQL book for newbies
- O'Reilly's Mastering Oracle SQL?
Guys,
I saved all of your writing including Todd Boxx, Richard Foote, Wolfgang... about
issues with 9.2.0.4. We are currently on 9.2.0.3 and I understand (although have not
hit it yet) that in this version we could get locks when building indexes. Also, that
basically you need to set your
Title: RE: SQL Area Reloads
No, reload does not include initial load.
reload - Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk.
First_loads = pins - pinhits - reloads
Alex.
-Original
Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot
performance issues.
Little back ground about our environment. Its third party application (Logician) from
GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster environment.
All the databases
Ummm ... what was the problem that prompted you guys to replace citrix servers?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have
Folks,
Anyone know if it's possible to pass a package record type as a parameter
to a Java stored procedure?
e.g.,
create or replace package el_zip_pkg
is
type file_rec_type is record (
namevarchar2(255)
, datablob
);
type
Oh yeah? Just this week we had a Windows box that had been up for 29
days straight!!!
Yep. You read it right. I'm not giving out our secrets though.
-Original Message-
Sent: Wednesday, December 10, 2003 10:55 PM
To: Multiple recipients of list ORACLE-L
This is a small, static, but
DBAs should never 'guess' about performance. If they are guessing you need new DBAs.
They should be running statspacks, sql trace, and looking at timing data.
Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'.
How much are you paying these guys?
From:
Let me guess your secret: Windows box is running X-windows X11R6 and an OS
ending in x? Your version of windows has a bug in BSOD?
On 12/11/2003 01:59:37 PM, Cunningham, Gerald wrote:
Oh yeah? Just this week we had a Windows box that had been up for 29
days straight!!!
Yep. You read it
Not really sure what happened and why we decided to that. I was involved in the
beginning of project and remembered that PM was mentioning about talking to another
Logician client who were facing same issues.
-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003
Mark,
MS w2k3 server supports large memory in the standard product, advanced edition not required.For me,those (client) systems are still in acceptance testing, and I have not yet actually run them with a process memory 2 GB. I'll let you know after I do, sounds like a good test for a rainy
Thanks
I asked because we also use Citrix and so far we never had a problem related to
Citrix, only problems we had were inefficient coding and oracle bugs, nothing related
to HW/disk/WTS etc. The only problem initially with Citrix was configuring client
printers, but our guys figured it out
Oh I've run into THIS beforeyou are in a sticky technical AND political
situation I am sure.
It is really not that complex.
I'll bet they (your DBAs) have already been told you that the app is
horribly designed and it was a mistake and that the hardware is under
powered canned dataserver
Yes .. that is good.
GovindanK
On Wed, 10 Dec 2003 13:44:34 -0800, Freeman Robert - IL
[EMAIL PROTECTED] said:
Excellent slide show Tanel!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/10/2003 3:34 PM
dc_histogram_defs)
Pete, I'd like to
OK. Before we go blaming Oracle DB, you need to look at the entire picture.
1. Are other applications within the environment affected by slow
performance?
2. What other apps are running on the network?
3. Have any network-related diagnostics been performed to ensure that
Network bottlenecks are
Hi, Jonathan,
I think your question is why I mentioned TDU, not just SDU, in my response to
Guang's message. I admit I didn't give much thought and threw that in.
Note:44694.1 says it's set to 32k by default and its adjustable range is 0 to
32k. Then the question is why Oracle chose the magical
Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance
http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0Hisbn=059600527XTXT=Yitm=1
His methods sound
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande.
Am I correct?
Mladen Gogala
Oracle DBA
--
Please see the official
PCTFREE and PCTUSED are not part of the storage
clause.
SQL create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
Maybe it has been already mentioned here, but with ASSM, pctused
1 - 100 of 142 matches
Mail list logo