Hi,
I'm in the middle of
migrating oracle 7.3.4 to oracle 9.2.0.4
In process of testing we
encounter a big query that is now taking full table scans
Where it
used to take indexes.
When we compare plans this is evidently so,
Optimizer_mode is on both choose, tables and indexes are
Pete, I'd like to clarify my position first: I don't have any burning
problem
that would compel me to start testing 10g. I want only to learn the new
features.
Btw, if you want to learn some of the 10g database engine new features (not
the marketing buzzwords), then check out one of my
What good reasons might an application have to use and
depend on CHAR variables?
There was a recommendation in Oracle's intro to SQL training materials
several years ago, that you can use fixed-len char columns to make sure that
your rows never grow once inserted, thus reducing row migration
I remember Oracle saying that char was going away - about 6 years ago.
That's when they created varchar and varchar2.
Is this a new rumor?
VARCHAR3 type coming?
Tanel.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, December 10, 2003
Wednesday, December 10, 2003, 3:39:26 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote:
DW 2. I have been curious about Oracle's statement that you should use
DW VARCHAR2.
I am too, now. That statement in the docs about the meaning
of VARCHAR maybe changing someday has been there as far back
as my
I don't have any experience with Netbackup, just Legato, but there is a
utility called sbttest that may help in troubleshooting the
problem. Here's an example from something I wrote up a while
back:
/ora01/V901$ sbttest osmtab01.dbf -dbname V901 -trace
/oracle/sbtio.log
The sbt function pointers
A very long time ago, there was a whitepaper on implementing Veritas for Oracle
systems. I think it was published by Veritas. I've googled and searched veritas.com
and can't find it anywhere.
IIRC, one of the recommendations in the whitepaper was to not use rootdg for database
files,
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 clarify my position first: I don't have any burning
problem
that would compel me to start testing 10g. I want only to learn the
I read that section of the manual not that VARCHAR may go away, but that
that the functionality of the VARCHAR datatype may one day differ from
that of the VARCHAR2 datatype.
I forsee something like what happened with the CHAR type between v6 and v7.
Just my 0.02eur
Kevin
-Original
True
24x365 is just about impossible. No if, ands. or buts about it. Why
is because of the number of factors outside your control that affect system
availability. Sure your web sever and database are up 24x365, but your ISP
has 1 hour down time each month for maintenance. OOPS!! from a
Wednesday, December 10, 2003, 3:19:24 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
JSrc I didn't realize that parentheses would affect to optimizer to change the
JSrc join order.
But is it just a performance thing? Given a situation with
all inner joins, I can't conceive of the order making
Tanel,
Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe
still there?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, December 10, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
d
Excellent slide show
Title: Pipelined functions
Hi!
How did you test it? From sqlplus or external app?
Then check whether you have array processing turned on (it should be off if you
want to get rows one-by-one).
Or if in PL/SQL, are you using bulk
collections?
Tanel.
- Original Message -
From:
Unless Oracle has plans of buying IBM and decommissioning DB2
;-)
Murali.
|-+
| | Jonathan Gennick |
| | [EMAIL PROTECTED]|
| | .com|
| | Sent by: |
| |
Title: SQL Area Reloads
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
==
Library Cache Activity for DB: MAIN Instance: MAIN Snaps: 18089 -18090
-Pct Misses should be very low
Hi!
Try if you find the alert.log of your database and
see what are the last messages there. Maybe Oracle failed to mount or open the
seed database, thus leaving instance in "initialization or shutdown"
mode...
Tanel.
- Original Message -
From:
Natalia
Laracca
To:
When you want true 24x7 without compromises, then you have to step closer to
the client anyway.
This means, you have two databases for example and your app server
multiplexes all transactions to both ones.
This should be faster than sync standby or sync replication, because app
server can send
BTW, does anyone know what a rocket scientist refers to when
they say Hey,
this is all quite easy, it sure ain't ? ?
Cheers ;)
Richard
Surely the Rocket Scientist version must be Hey, this is all quite easy, it sure
ain't index rebuilding
very evil grin
Ciao
Fuzzy
:-)
--
Please
ROTFL! Completely blocked the fact out of my mind that this app started out
using InterBase (aka StarBase). It didn't change to Oracle until we lost
a day's worth of ERP because a Windohs PC crashed that was running a telnet
session to the server and didn't disconnect from the app/DB properly.
LOL,
This made me think of the Simpson's Halloween episode where Monty Burns
says,
'Smithers, this isn't rocket science, its brain surgery'.
-
Alan Davey
Senior Analyst/Project Leader
Oracle 9i OCA; 3/4 OCP
w) 973.267.5990 x458
w) 212.295.3458
The failure to do the 90/10 split is a bug (it worked
properly in 8.1) which is currently being investigated.
I can't remember the number, but I passed it to Oracle
some time ago.
As to the original question - no idea, 100/0 seems
to be the correct strategy; however, there was an
earlier
I think this subject has been done to death. We should talk about less contentious
issues such as:
- The buffer cache hit ratio, your friend in expert Oracle tuning!
- Rebuild your tables regularly to reduce the number of extents and improve
performance!
- Disk access is at least 10,000x
Has you db_file_multiblock_read_count changed due
upgrade?
What are youroptimizer_index_cost_adj and
optimizer_index_caching parameter values?
If they're default you should perhaps change them
according to Tim Gorman's CBO article (or in 9i, gather system stats
instead)
Tanel.
-
On 12/10/2003 04:34:25 PM, Tanel Poder wrote:
Pete, I'd like to clarify my position first: I don't have any burning
problem
that would compel me to start testing 10g. I want only to learn the new
features.
Btw, if you want to learn some of the 10g database engine new features (not
the
Vordos, Suzy wrote:
A very long time ago, there was a whitepaper on implementing Veritas for Oracle systems. I think it was published by Veritas. I've googled and searched veritas.com and can't find it anywhere.
IIRC, one of the recommendations in the whitepaper was to not use rootdg for
Title: SQL Area Reloads
You'll have reloads if your SQL is invalidated
because of DDL or analyzing on tables.
- Original Message -
From:
Ashish Sahasrabudhe
To: Multiple recipients of list ORACLE-L
Sent: Thursday, December 11, 2003 12:14
AM
Subject: SQL Area
Friends --
Perhaps you can help me out with this... I don't understand why the CPU time
should exceed the elapsed time here... Do you?
1 select a.username,
2 a.osuser,
3 round(elapsed_time/100,2) elapsed_seconds,
4 round(cpu_time/100,2) cpu_seconds,
5
Much seems to be made of this 'less than 30 init parameter to tune'.
Who really spends much time doing that anyway?
If you do, you're probably going after the wrong end of a problem.
Doesn't matter if there's 30 or 300, you don't usually mess with
them other than at database create time.
Thanks for all the responses. As I figured, everyone has a different
method, but the common thread seems to be automation. I'm not sure exactly
what approach I'm going to take yet, but I'll definitely try to automate
it as much as possible...
I'll add one of my own documentation tricks
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 web hosting company
that runs on open source: Linux, Perl, MySQL, PHP, etc.?
This is to be for my personal use,
Doesn't matter if there's 30 or 300, you don't usually mess with
them other than at database create time.
Shh Oracle thinks this is a marketing coup They want to make the
database look easy to manage...
Parameters? Ha, you only need configure a few basic parameters and the
Title: Pipelined functions
Doh !!
Ijust figured it out .. "set
arraysize 1" was the missing link ... one guy replied to my posting on
forum://Metalink:oracle_plsql that it might be client side caching and that
prompted me to experiment with arraysize.
So, it was an issue with sqlplus
Wednesday, December 10, 2003, 6:39:33 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
JSrc Can anyone recommend a good, inexpensive web hosting company
JSrc that runs on open source: Linux, Perl, MySQL, PHP, etc.?
I'm a big fan of Pair Networks, which you can find at
pair.com.
Best regards,
How about: Keep re-analyzing your tables and indexes. Run
gather_statistics (or whatever) all the time.
Bobak, Mark wrote:
I think this subject has been done to death. We should talk about less contentious issues such as:
- The buffer cache hit ratio, your friend in expert Oracle tuning!
-
Hi guru,
Can anyone tell me how to setup a client computer w/ linux as is os to
connect to forms cgi in an ias server using browser ? In win2k ,jiniator is
used to connect to forms in an ias server using browser only.
Best Regards,
Grace Lim
Suy Sing Comm'l Corp
--
Please see the official
Hi all,
(B
(Bi have written a small procedure to send e-mail from
(Bmy oracle database [oracle 9.2.0.3/win2k].
(B
(Bmessage := 'Date: ' || TO_CHAR( SYSDATE, 'DD-Mon- HH24:MI:SS' ) ||
(Butl_tcp.CRLF;
(Bmessage := message || 'From: ' || sender || utl_tcp.CRLF;
(Bmessage := message ||
Hello : All
I have a scenario here. I have a database name :
CYBER.
I am using oem to manage this dbase.In this database ,
i have created 4 schema . which is schema A, schema B,
schema C and schema D.
When i login into the dbase using schema A user id
throught oem , i can see all other 3 schema
Robert, Robert, Robert, when will you ever learn? You've been listening
to the marketing people again. :)
The whole goal behind this part of the release is not to make the
database look easy to manage (which is good because I've never thought
it WAS difficult to manage!) It's for those lower
they list the new application server and the new
developer suite as '10g', but then say 9.0.4 next to it?
so are they really new versions or just minor
upgrades to the 9i version?
This is a small, static, but fiercely loyal group of VMS users for HP to
milk. OpenVMS is money in the bank for HP, as it was for Compaq and DEC.
Even the bean-counters understand the insanity of shutting off a guaranteed,
endless, and highly-profitable revenue stream upon which they do not have
VARCHAR2 started with Oracle7 v7.0.x (circa 1992-ish). Prior to that,
Oracle6 had just VARCHAR with the exact same semantics/definition/behavior
as current VARCHAR2.
At the time, the explanation was that the ANSI SQL definition of VARCHAR
was slightly different from Oracle's existing
Title: Re: 24 x 7 x 365
As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years.
on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL
Title: Re: SQL Area Reloads
Sure, its free now. But has that always been the case?
on 12/10/03 3:14 PM, Ashish Sahasrabudhe at [EMAIL PROTECTED] wrote:
The statspack report is showing 10,684 reload for SQL AREA with 2.2% misses.
I apologize if someone already mentioned this (I've been busy so mostly
deleting traffic in order to keep from being overwhelmed!), but did anyone
mention the DBMS_METADATA package for this?
Looks pretty cool, mostly intended for generated XML output but also
generates DDL commands...
on
Sure! Create the following views while connected as schema A:
create view dba_users
as
select * from sys.dba_users
where username not in ('C','D');
create view all_users
as
select * from sys.all_users
where username not in ('C','D');
You might need to have SYS grant you
Dear : All
I have 2 database which is DB_A and DB_B. DB_A contain
schema A with the tablepace name as locus_tblspc.
Now DB_B is a newly create database. I would like to
populate what ever is in schema A to DB_A . This
included all the table,procedure,trigger,synonym,grant
and most of all
Yep, sqlplus.exe will still be there. Otherwise one wouln't be able to run
any automated sql scripts, because isqlplus can't do it as far as I
understand.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 12:04 AM
Read about transportable tablespaces. It works like this:
you export metadata, make a copy of the files in the place where the new database
can access them and import the metadata. There are many limitations and stipulations.
You really need to read the manual for this one. If you don't want to
Dear :All
Oh thank now i know where to dig the information, i
will try to read this manual, ... i bet it should have
take me some time :)
thank
Jkean
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Read about transportable tablespaces. It works like
this:
you export metadata, make a copy of
101 - 149 of 149 matches
Mail list logo