Robert and Matthew,
Thanks for your responses. This is an attempt at adressing both points of
views.
Personally, I didn't want my messages to imply that people working with and
for IOUG are bad people that don't do anything good. If that's what came
across from my messages, a heartfelt Undsky
...oops, and I forgot to add that you might wanna wrap
the call to 'dbms_shared_pool' in pin_me within exec
immed, so that if the package ever goes invalid (or
does not exist - ie forgotten to be run) the trigger
will still run ok.
cheers
connor
--- Richard Ji <[EMAIL PROTECTED]> wrote: >
remove
Now that everyone has said "remove the exec" I'll
confuse things :-) by adding that you might to have
the trigger always "succeed", because after all, it is
a startup trigger on the database.
So maybe something like:
create or replace trigger ...
procedure pin_me(x,y,z) is
begin
dbms_shar
You guys are very kind, thank you.
My "LIO vs PIO" thesis is this:
1. Too many PIOs *is* a bad thing.
2. But eliminating unnecessary PIOs isn't enough. Even completely
memory-resident databases can perform horribly (not scale, consume
dozens of hours per query, etc.)
3. If you begin by eliminatin
#0 - Do understand the business need(s) being met (along with business
terminology).
Being able to commincate technical information in terms that business
decision makers
use is critical for the business bottom line (and by extension - your
own bottom line).
Have Fun :)
Freeman Robert - IL wro
Title: Message
remove
exec immediate.
Richard
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]Sent: Sunday, February 23,
2003 2:59 PMTo: Multiple recipients of list
ORACLE-LSubject: Error pinning PKS in shared pool
Sorry, new DB
and hadn't execut
Well.
...this morning my wife looked around and harrumphed, "It must have been a
*MAN* who said this is more than 20 inches". :-) Can't imagine what she
was referring to...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, February 23,
Hey Robert, I rather like your list, it gives one plenty to ponder. I have
maintained my own much smaller list for some years, and thus will take this
opportunity to share it:
1. Do keep your knowledge concurrent. This includes reading books (by Jared,
Cary, let us not forget Gaja and Kirti's book
20 INCHES of snow WOW!! When I moved up to Chicago in January, I
expected at least a little snow boy, weve gotten just little snippets of
snow and that's it disappointing. Now I know where it's all gone!
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts ww
why #5 on the don'ts?
I know we've had lots of discussions on this list about it, but I
haven't seen anything that made me think "never ever use that"
--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> Here is the list of top 10 do's and don't that I came up with.
>
> #1 - Do Maintain your Ex
This thread is great. Wish I was paying more attention to it.
Here is one "Don't"
Done rely on gui tools to accomplish any task. Great DBAs can endure the
SQL to get the answer done. Good DBAs may opt for a GUI tool but will still
use command line SQL first. Poor DBAs run for their GUI tool
I don't say never use autoextend in production, I just say "think about
it" :)
--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> OK, I finished my top 10 do's and don'ts... I'll put my list in
> another post
> for anyone to comment on.
>
> THEN I looked at your list Rachel.
>
> I had some of
Interesting thoughts Tim! I shall consider changing those!
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (It's everywhere that I am!)
Author of several books you can find on Amazon.com!
-Original Message-
Sent: Sunday, Febr
Actually, I have quite a bit of text associated with each of my 10 do's and
don'ts... in the text of each, I actually state what you are saying. That
is, that there are actually very few hard and fast rules about anything. For
example with ASSM I suggest that in 9i it's probably not usable, and if
OpenVMS 7.1-2
Oracle 8.1.7.4
db_block_size 4096
I need to re-create a large table and its associated
indexes as fast as possible, and with a limited amt of
disk space. I have a new tblspace at 7000m for index
creation.
I'm creating indexes with DOP4. (I really need the
speed I get with parallel
Robert,
Thanks for sharing this...
Sorry to chime in late (we got over 20 inches in the mountains this
weekend!), how about "Don't execute any day-to-day SQL manually more than
once; plan for reuse by scripting it the first time"?
And, with all due respect, how about changing "Do Monitor Your Da
Yes, regarding these 3, how can they be considered absolute do's or don'ts?
I didn't take Cary's material to mean ignore physical IO's but rather to show the
importance and impact of logical IO's. Too many PIOs could still be an issue.
(I would say maybe Cary could speak to this, but I'd rather h
I've seen this error before a long time ago and can't remember exactly what I did
(should start keeping a database, no pun intended).
Have you been able to start this database at all ( can you start / stop it using
svrmgrl )?
If not, are there other databases running on this system (probably not
Here is the list of top 10 do's and don't that I came up with.
#1 - Do Maintain your Expertise
#2 - Do Use the DBMS_STATS Package to Collect Statistics
#3 - Do Use Bind Variables
#4 - Do Put your Production Database in ARCHIVELOG Mode
#5 - Do Use Locally Managed Tablespaces
#6 - Do Monitor Your Da
OK, I finished my top 10 do's and don'ts... I'll put my list in another post
for anyone to comment on.
THEN I looked at your list Rachel.
I had some of yours on mine, but I actually disagreed with you about
autoextend.
I've had this argument with others before, and here is my POV:
1. In developm
Title: Message
You can take out the “exec immediate”,
I believe.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ramon
E. Estevez
Sent: Sunday, February 23, 2003
2:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: Error pinning PKS in
sha
Les Ayudo wrote:
>
> yes, it looks like the setuid bit is correctly set...Any other suggestions?
Hmmph ... Is your database started ?...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PRO
I would say that one of the more important "Do's" is "Do understand
details about your O/S and storage system". For example, I think every
DBA should be able to map data files back to physical devices,
regardless of the storage vendor (EMC, Hitachi, etc). When you look at
I/O statistics from v$fi
Title: Message
You do not need 'exec immediate'
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Sunday, February 23, 2003 2:58
PM
Subject: Error pinning PKS in shared pool
Sorry, new DB
and hadn't execute the D
Don't think you need to use execute immediate. Try this (should be run
as SYS):
CREATE OR REPLACE TRIGGER PAQUETES_MEMORIA
AFTER STARTUP ON DATABASE
BEGIN
dbms_shared_pool.keep('DBMS_ALERT');
dbms_shared_pool.keep('DBMS_DDL');
dbms_shared_pool.keep('DBMS_DESCRIBE');
dbm
Title: Message
I erased the exec
clause and it worked.
Sorry and
tks
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
yes, it looks like the setuid bit is correctly set...Any other suggestions?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, February 23, 2003 6:38 AM
> Les Ayudo wrote:
> >
> > Looked over some websites and still couldn't figure out why I
Title: Message
Sorry, new DB and
hadn't execute the Dbmspool.sql script.
CREATE OR REPLACE
TRIGGER PAQUETES_MEMORIA AFTER STARTUP ON
DATABASE BEGIN exec immediate
dbms_shared_pool.keep('DBMS_ALERT'); exec immediate
dbms_shared_pool.keep('DBMS_DDL'); exec immediate
dbms_s
Hi All,
We are trying to implement change data capture. It works great on
tables, however I am unable to get it to work on snapshots. Created a
change table on the snapshot. Updated the base table, refreshed the
snapshot but did not see any rows being populated in the change table.
Any clues...or
hi, friends:
We are considering whether to use data guard to replace OS ha solution like
VCS.I tested Data Guard 9.2 on my linux PC server and it seems they work pretty good.
But I have no experience running data guard in production, so ask for your experience:
1.Do you use data
Title: Message
Which one is the
substituion procedure for DBMS_SHARED_POOL in 9i ?
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
The article is available on the NYOUG website (www.nyoug.org) under the
Technical Journal archives
--- [EMAIL PROTECTED] wrote:
> Rachel: where can we find that article ? can u post the url ?
>
> -Original Message-
> Carmichael
> Sent: Sunday, February 23, 2003 6:24 AM
> To: Multiple rec
You can find it on www.nyoug.org under presentation link.
Richard
-Original Message-
Sent: Sunday, February 23, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Rachel: where can we find that article ? can u post the url ?
-Original Message-
Carmichael
Sent: Sunday, Febru
it's likely that many of the don'ts are generic, that was the point.
or you could just quote me or make some sort of attribution, then it's
not plagiarism :)
--- Robert Freeman <[EMAIL PROTECTED]> wrote:
> Ahhh well, I will look it over but I wouldn't want to plagiarize
> from
> you Rachel.
Rachel: where can we find that article ? can u post the url ?
-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L
for the don'ts you could just read my paper "how not to be a DBA, the
top 20 mistakes" which I gave at IOUG last ye
Thanks Robert ! sure, i also need to learn RMAN. that would definitely help.
thanks all for the guidelines !!!
-Original Message-
Robert - IL
Sent: Saturday, February 22, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L
If I may, my Oracle9i RMAN Backup and Recovery book provides a
Ahhh well, I will look it over but I wouldn't want to plagiarize from
you Rachel.
RF
-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L
for the don'ts you could just read my paper "how not to be a DBA, the
top 20 mistakes"
Do the following at the command line:
echo $PATH
Then look to see if your ORACLE_HOME/bin is in the path.
If not, you need to put that in your path. and just to make sure that it is
being found, do:
which sqlplus
This should return the path to sqlplus. If it cannot find it, you will get a
me
Les Ayudo wrote:
>
> Looked over some websites and still couldn't figure out why I was getting
> these errors. I made sure my variables were set and still could not
> connect. Any ideas?
>
> I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need
> more info.
>
> error 1034:
Les,
Check your PATH. Issue echo $PATH and your should
have $ORACLE_HOME/bin
Otherwise you should enter the full path.
Luc
--- Les Ayudo <[EMAIL PROTECTED]> wrote:
> I have just installed Oracle 8i1.7 on solaris 9
> (ultra sparc 10) and issued
> the command sqlplus and I rec'd a "command not
>
Looked over some websites and still couldn't figure out why I was getting
these errors. I made sure my variables were set and still could not
connect. Any ideas?
I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need
more info.
error 1034: Oracle not avail.
error 27101: shar
Title: Message
Hi
list,
I have my DB
server with 2 network card and I want to split the connections between the
users to balance the load.
I
added LOAD_BALANCE=ON in the listener.ora and another line with the new ip
address with the port 1526.
Now all the
connections are managed wit
I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued
the command sqlplus and I rec'd a "command not found" error. Is there
something I forgt to do before the install? Let me kow if u need more info.
THanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
for the don'ts you could just read my paper "how not to be a DBA, the
top 20 mistakes" which I gave at IOUG last year
--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> I'm collecting up a list of the top 10 do's and don'ts for DBA's
> for a little article I'm doing. Anyone want to provide thei
44 matches
Mail list logo