Re: What to look for in STATSPACK report

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

Re: What to look for in STATSPACK report

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

RE: What to look for in STATSPACK report

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

Re: Reasonable layout for DSS

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 to

extracting schema

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

Re: What to look for in STATSPACK report

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

Re: extracting schema

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

RE: ORA-904 after table rename

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

RE: SLA/metrics for RFP for programming services

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 profile.

linux

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

Re: SLA/metrics for RFP for programming services

Title: Re: SLA/metrics for RFP for programming services Jeff, As youre aware, whatever metrics you choose will govern their behavior. Completed deliverables is a good start, but if youre looking for well-tuned deliverables you could add a tuning-review gate through which each deliverable has

Re: What to look for in STATSPACK report

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

Re: What is JAWS 4.0.2 for RAC? How to get it?

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.

Re: Re: OS authentication; remote login; domain qualification

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 it

SYS Privilege

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 :

Re: linux

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

RE: rman backup

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 logs

RE: linux

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

FW: Disk capacity planning

I dont 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 Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit

RE: SYS Privilege

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

MS Access

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

RE: ORA-904 after table rename

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

Re: extracting schema

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

Re: Oracle vs Mysql

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

RE: SYS Privilege

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

RE: SYS Privilege

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

DBAzine Oracle Space Management handbook - Beware !!

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 usual

Re: MS Access

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

All pakages under sys is invalid

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 --

Re: advice

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

Thanx - I cleared the exam -- another OCP question

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

RE: Oracle vs Mysql

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

RE: SYS Privilege

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

RE: MS Access

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

RE: SYS Privilege

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

RE: SYS Privilege

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?

RE: SYS Privilege

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: Subject:

RE: Oracle vs Mysql

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

RE: Thanx - I cleared the exam -- another OCP question

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

RE: SYS Privilege

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

RE: How to update maxphys on Solaris 8 ......

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: How

ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory

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

RE: Oracle vs Mysql

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

ADMIN: Status of list server systems (and update about missing messages)

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: extracting schema

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 of

RE: ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory - Thank You !!!!!

Dear Friends, (B (BThank you so much. Yes i was able to solve this issue.. (B (BFYI ... I used CONVERT function (B (B

Re: Oracle vs Mysql

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

RE: RAC

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

Re: RE: Oracle vs Mysql

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 because it

RE: Thanx - I cleared the exam

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, you're

Re[2]: Oracle vs Mysql

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 who

Re: ADMIN: Status of list server systems (and update about

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 and bad

Spool to Excel File

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

Re: Oracle vs Mysql

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. The

Re: Thanx - I cleared the exam

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,

Re: Spool to Excel File

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 lines 1000,

Re: Spool to Excel File

PRANK Try with spool c:\Program*Files\Microsoft*Office\Office\excel.exe /PRANK 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 --

Re: Spool to Excel File

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. QUOTE Getting SQL Query Results into an Excel Spread Sheet By Pavel Luzanov This

RE: Thanx - I cleared the exam

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: