Darrell Landrum [EMAIL PROTECTED] wrote:
Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in
Alex
I would recommend you install Oracle's STATSPACK, if you haven't
already. If you haven't, consider buying Don Burleson's book Oracle9i
High-Performance Tuning with STATSPACK. You can run some STATSPACK
snapshots while the system is normal and see what the performance is like.
Ask people
Alex
In my experience, when I have inherited systems worrying about tuning was
the least of my concerns. I could think of other things to look into first
(no particular order):
- Backup/Recovery procedures
- like do backups happen, archivelog mode on (you would be surprised)
- Database Event
Thanks very much to everyne!
I should've told you, first mistake sorry, that this is ORACLE 8.0.6 -can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normalnomal.But what steps in identifying the slowdowns in performace should be taken
Note: forwarded message attached.Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more---BeginMessage---
Thanks very much to everyne!
I should've told you, first mistake sorry, that this is ORACLE 8.0.6 -can I run STATSPACK? Or should I stick with bstat/estat? I will be running
Reply to
///Thanks very much to everyne!
I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run
STATSPACK? Or should I stick with bstat/estat? I will be running stats during times
when performance is normal nomal. But what steps in identifying the slowdowns in
Thanks Darell! Your advice as well as from others is greatly appreciated.
Darrell Landrum [EMAIL PROTECTED] wrote:
Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be
Thanks Darell! Your advice as well as from others is greatly appreciated.
Darrell Landrum [EMAIL PROTECTED] wrote:
Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be
hi!
in your profile set $ORACLE_HOME to your oracle directory and
put $ORACLE_HOME/bin in your path
daniel
Les Ayudo 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 found error. Is there
something I forgt to
I'm just going to reinstall Oracle8i and start from scratch. Any docs out
there on uninstalling Oracle8i? The only ones I have found are on Windows
and they're all saying how Oracle does not completely uninstall. Is this
true for Oracle on Solaris? I ran the uninstaller and removed everything
Title: RE: newbie sqlplus ?
Launch $ORACLE_HOME/bin/dbassist and delete any database you have created.
Then launch the installer from your oracle cd and select deinstall option to deinstall the software.
chris
-Original Message-
From: Les Ayudo [mailto:[EMAIL PROTECTED]]
Sent
Title: RE: newbie sqlplus ?
Well, since I already went through the deinstall
option and also deleted the $oracle_home, is there something else I can
do? I'm trying to reinstall the db but i'm getting a prompt asking me if I
want to upgrade or migrate the old db at /db/oracle/... (strange
Title: RE: newbie sqlplus ?
Another question,
I setup my computer like this:
$ORACLE_BASE=/db/oracle
$ORACHE_HOME=/db/oracle/ora817/817home
My oracle directories like this:
/db/oracle/ora817/817db1 --files for
db1
/db/oracle/ora817/817db2 --files for
db2
/db/oracle/ora817/817db3 --files
Title: RE: newbie sqlplus ?
I'm a little confused by your post.
I'm not sure if this is where you
are going wrong but not so long ago, I failed to make the distinction between
the database and the oracle software.
If you have deinstalled/deleted the oracle
binaries (all files
Title: RE: newbie sqlplus ?
If that is where you want to put all of
your database files than yes.
I think that starting out, a single
location will be fine.
As you learn more about the database you'll
find that spreading the database out among server different physical disks is
key
unt points are available, then /db could be replaced by other
mount points for database files.
Have Fun :)
Les Ayudo wrote:
RE: newbie sqlplus ?
Another question,
I setup my computer like this:
$ORACLE_BASE=
Title: RE: newbie sqlplus ?
Using my setup or my example of folders, how would
you setup a db? I want to see what I'm failing to see. Thx for the
reply
- Original Message -
From:
Chris
Stephens
To: Multiple recipients of list ORACLE-L
Sent: Monday, February 24
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
found
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
1) select * from v$database;
Note: Picky perhaps, but instance and database may be different.
...
3) grant create session to scott;
Note: CONNECT is a role that includes the create session system privilege
and a LOT more. It is NOT a synonym for create session.
...
Don Granaman
OraSaurus
-
From: Santosh Varma [EMAIL PROTECTED]
Date: Wed, 12 Feb 2003 15:34:46 +0530
Subject: Newbie to Oracle DBA
Hello list,
I wanted to know of some good sites where i can learn the basics as
well as advanced DBA topics. Could anybody help me out ?
Thanks and Regards,
Santosh
I'd go along
This
will keep you busy. Enjoy.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
-Original Message-From: Santosh Varma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 12, 2003
4:09 AMTo: Multiple recipients of list ORACLE-LSubject:
Newbie to Oracle DBA
Hello
Santosh - Web sites are excellent for finding the answer to specific
questions, but may leave gaps in your knowledge. If I may offer a
suggestion, get a good fundamentals book, and work through it trying all the
examples you can. A good recommendation is Oracle9i DBA 101
I would strongly recommend a good beginner DBA text
such as DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1044859784
This will give you a good foundation for reading the docs.
Jared
On Saturday 08 February 2003 18:28, majid wrote:
Hi,
I used to use mysql databse, now
Majid:
1) Try select name from v$database;
2) Use the connect keyword to connect to another database. Example :
connect userid@database_name.
3) To create users, try
create user [username] identified by [password] default
tablespace [tablespace_name]
temporary tablespace
1)How to find out from sqlplus what is the current
database ?
once, connected, do select * from v$instance;
2)and how to switch to another one ?
from DOS prompt: by chaning your ORACLE_SID environment variable
or via Net8: either from SQL*Plus: connect system/manager@another_db
or from DOS:
thanks a lot 4 your replies.
/*i followed the way dick and mark suggested.*/
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Daniel - Can you explain the two alternatives in a little more detail,
especially the difference between the two. What types of systems are
involved (Unix, Windows)? Thanks.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003
hi!
a DBA inteds to speed up a script that is looping
and
sending hundred thousands of sequential update
statements like:
UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
he suggests copying the table to a file, change it
and then
load it into the DB again. i am strongly convinced
that this
is
Daniel,
Your gut reaction is right on-target. It is always a struggle to keep
certain folks from killing the entire village while trying to cure a single
case of the sniffles. What's worse is that such folks are usually quite
bright and talented. After, very few mediocre folks can either cure
Even with this little bit of information, it's obvious your DBA
is on the right track.
Any script that loops and executes 'hundred thousands of
sequential update statements' is total nonsense.
This will bring most any database to it's knees in a hurry.
Oh yes, I've had developers pull this
Mcfish? With or without the Big Mac and Egg McMuffin?
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Newbie ?
That my friend, seems to be fishier than Fishy
Here we have the McLobster...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Friday, August 16, 2002 12:48 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Newbie ?
Mcfish? With or without the Big Mac and Egg McMuffin
Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Newbie ?
That my friend, seems to be fishier than Fishy McFish, the
fishiest fish in
fishdom.
I would stay WELL clear.
-Original Message-
Sent
It does sound fishy, very fishy to me. First, we're in
recession, good jobs are hard to find. Second, what is a definition
of a good job? If you have to work 80 hours a week and be available
during the remnants of your time (via beeper, of course) for $35000/year,
and in a case of a mistake you
That my friend, seems to be fishier than Fishy McFish, the fishiest fish in
fishdom.
I would stay WELL clear.
-Original Message-
Sent: 15 August 2002 22:49
To: Multiple recipients of list ORACLE-L
Hello all
I don't know whether I should ask this question here or some other group,
so
Thanks for the tip.
Have a great weekend!
Sherry
From: JoJo Al-Zawawi [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: newbie seeks career direction: become a DBA or DEVELOPER?
Date: Wed, 22 May 2002 17:23:23 -0800
Hi Sherry
of
companies unless expressly stated otherwise.
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
23-05-2002 11:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:Re: newbie seeks
Mladen,
You? Sarcastic? Never :)
--- Mladen Gogala [EMAIL PROTECTED] wrote:
O
if you are enthusiastic and are adaptable and can express that to a
prospective employer you might get into what you want. I think
attitude
My advice to those who want to become DBAs is that they
On 2002.05.23 07:03 Farnsworth, Dave wrote:
Or you can go straight into damagement. It requires no technical
skills, no people skills and the innate ability to royally screw
things up. Upon completion of screwing things up, leaving a mess for
the DBA to cleanup, you then are promoted to a
Sherry,
Sounds like good advice. There is no way of actually knowing, but I'm sure
that the vast majority of DBAs on this list were systems- and
applications-developers first. I still consider myself a C programmer
first and foremost even though nobody cares about C anymore, and just
about
Hi Sherry !
I understand that Washington Mutual often hires entry-level Oracle DBA's.
Try them!
Cheers,
JoJo (Glendale, CA)
http://www.jojo-zawawi.com
-Original Message-
Lopata
Sent: Wednesday, May 22, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L
Hi gurus,
I have taken a
On 2002.05.22 20:33 Sherry Lopata wrote:
Hi gurus,
I have taken a few Oracle DBA courses at UCLA Extension, passed my
first DBA certification exam, but have not been able to find an entry
level position in this area. (My background is in printing and
marketing... big career move... I've
:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:Re: newbie seeks career direction: become a DBA or DEVELOPER?
Sherry,
Sounds like good advice. There is no way of actually knowing
O
if you are enthusiastic and are adaptable and can express that to a
prospective employer you might get into what you want. I think
attitude
My advice to those who want to become DBAs is that they shouldn't be
overly
concerned if they feel a pang of enthusiasm: it will pass. Healthy
It is
part of the Developper suite. However, I don't think it is the best tool
for developping oracle stored objects. I know a lot of developpers around
here are using PL/SQL developer (http://www.allroundautomations.nl/plsqldev.html).
Djordje
-Original Message-From: Michael
Purchase the D2K package from Oracle. However Procedure Builder is being phased out by
Oracle.
[EMAIL PROTECTED] 07/23/01 10:55AM
Hi Everybody,
I'm currently studying for some Oracle Certification from a private organization,
which will then put me through the Oracle DBA exams. I'm
Hi all,
I have a package created by user1, created a public synonym on the package,
granted execute on this public synonym to a user_role.
What the package does is:
Creates a user (test_user) dynamically, also ties him with a profile and
also grants the test_user the role above (user_role).
Yep, I've done it before without any problems
-Original Message-
Sent: 17 May 2001 05:06
To: Multiple recipients of list ORACLE-L
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same
Hi,
Yes, you can modify instance parameters in the initXYZ.ora file.
After you change them, they take effect when you bounce the instance
(shutdown and startup)
Also, there are some parameters that can be modify on the fly, without
bouncing the instance.
check this.
SQL desc
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same server?
Cheers,
Julia
-Original Message-
Sent: Wednesday, May 16, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
Look in docs for CREATE DATABASE command, maxlogfiles and maxlogmembers are
defined at database creation and stored in the control files. To change it
you must recreate control files.
You probably don't want to oversize this by much, as the control files grow
to leave space for the log
go to www.oracle.com
technet.oracle.com
www.lazydba.com
pipetalk.revealnet.com
That's it for now,
Mark
Mark Kirk
Working toward the Oracle DBA OCP
seeking an entry level position...
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, March 03, 2001 09:20
halo all,
i'm a newbie trying to start learnig about oracle
programming
problem is.i don't where to start :(
enlighten pse...
try
Hi Rakesh,
The Oracle user you are logged in as does not have select permission on
V$SESSION. Log in as sys and issue the command:
grant select on SYS.V_$SESSION to oracle user name;
HTH,
-Rocky
--- Rakesh Dinger [EMAIL PROTECTED] wrote:
Hi, I a newbie in Oracle and am trying to create a
Did you create the package spec before you created the body?
Kev
-Original Message-
Dinger
Sent: Thursday, March 01, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Hi, I a newbie in Oracle and am trying to create a package body in PL/SQL,
so please bear with me.
The statements
Let the beatings begin! grin
The package will compile, but the error is basically a security issue. For
some stupid reason, Oracle requires that access to objects referenced within
packages and procedures (and views, too, methinks) be done explicitly to the
owner of the package, and not to a
yup :)
From: "Mohan, Ross" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Newbie question on Packages
Date: Thu, 01 Mar 2001 12:40:41 -0800
Beat me with an overextended RBS if
you need be, but other than any
, Sussex, WI USA
-Original Message-
From: Jesse, Rich
Sent: Thursday, March 01, 2001 15:46
To: Multiple recipients of list ORACLE-L
Subject: RE: Newbie question on Packages
Let the beatings begin! grin
The package will compile, but the error is basically a
security issue
Hi,
One of the reason I'm saying that is that I just tuned
a batch job where in a huge loop there was a create
and a drop table . Performance was awful.
I'm more a development dba than a production dba so
I'm usually aware of all objects in the database.
The main thing is that "usually" the
stephane, just curious, really, no subtle lines...
should I, a developer, tell my dba that I'm gonna create temporary tables?
(I know most of you are dba's, please don't flame me...)
deep inside I would say, yes, but, really why?
Rigth access?
space allocation?
performance tunning?
curious dba?
61 matches
Mail list logo