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_t
The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.
You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be don
Any body having Oracle Dev/2000 6i CBT's .
If any Can you please send ?
Thanks in Advance ...
Kirtish P. Gaonkar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtish P Gaonkar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.f
Jay,
Keep in mind that these are usually runtime licenses.
The license agreement probably stipulates that you can
do no development on databases with a runtime license.
This week I have a consultant in installing an app
that runs on Oracle with a 3rd party license. Our
finance dept bought the
Dear : All
Can you tell me what other views i need to create to
ensure not other user can see my schema.
regards
JKean
--- Tim Gorman <[EMAIL PROTECTED]> wrote:
> Sure! Create the following views while connected as
> schema A:
>
>create view dba_users
>as
>select * from sys.dba_use
Jonathan -
>From : http://www.pcsndreams.com/Pages/Articles/Megabytes.htm
· 1 Bit = Binary Digit
· 8 Bits = 1 Byte
· 1000 Bytes = 1 Kilobyte
· 1000 Kilobytes = 1 Megabyte
· 1000 Megabytes = 1 Gigabyte
· 1000 Gigabytes = 1 Terabyte
· 1000 Terabytes = 1 Petabyte
· 1000 Petabytes = 1 Exabyte -
· 100
Actually, Tanel was right on the money with zetta and yotta.
Here's a small table:
Prefix Abbr. Base 10 Base 2
-- - --- --
kilo- k 10^3 2^10
mega- M 10^6 2^20
giga- G 10^9 2^30
tera- T 10^12 2^40
peta- P 10^15
Thursday, December 11, 2003, 6:14:25 PM, Tanel Poder ([EMAIL PROTECTED]) wrote:
TP> Hurry up, zettabyte and yottabyte might still be free ;)
Actually, now I wonder, how far do the names go? We have
kilobyte, megabyte, gigabyte, terabyte, petabyte, and then
what?
Best regards,
Jonathan Gennick --
I'm guessing that you removed the monitor, keyboard and mouse, disabled terminal services, removed it from the domain, unbound NetBIOS from TCP/IP and shut down all of the non-required services (especially "Server") - and - put a penguin sticker on the front of it, so that people thought it was a s
Hi,
You can do this:
delete
from orders o1
where rowid < (select max(rowid)
from orders o2
where o1.order_id = o2.order_id
group by order_id
having count(order_id) > 1);
O
Reminds me of the day when a third-party developed app (main batch program)
ran *very* slowly - the user department went out and bought this app and
server on their own without IT's blessing or support (a different story).
Dialogue below:
Third-party Developer (TPD): This same batch program which
But as you all know those are really crap, only companies such as EMC
benefit from it.
Eric
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 18:14
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
>
so what features does teradata have that oracle
doesnt for VLDBs?
- Original Message -
From:
Paul
Drake
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 11, 2003 6:59
PM
Subject: Re: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/Top
Paula,
I hope that you are just confused.
AFAIK, if you have created a database with a locally managed system tablespace, that you cannot set compatible to anything lower than 9.0.1.
Ok, you can set it, but oracle will complain during instance startup and you won't have a database instance to att
Can this be right? When I look for
Category: Peak Workload
Platform: All
Usage: OLTP
I see 6 SQL server databases and no Oracle databases.
> -Original Message-
> MacGregor, Ian A.
> Subject:
> http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.asp
>
--
Please see the offici
> Maybe they should rename the product Petadata.
If they did, then its a good thing that they didn't name it "TeraFile".
PdJonathan Gennick <[EMAIL PROTECTED]> wrote:
Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:R> very nice. what is teradata? I never hear that dbms men
In the situation below, is there a better way to write the delete statement that
eliminates duplicates? (assuming duplicate rows form at most 5 % of the table rows)
Notice that the exceptions table is not analyzed.
If I analyze the exceptions table, is there then another better way to write it?
Ryan wrote:
>
> you mean niemic didnt actually have to take the test?
Scary, eh ?
(couldn't resist)
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services
Hurry up, zettabyte and yottabyte might still be free ;)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 12:44 AM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> Yeah, clearly, the guys at
I owe an apology whether I'm correct or not, because (1) I didn't really
*know* the answer (only what I've heard), and (2) it's really none of my
business anyway. So... even if my speculation were correct, all I've
done here is to propagate a rumor, which is what I'm trying to live my
professional
They hire a DBA to run sp_lock a lot!
Ciao
Fuzzy
:-)
--
The contents of this post are my opinions only
If swallowed seek medical advice
> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]
> Sent: Friday, 12 December 2003 09:30
Yeah, clearly, the guys at Exabyte were thinking ahead when they came up with their
name. ;-)
-Original Message-
Sent: Thursday, December 11, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
Thursday, December 11,
anyone know how it compares to oracle?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:34 PM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL
Thursday, December 11, 2003, 5:14:26 PM, Ryan ([EMAIL PROTECTED]) wrote:
R> very nice. what is teradata? I never hear that dbms mentioned.
Isn't Teradata what Walmart uses? From what I know, it's
always been aimed at the market for really, really big
databases. Hence the prefix "tera", which isn't
Teradata is NCRs database engine mostly used for DSS & OLAP.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 12:14 AM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> very nice. what is ter
also, how do people scale sql server to that many concurrent users if reads
block writes?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:14 PM
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
> v
Well, I could say "Haven't you heard the song? Jeremiah was a bullfrog,
was a good friend of mine ...", but that would really date me. :)
Last I heard, Jeremiah was at Amazon. He occasionally posts answers on
oracle-l, so no doubt he'll correct me if:
a) I have his name wrong
b) I has his empl
As I recall Rich talking about it, he did indeed take the exam. It was not
just "handed" to him.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/11/2003 3:59 PM
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah w
Oh, and I forgot. No, the honorary OCM's didn't have to take the test.
They were given the OCM in recognition of their contributions to the
Oracle world as a whole. Actually, some of them I'd never heard of
before either, so that probably explains why I can't recall who they are
now.
Pete
"Cont
The answer to your first question is "Correct."
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com
Pete,
Scott Nelson, Paul Dorsey, Peter Koletzke, and David Ensor were also part of the
original 6-pack I believe, and it was announced in the fall of 2001. Maggie
Respectfully,
> Maggie Tompkins - CAD SQA
> Corporate Applications Division
> Technology Services Organization - Kansas City
> Def
very nice. what is teradata? I never hear that dbms mentioned.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 5:04 PM
sp
> These are their numbers for online databases. Most of SLAC'S Babar
Objectivity. database is on
No, no, no! Definitely not me. I'm 99.999% certain not Mogens or Anjo
either. I don't think Steve either (80% sure). Not sure about the
others.
Thank you for the sentiment, though!
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 De
These are their numbers for online databases. Most of SLAC'S Babar Objectivity.
database is on tape managed in a hierarchical file system, HPSS. Last I heard we had
about 50 TB online.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FA
you mean niemic didnt actually have to take the test? It was just handed to
him? who is jeremiah wilton?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 11, 2003 4:09 PM
> IIRC, Tanel did the OCM as well, but I suspect most of t
Hi...
check note: 119547.1 on Metalink
HTH
JL
--- [EMAIL PROTECTED] wrote:
> Hi List,
>
> Just changed my database from No archive Log mode to
> Archive Log mode and I am keep getting the following
> error in Alert Log. What could be wrong?
>
>
> Thu Dec 11 16:06:20 2003
> ARC1: Evaluating ar
Gurus,
What is FGRD and ARCH in v$archived_log.creator column.
I see something like below in my db.
select recid,creator from v$archived_log
RECID CREATOR
- ---
1 FGRD
2 ARCH
3 ARCH
4 ARCH
5 ARCH
6 ARCH
7 ARCH
8 FGRD
8 rows selected
Thanks for the vote of confidence, but I'm not an OCM.
In order to pass, I am lacking a few vital pieces (in increasing severity)
a) $$
b) time
c) knowledge
My knowledge and interest is rather limited to tuning and the CBO.
I believe Tanel is, according to credentials listed on the slides of his
Yup, I managed to pass it in december 2002 and I'd say it has been quite useful for an
unknown consultant from nowhere like me.
But I agree with you, other guys mentioned here don't need any certificate to prove
their mastership. They are way over any current or future certification anyway...
T
IIRC, Tanel did the OCM as well, but I suspect most of the others on
your list aren't prepared to waste their time attending OCP exams and
courses just so they can get the OCM. :)
There were some honorary OCM's announced when the program first started
(OOW2002?). From memory, Rich Niemic and Jer
Hi List,
Just changed my database from No archive Log mode to Archive Log mode and I am keep
getting the following error in Alert Log. What could be wrong?
Thu Dec 11 16:06:20 2003
ARC1: Evaluating archive log 6 thread 1 sequence 403
ARC1: Unable to archive log 6 thread 1 sequence 403
L
Woo Hooo!!
NOT ME!!
I'm a certified oracle bastard!
lol
Brad O.
okay...I'm done...
(back into my cage)
-Original Message-
Sent: Thursday, December 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this
> 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,
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 ORACL
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
=6WIANMIL0H&isbn=059600527X&TXT=Y&itm=1
His methods soun
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 32
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 n
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
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 ins
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 a
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 e
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 10:55
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 rea
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: <
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 fierc
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 file_rec_
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 facts,
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 are
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 M
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 com
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?
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 suppor
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
http
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
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: W
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.
>
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=>
c
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 Programm
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-
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:
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
The proc generates the 'exec dbms_stats ' statements for all the users. Are you saving the output 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
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 purchasi
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
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
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
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"). Aft
What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
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!
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 Orac
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, Oracle
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
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
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 O
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
[mailto:[EMAI
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 get_user
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 ther
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 hos
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 repo
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 th
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 reache
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.
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 PR
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 U
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
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, inexp
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
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 comple
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 mov
#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 too
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 joi
1 - 100 of 142 matches
Mail list logo