Hi Helmut,
There are so many opinions about this that it's hard to point at one
specific document or recommendation. If anything, start with stuff
written by Graham Wood (who has done a good deal of the work on it),
Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about
it in h
Helmet,
Mogens makes a lot of good points as normal. As usual it's never as simple as
we'd like it too be and it depends on how your system runs. One thing that is
worth monitoring is changes in statistic values over time.
For example if your buffer cache hit ratio is normally 85% during your p
Helmut,
Performance, like beauty, is in the eye of the beholder. Ideal thresholds only
exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would
be to collect information at a time when performance is perfectly satisfactory and use
it as a baseline. Then check wh
Keith,
First of all, please remember that, despite the popular perception that
because data warehouses are "read only" (they aren't, by the way!), they do
not place great demands on the I/O subsystem.
The real facts are that data warehouses, because much of their I/O activity
is uncacheable due t
Hi all ,
How can I produce extract schema script(tables , tiggers , objects, procedures
...) from database. Any tool , script , idea ?
Thanks
Arslan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network S
You will find a utility add on for statspack at Mogens company site,
www.miracleas.dk. It is called YAPPPACK.
You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate
response time graphs for your databases.
There are many different numbers to look at in a statspack report, but
many tools will do that, but if you're on 9i, check out dbms_metadata
package.
joe
[EMAIL PROTECTED] wrote:
Hi all ,
How can I produce extract schema script(tables , tiggers , objects, procedures ...) from database. Any tool , script , idea ?
Thanks
Arslan
--
Please see the official O
It turns out that the user had configured TOAD to use a table filter, which causes it
to create and store a query. As you've probably guessed, the query was referencing a
column which no longer exists.
On a related note, I initially tried to capture the failing query using "alter system
set ev
At 11:04 AM 1/18/2004, Thomas Jeff wrote:
Tim,
Thanks for the
reply. We are thinking more along the lines of metrics
pertaining
to identifying the required efficiency of the outsourced ETL task, e.g.
time, resource
utilization,throughput, etc, in essence some desired baseline resource
profil
Hello list, sorry for the off topic question , but I thought that a question
on unix would not ruffle too many feathers.
what all changes will you make to convert linux to a Real time operating
system ?
Can anyone please help me with an answer and explanation ?
--
Please see the official ORACL
Title: Re: SLA/metrics for RFP for programming services
Jeff,
As you’re aware, whatever metrics you choose will govern their behavior. Completed deliverables is a good start, but if you’re looking for well-tuned deliverables you could add a tuning-review “gate” through which each deliverable h
Helmut,
Register with "http://www.oraperf.com"; and run those STATSPACK reports
through the YAPP analyzer, which will reformat them in such a way that they
make sense.
All of the ratio stuff on the STATSPACK report is ignored by the YAPP
analyzer, and instead the reformatting looks at things from
Great!!! May be this is your way of solving problems.
--- On Fri 01/09, Mladen Gogala < [EMAIL PROTECTED] > wrote:
To: [EMAIL PROTECTED]
Date: Fri, 09 Jan 2004 17:04:25 -0800
Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will
come.
___
Hi
Thanks for the info. Let me try this.
Regards,
B S Pradhan
---
On Mon, 19 Jan 2004 Jared Still wrote :
>You must set OSAUTH_PREFIX_DOMAIN=true in the registry to
>use externally identified domain accounts.
>
>I can't recall if the default value is true or false, but
>try setting
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege but I can connect internal, How can I set my SYS user to connect
as sysdba.
I am running on 8.1.7.4 Windows 2000 Professional edition.
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818
I would probably go to the http://www.realtimelinuxfoundation.org and see what's there.
The next thing would be to start looking into other RT Unix systems and when all
of the needed information is compiled, I would post an article with the solution on
this list.
On 2004.01.19 09:54, [EMAIL PRO
Sorry to respond to such an old thread (man I'm way behind), but what if the
"expected" location of the archived logs isn't large enough? For example,
let's say we have a 10G archive directory, and we dump 5-10G of logs per day.
I have to go to a backup made a week ago. That's 35-70G worth of log
Having never done it, I'll just refer you here:
http://www.tldp.org/HOWTO/RTLinux-HOWTO.html
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is." --Unknown
--
I don’t think this one made it
through on my first attempt.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
Upcoming events:
- Performance
Diagnosis 101: 1/27 Atlanta
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004:
March 7–10 Dallas
- Visit w
Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege b
Hi all,
I was wondering if any one out here knows if there
is a good list (mailing list) for discussing MS Access problems. I am
specifically looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to convert such a database into
a
I went through a similar problem with the 904 error. I had to use oradebug
to get a trace file to be produced.
Good luck,
Chris
-Original Message-
Sent: Monday, January 19, 2004 8:14 AM
To: Multiple recipients of list ORACLE-L
It turns out that the user had configured TOAD to use a tabl
Hi
have a look at Chris O'Sullivans tool T.O.Y.S. at
http://www.impacttoys.com that allows you to extract the schema from a
database.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle
that size? We used MySQL in some of the web projects, but it just stores
small set of operational data and later on those data are moved to Oracle as
a permenant store. For small set of data, MySQL is quite good, but it lac
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file?
-Original Message-
Hamid Alavi
Sent: Monday, January 19, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password
sqlplus
-Original Message-
Sent: Monday, January 19, 2004 2:00 PM
To: Multiple recipients of list ORACLE-L
Hamid - Are you using sqlplus or sysmgr?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 19, 2004 1:49 PM
To: Multiple reci
In the interests of trying to highlight Oracle related material of
"questionable" merit, I would like to draw your attention to (yet another)
www.DBAzine.com document. This time, it's the recently available free
download "Oracle Space Management Handbook" that has caught my attention. I
have as usu
viraj2 wrote:
Hi all,
I was wondering if any one out here knows if there is a good list
(mailing list) for discussing MS Access problems. I am specifically
looking for migrating/converting large Access database into Oracle
database. I need to know what will be the steps to convert such a
dat
All,
I have an strange problem, most of the packages under SYS user are invalid
when I compile it it's compile without error but when I back again the
package still is invalid, anybody have any idea?
Thanks in advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
At 07:59 AM 1/15/2004, you wrote:
What else can I suggest to help them
collect data that will be informative?
My business card ;-)
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Hi list , thanx a lot to all of you .
i cleared the #1Z0-031 exam last week .
thanx again for all the support given by you friends.
Kind Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services
Ryan,
It's postgres.org. I'm not sure how they generate the operating revenue they
need, but that's why they are not advertising like MySql AB is.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 14, 2004 5:05 PM
To: Multiple rec
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
To: Multiple recipients of list ORACLE-L
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES
> viraj2 wrote:
>
> > Hi all,
> >
> > I was wondering if any one out here knows if there is a good list
> > (mailing list) for discussing MS Access problems. I am specifically
> > looking for migrating/converting large Access database into Oracle
> > database. I need to know what will be the
Do you have that password in your password file?
-Original Message-
Sent: Monday, January 19, 2004 4:14 PM
To: Multiple recipients of list ORACLE-L
here it is:
remote_login_password= EXCLUSIVE
sqlnet.authentication=(NTS)
-Original Message-
Sent: Monday, January 19, 2004 2:01 PM
the password still is chamge_on_install & I could connect as a normal user
means it's there but not enough privilege to connect as sysdba.
-Original Message-
Sent: Monday, January 19, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Do you have that password in your password file?
If you haven't done so, you need to set the environment variable ORACLE_SID.
Jared
Hamid Alavi <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/19/2004 03:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was
better at marketing. All detailed in the book "The Difference Between God
and Larry Ellison". I can see it now -- MySQL, the Oracle of the free
databases.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Prem - We had no doubt. I always figure when you've studied enough to doubt
your study guide, you're ready to pass the exam.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 15, 2004 6:04 AM
To: Multiple recipients of list ORACLE-L
Hi lis
Use the ORAPWD.EXE utility and create a password file:
Assume your DB name is test:
1. Find any files named testpwd.ora.
2. Delete these file(s)
3. Find orapwd.exe and, at the command line:
c:\oracle\ora92\bin> orapwd file=testpwd.ora password=ginger
no spaces before or after the=signs.
The sy
Janardhana,
Check this link.
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert/23249
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janardhana Babu Donga
Sent: Friday, January 16, 2004
12:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: Ho
Dear DBAs,
Good Morning. Using PL/SQL procedure I am trying to spool out
Japanese Characters with VARCHR2(3600) size and I am getting this error.
Here is my code. For your information it is Japanese Characters
Spool c:\test.log
Declare
cursor c1 is select contact_detai
If MySQL comes to have the same capabilities that many people expect
from Oracle, marketing will have no effect. The huge differential in price
point will be all that matters.
Jared
DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/19/2004 04:04 PM
Please respond to OR
Folks --
I have good news and bad news. ;-) First the good news:
Several people had mentioned that they've sent messages to some lists but have not
seen the posts arrive back to them. These messages DID appear in the archives though.
This started roughly 12-Jan-2004. I had previously re
Title: extracting schema
If you are on 9I, you can use
dbms_metadata.get_ddl. You can also use export/import without data to get schema
definition.
-Original Message- From:
[EMAIL PROTECTED] on behalf of [EMAIL PROTECTED]
Sent: Mon 1/19/2004 5:04 AM To: Multiple recipients
Dear Friends,
(B
(BThank you so much. Yes i was able to solve this issue..
(B
(BFYI ... I used CONVERT function
(B
(B
(BUTL_FILE.PUT_LINE(fh,convert('"$BD9=j%^%M!<%8%c!(J","$BEj;qL>(J","CAPID","$BA01Q8l(J","$BA0F|K\8l(J","$BF|IU(J","$B;~4V
It needs not to have the same capabilities, it needs to have capabilities that people
are using. The primary capabilities that people need, in my opinion, are a decent
scripting language, with the full complement of the database triggers, procedures,
packages and functions, ability to store/acces
Dear All,
I am posting this again as It seems to have got lost
Regards
Sriram Kumar
-Original Message-
Sent: Monday, January 19, 2004 1:26 PM
To: '[EMAIL PROTECTED]'
Importance: High
Dear Guru's,
Firstly, apology if this question sounds silly.
I am intrested in setti
> DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
>
> Sounds like the old Oracle vs. Ingress battles. Oracle won because it
> was
> better at marketing. All detailed in the book "The Difference Between
> God
> and Larry Ellison". I can see it now -- MySQL, the Oracle of the free
Bzzzt. Oracle won be
Hi Dennis , thanx a lot for your encouraging words.
my morale being high , let me go ahead with the
next exam .
Thanks and Regards,
Prem.
>>-Original Message-
>>From: [EMAIL PROTECTED]
>>
>>Prem - We had no doubt. I always figure when you've studied
>>enough to doubt your study guide, yo
Monday, January 19, 2004, 11:04:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG> A good compiler support
MG> with something similar to long extinct SQL*Module (originally an IBM technology)
I used to use a SQL Module compiler. Not with Oracle though.
It's rare for me to run into someone else wh
Bruce,
My hat is off to your hard work to keep lists like this running. I
know that I (and I'm sure many others) appreciate the huge brain trust
that has come together here.
Thanks and keep up the good work!!!
Stephen
>>> [EMAIL PROTECTED] 01/19/04 06:39PM >>>
Folks --
I have good news an
Dear Friends,
I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know.
Thank You
Mudhalvan M.M
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mudhalvan, Moovarkku
INET: [EMAIL PROTECTED]
Fat City Network Se
> It needs not to have the same capabilities, it needs to have capabilities that people
> are using.
Um, that's what I said, or at least meant.
On Mon, 2004-01-19 at 20:04, Mladen Gogala wrote:
> It needs not to have the same capabilities, it needs to have capabilities that people
> are using. Th
When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken.
Not that I'm complaining.
On 2004.01.19 23:34, Prem Khanna J wrote:
> Hi Dennis , thanx a lot for your encouraging words.
> my morale being high , let me go ahead with the
> next exam .
>
> Thanks and Regards
Hi,
You won't be able to write an Excel format directly but you can create a
.csv file, which Excel will happily read in - you'll just have no real
formatting options.
Look into some of the sql*plus commands like "set heading off", "set verify
off", "set feedback off", "set pages 0", "set lin
Try with
spool c:\Program*Files\Microsoft*Office\Office\excel.exe
On 2004.01.19 23:44, "Mudhalvan, Moovarkku" wrote:
> Dear Friends,
>
> I am trying to send output from SQLPlus to Excel file. If any
> one did the same before please let me know.
>
> Thank You
>
> Mudhalvan M.M
> --
Hi,
Years ago, I stole this idea from:
http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm
I've used it a few times, mostly to impress
bystanders. It's got size limitations, but kinda cool
anyhow.
Getting SQL Query Results into an Excel Spread Sheet
By Pavel Luzanov
This months sc
>>When I was doing my OCP exams, I didn't have Dennis to cheer
>>me up, only Heineken.Not that I'm complaining.
but Mladen , i can't stop with just one : ))
so i better stay away from it during exams.
Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
59 matches
Mail list logo