Jared,
I didn't make a detailed list but where I clearly noticed the inaccuracies
was in the sample exam questions at the back of the book e.g.
In which version of Oracle was hash partitioning introduced?
A) 7
B) 8
C) 8i
D) 9i
Answer D. The real answer as we know is C.
Problem solved thanks to ots
Event 1399 solved it, necessary during migrate
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Verzonden: Thursday, November 20, 2003 21:46
Aan: 'Jeroen van Sluisdam'
Onderwerp: RE: ora-600 / ora-00604 during migrate
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive
Hello. I'm trying to setup standby database on w2k, Oracle 9.2.0.4 (win).
When I create configuration and press next on step where we set destination
of datafile to be copied to an error occures:
READY_A
'perlglob' is not recognized as an internal or external command,
operable program or batch
Zhu Chao,
You are right to say that with a heap organized table you also have the index to
encumber the SGA and indeed you are right to say that, as I put it, what I said is not
totally correct. I should have been more specific.
The reference to _partitioned_ IOTs implicitly associated them
Dennis ..
You are right ...but what can we do if someone demands for such a report
.. They want to analyze and track every info .
Shibu
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Thu 11/20/2003 12:34 AM
To:
Hi ,
I was sending statspack report ..but there is request for more and more ..
.. That's how i started searching for a generalised report ...
Regards,
Shibu
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thu 11/20/2003 6:59 PM
Hi Group,
Greetings!
I have two databases, both has different time zones.
Say Database A has EST. Database B has IST
Every two hours I'm getting the database statistics from Database A and loading it to
B.
While loading I'm loading the data with IST. I want to load the statsitics in EST.
Hi ,
. I was sending him thestatspack report ..but ..u know .. he don't
understand that .. and is asking for more reports he wants even the
export dump file size ...:).. so i thought i will get a detail template
from someone else who is alreading have such a detail report ...
LOL -- developers deciding architecture design. Never really involved in
implementing anything, all conceptual.
I am what you call a production DBA, my personal bias on this is that
leaving architecture decisions to developers could be a mistake, if you
think long term. The Production DBA
Title: Message
The
President of our local user group, Peter Smith, won the PL/SQL
Developer of the Year award.
We had
our user group meeting yesterday afternoon. (I had previously arranged to have
the Oracle Rep bring about 20 copies of the Oracle
Magazine).
We had
fun publicly
Zhu/SF:
Thanks for your insight. I was under the impression that Oracle did not
recommend IOT for tables that where not fairly static.
Would the reasoning for this not being an issue in this case be due to
oracle now having to only maintain the IOT table blocks instead of the table
blocks and
always ... always start with requirement ... have _them_ tell you what _they_ need.
This is entirely different than what you can provide.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this
Just to clarify: I don't advise any one trying this in production. There is
a (small) chance that in case of instance failure you could end up with a
corrupt database.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003
Now, wouldn't you think that was intentional ... ??
Thanks
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is
the arrogance here is troubling. though there seems to be more incompetent developers
who do not know the database I have worked with my share of incompetent DBAs. Havent
used anything since versoin 5.0 and so on. Dont know anything at all about
development.
If a production DBA knows
yeah I saw that he deserves it!
--- [EMAIL PROTECTED] wrote:
The President of our local user group, Peter Smith, won the PL/SQL
Developer of the Year award.
We had our user group meeting yesterday afternoon. (I had previously
arranged to have the Oracle Rep bring about 20 copies of
Just FWIW - I set up dozens of alerts on our systems, monitoring conformance
to corporate standards. So, naming standards, presence / absence of
triggers, responsibility assignements in metadata, access privs consistent
with those assignements etc etc.
For every alert test, there will be a
not arrogance, experience.
Granted, there are good developers out there.
The tendency is to think only on a project by project basis in development
because of the way developers sometimes get funding to sustain themselves.
No offense was intended, it was a cautionary note nothing more.
Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks
American Express made the following
annotations on 11/21/2003 07:28:27 AM
--
I don't normally like to get into these turf battles, but in this case I have to agree
with Patrice. Most developers are looking strictly at their current project with no
regard for anything they've done in the past or that others around them are doing.
Also I find that a significant number
Yes.
On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote:
Does anybody know whether or not Oracle will support and upgrade of an 8i
database to 10? Thanks
American Express made the following
annotations on 11/21/2003 07:28:27 AM
Mladen,
Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, November 21, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Yes.
On 11/21/2003 09:29:31 AM, Tracy
I'm going to keep this response in my in-box to forward to developers when
they complain about their poorly tuned database.
Goulet,
Title: RE: RE: Development vs. Production DBA
But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control...
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the
From what I read, and learned from the private sources, it's going to be
a direct migration. Of course, I don't have 10g , so I can't tell for sure.
This tight lid on the software is, in my humble opinion, ridiculous.
My next answer to an oracle sales person will be that I have to keep the
tight
Oracle Database 10g provides a fairly easy upgrade path for users of older Oracle
versions. The following versions can directly be upgraded to Oracle Database 10 g:
Oracle Database 8.0.6
Oracle Database 8.1.7
Oracle Database 9.0.1
Oracle Database 9.2
If your database version is not in the
According to the presentation by Dave Foster of Oracle at the last
UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2.
Also, the new dbassistant has an undo feature, to rollback the upgrade.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of
i was on a project last year where the lead didnt let us make stored code. she thought
it 'cluttered the database'. what can you do? lots of incompetence out there. worst
when its the boss.
From: April Wells [EMAIL PROTECTED]
Date: 2003/11/21 Fri AM 09:54:33 EST
To: Multiple recipients of
Title: RE: RE: Development vs. Production DBA
Just
don't grant execute. ;-)
-
Alan Davey Senior
Analyst/Project Leader Oracle 9i OCA; 3/4
OCP w) 973.267.5990 x458 w) 212.295.3458
-Original Message-From: April Wells
[mailto:[EMAIL
I'm wondering if someone has a better solution than mine (see below) to the following:
We have a number of schemas that get cloned from our production schema (more on that
later). I need to be able to compare the size of the production schema to the target
schema and determine how much the
Linda, a stupid question: why are you comparing extents instead of number
of records? If my memory serves me right, there used to be things like
NUM_ROWS and AVG_ROW_LEN in ALL_TABLES or DBA_TABLES. All you need is
to run DBMS_STATS regularly and, voila, you've got yourself an accurate
rowcount.
We aren't running statistics against these schemas. When we were they caused
extremely poor performance so they were removed. I haven't been able to get sign-off
yet on re-instating them in test. Given that it's an ASP system with relatively few
tuned queries I think it's likely that they'd
Hi,
We are using Oracle817 on Windows with netscreen firewall.I have been
noticing after some times applications start connecting form 1521 to 1034
and so.IS this normal ?I want port 1521 Only in use. How to fix this
problem?
thx
-Seema
Niall and all other colleagues,
Thanks very much for your input on this subject. Very nice and productive
info so far. I agree that it is more click and select requirement but I
needed some more insight which I got it. There are 2 good books for Oracle
on Windows 2000 in the market and are
Linda,
When I saw your reference to 'cloning' below, I first thought you were taking
physical copies of your files. Perhaps this is something you might want to consider in
the future. For one thing, you just have to add up file sizes to see how much space is
required on the target machine.
Hi Seema,
Take a look on this document #131524.1 on Metalink.
You will have to add an entry in the registry to force the connection to
only use the port 1521
USE_SHARED_SOCKET=TRUE
Luc
-Original Message-
Sent: November 21, 2003 11:21 AM
To: Multiple recipients of list ORACLE-L
Hi,
We
Thanks for replying.
I can't do clones (we do for our apps database) because one schema in the production
database becomes 6 (soon to be 12) schemas in a single QA database. In addition we
can't refresh them all at the same time (nor do we have the space to have 12 separate
databases).
I
Hi Stephane:
Thanks for your good suggestion. I compared the method you suggested and the orginal
one and it indeed boosted the performance (in my simple test). However the ONLY
problem I am having is that by doing TRANSLATE, I lost the original delimits. The new
method (you suggested)
Seema,
This is a typical misconception on the workings of Net8. Port 1521 is only
used to contact the listener, after that the listener might:
a) create a server process which listens on a port other than 1521 OR
b) pass the connection to a prespawned server process, again on a different
port.
A few weeks ago I had a problem with the following query not returning rows:
Select count(*) .
from global.client_dim a
where a.reports_login = sys_context('userenv','session_user');
even though the following query indicated a match (thanks to whomever
suggested I dump the fields):
SQL select
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
This makes sense. Imagine the problems if the CBO scanned for any valid hint
in comment code after SELECT. A developer inserts /*+ Removed the following
hint due to poor performance FULL(A) */ to indicate that the hint was
causing performance problems. Lo and behold, the problems continue.
Daniel
Guang,
Well you are almost there ... you need fifo structure namely a pl/sql array
1. create a local pl/sql array to store the delimiter (store the ascii value of the
delimiter to be safe) my_array (varchar2(5))
2. as you find a delimiter insert into the first position in the array and
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful. Of
Arup Nanda scribbled on the wall in glitter crayon:
(1) use firewall around the subnet where both app/web server and db
server exist; not a firewall between them.
(2) Use TCP Node checking to restrict Net8 traffic to the db server
only from the app server.
(3) Use Connection Manager. USing
Would extproc_perl fit well enough, though, until 10g is here?
On Fri, 21 Nov 2003, Mladen Gogala wrote:
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of
47 matches
Mail list logo
