On Fri, Mar 29, 2002 at 03:33:20PM -0800, John Kanagaraj wrote:
> The reason may be driven by the requirement of
> 'develop-within-this-deadline' for Developers, and
> 'get-this-query-to-respond-within-1-sec' for DBAs. The DBA's responsibility
> (among others) is to run a well tuned system, the De
Charlie,
We do a cold backup of the production database active tablespaces (36
GIG) each night and a cold backup each Sunday night of the full
database(active and read-only tablespaces 70 GIG). The reason we backup
the read-only each week is it is easier to restore from one tape and I
do not con
Dear Brian and other gurus !
May i ask U to give a word or two on the topics U mentioned , i.e.
"How to detect, diagnose, and recover from an instance hang;
What do you do when a user calls and says the system is slow or that
theycan't connect;
How to capture application SQL errors from the db
In old days when I used to work on Ingres, you could bring up one db server
and start different databases akin to bringing up only one oracle.exe
serving different processes. That probably is similar to Sybase.
Raj
__
Rajendra Jamadagni
Those of you who have been on the list for a few years probably remember me
asking stupid questions when I was a duh-veloper. (I remember one in
particular where I flipped out because I didn't remember the difference
between UNION and UNION ALL and got my a$$ handed to me.)
My two cents: Not al
On Sun, 31 Mar 2002 17:23:18 -0800, Patrice Boivin wrote:
>WOW, is the certification market that bad?
>
>Their books were useful, I wonder what happened.
Computer book sales have been sharply off since at least
spring 2001. The situation greatly worsened in the fall.
September was not kind, as b
Greg,
Don't I wish the developers would use the tools available to them for
tuning.
Zilch, None, Nada. I live with what I get from the developers and I
have yet been able to get any changes made to the applications. This is
one of the problems you encounter where there is 2 distinct departments
- Original Message -
From: "Andrey Bronfin"
> > I'll also appreciate very much if other list
members could post any possible> interview non-trivial questions with
some short answers.>
try "Where can one get sample Interview Questions?" from
http://www.orafaq.com/faqjobs.htm#INT
http://www.crn.com/Sections/BreakingNews/BreakingNews.asp?ArticleID=30009
Dear gurus , what do U say about this ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 53
All,
We are in transition here at my site. Our primary development tool
over the past few years has been a client-server tool named Uniface from
Compuware, which does an excellent job of protecting developers from
themselves. However, we are switching to Java, and moving more developers
fr
I figured you were, but I didn't want someone to mistakenly get the idea
that
it somehow made copying legal... :-). In fact, I'm not sure whats going to
happen at this point
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoki
Charlie - Currently on most of our systems we do a weekly cold backup and
rely on archive logs for the rest of the week. We augment this with full
exports a couple of days/week. This is not ideal. Previously we did nightly
cold backups, but our systems grew to the point that wasn't practical. We
t
It's a long story. Publishers in general are suffering these days...
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message---
Hi Ron, what o/s are you on?
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 9:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-00020: maximum number of processes (100) exceeded
>
> I need to increase max processes
I need to increase max processes but I can't log in. Can anyone tell me how
to get into the database
when I get ORA-00020 errors?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FA
- bcp out - It's time Oracle came up with some utility to extract the data
in
ascii format other than recommending "sqlplus and spool"
What about utl_file functions?
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Any
John Kanagaraj wrote:
>
> Greg,
>
> The reason may be driven by the requirement of
> 'develop-within-this-deadline' for Developers, and
> 'get-this-query-to-respond-within-1-sec' for DBAs. The DBA's responsibility
> (among others) is to run a well tuned system, the Developers' responsbility
> is
Yep... I was expecting royalty statement this month (as opposed to checks!)
actually one book should have been paying out so I was hopeful for my
first real royalty check!! :-(
By the way, Jonathan, Have your SQL*Plus books (love em!)... see you have
good reviews on your SQL*Loader book, so I
I've never understood Oracle's business plan when it comes to
development/data extraction tools. It's like they are only "half
interested" in that end of the market.
Sure, they have Forms, Reports, Graphs, JDeveloper, Discoverer etc. But
they always seemed weaker than even the nearest competit
Hi DBAs,
I want to move some indexes to another tablespace. Is there something
similar to alter table move tablespace or do I have to rebuild?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (85
I used the SQL*Loader on a project for about 5 months - it was very helpful.
However, I would recommend that a new version be released with something
like a section for "tips, tricks and traps". There were a few items that
are not covered in the Oracle documentation, nor the book, that would be
h
and your question is?
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> All,
> We are in transition here at my site. Our primary development tool
> over the past few years has been a client-server tool named Uniface
> from
> Compuware, which does an excellent job of protecting developers fr
Rachel Carmichael wrote:
> My last shop we had one programmer who not only expected me to tune his
> SQL, he expected me to WRITE his SQL for me. I got emails "I need a
> query that returns this information from these tables".
This guy seems to be trying a new tactic these days: DBA mailing lis
even with max processes, you should be able to log in via svrmgrl and
connect internal
that will let you do the shutdown immediate or shutdown abort you need
to to restart with more processes Edit the init.ora first, then do
shutdown and restart
or you can do a startup force, which will do t
Charlie,
I use Rman for all my backups. I like to have my database's up and
available to the users all the time.
Rman makes backup and recovery a simple process. For my production db's, I
will perform nightly Rman backups of the database and archivelog files, and
weekly Rman Validates for both
> Also appeared that you are stuck with one block size, anyone know if this
has changed?
Sybase 11.0 and prior had only 1 "page size" - 2k (except for 1 obscure
platform that i can't recall which was 4k). With 11.5(?) they added a
feature called Large I/O which allowed you to have 2k, 4k, 8k, or
Is it possible to calculate seconds using SQL?
For example, I'd like to subtract these two time to get difference in
seconds:
10:20:32 - 10:25:29
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City
Rick,
prepare for the deluge
alter index {name} rebuild tablespace {tbsname}
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, April 01, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I want to move some indexes to another tablespace.
anyone who COUNTS on a royalty check to pay basic bills is living in a
dream world. It's like the ads I hear for the Sunday NY Times Job
Market section -- this guy starts looking at penthouse apartments,
because he's read the Job Market section and KNOWS he'll have a
high-paying job in a matter o
Well, they're running the same basic product...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, March 31, 2002 7:13 PM
>
Denny,
Re the Sybase Replication server: It is a separate product and
truly an impressive piece of work.
While I was very impressed with Rep Server, the database is
what's lacking.
Jared
PS. to all: if you've never used Sybase, you haven't developed
a true appreciation for SQL*Plus.
On Su
Hello All,
I have executed the following query:
select count(1),optimizer_mode from v$sqlarea group by optimizer_mode;
And I did see many entries for Multiple Children Present ( Optimizer Mode ).
Would like to know more about this optimizer mode...
Thanks,
Madhu V Reddy
Database Support Services
Hello,
Do a rebuild; when you move the indexes they will become invalid, and you
will have to rebuild them anyway.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Monday, April 01, 2002 9:53
Hi
WHich view show when was the last rebuild of indexes?
Thx
-Seema
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
I wouldn't put it past him. But I don't recognize his name on any of
those questions :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Rachel Carmichael wrote:
>
> > My last shop we had one programmer who not only expected me to tune
> his
> > SQL, he expected me to WRITE his SQL for me. I g
Here is the URL for the PRO*C code to dump data from a query to a flat file.
http://asktom.oracle.com/pls/ask/f?p=4950:8:646297::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:459020243348,%7BSQLDA%7D
-Original Message-
Sent: Monday, April 01, 2002 11:10 AM
To: Toepke, Kevin M; '[EMAIL PROTE
Oracle does provide Export/Import. And, if you can get the data in a
delimited flat file there's always SQL*Loader.
What else do you need?
Ken
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 9:18 AM
> I've never underst
David,
Select (DateTime1 - DateTime2) * 24 * 60 * 60
>From Dual
;
Oracle date arithmetic results are in fractional days, so the above gets you
the number of seconds between two Date datatype arguments. Of course you
can go ahead and multiply 24*60*60 to get Seconds/Day, but I prefer to leave
There is code for a basic "SQL Unloader" tool available at
asktom.oracle.com. Completely dynamic. Limited support for LONGs and no
support for LOBs or objects, but generally pretty good. Does bulk fetches.
http://osi.oracle.com/~tkyte/flat/index.html
-Original Message-
Sent: Monday, Apri
Royalty... Whats that??? :-)
Amen to all of what you have just said Rachel.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Origina
whoopse. pasted the wrong URL. I'll send the correct one as soon as I can
find it.
-Original Message-
Sent: Monday, April 01, 2002 11:00 AM
To: '[EMAIL PROTECTED]'
S
There is code for a basic "SQL Unloader" tool available at
asktom.oracle.com. Completely dynamic. Limited support for LON
My oracle listener service is not working on NT. Can someone send me a
script to rebuild the listener service?
Thanks!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 53
I am running batch scripts that access remote database through database
links. I am getting a lot of processes that don't get cleared up. This is
probably due to failed connections or a database down, etc... I have exits
in the SQL scripts and in the batch scripts. How can I control this so t
Unix.
-Original Message-
Sent: Monday, April 01, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L
Hi Ron, what o/s are you on?
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 9:28 AM
> To: Multiple recipients of list ORA
Try this:
select to_date('10:20:32','hh:mi:ss') -
to_date('10:25:29', 'hh:mi:ss')
from dual
/
Viktor
--- "Nguyen, David M" <[EMAIL PROTECTED]> wrote:
> Is it possible to calculate seconds using SQL?
>
> For example, I'd like to subtract these two time
> to get difference in
> seconds:
>
>
Biggest disadvantage with utl_file is it cannot be
used to extract data on the client. You also have to
consider the effort required and the performance.
Regards,
Denny
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> - bcp out - It's time Oracle came up with some
> utility to extract the
> > is to develop a working product, and the two goals twain meet!
> --
>
> "and the two goals twain meet"
>
> twain Pronunciation Key (twn)
> n. & adj. & pron.
> Two.
>
> Perhaps you mean the two goals ner meet, as in "ner the twain
> shall meet"? Gotta run, gotta catch a twain.
> ==
Oh, I guess I'm a little slow on Monday. I've enjoyed the discussion so far.
Very close to my situation.
Given my situation - i.e., we haven't had many SQL statement problems, but
expecting to receive more with Java, I'm wondering how I can get ahead of
the game. I have worked on a set of SQL sta
Seema,
Probably Last_DDL_Time in DBA_Objects, though that just tells you the last
time any DDL was executed on the object.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED
Well, I believe changing the number of processes involves bouncing the db
anyway. IF you can't get in via svrmgrl, I've just killed client processes
(if your appserver isn't spinning out of control) until I could get in.
Otherwise I've had to take the drastic measure of killing smon or pmon or
s
The problem is getting data into a flat file.
Recently I had to direct our development group to try
out some product like PDQOUT. And that reminds me,
Sybase has nothing similar to export/import to move
the data across platforms. The only way you can do
that in Sybase is to extract the data int
Jack,
How about substracting a system date with a database replication date to get
difference of time? Can you please give me a specific command?
SQL> select to_char(sysdate, 'Dy Mon Dd HH24:MI:SS ') from dual;
TO_CHAR(SYSDATE,'DYMONDD
Mon Apr 01 11:08:00 2002
http://news.com.com/2100-1001-872266.html?legacy=cnet&tag=pt.msn.cdf.hl.ne_9576643
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Ron,
The easiest way to do that is use the Oracle Net8 Configuration Assistant.
It's under Programs/Oracle - OraHome/Network Administration and
a snap to use.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
Jack
No!
thx
-Seema
>From: "Jack C. Applewhite" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: LAST REBUILD INDEX
>Date: Mon, 01 Apr 2002 08:53:33 -0800
>
>Seema,
>
>Probably Last_DDL_Time in DBA_Objects, though that j
Hi
Drop tablespace including contents command is taking so much of time.
Is any specific reason?
Thx
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official ORACLE-L FA
Title: RE: Do programmers tune SQL?
Our developers tend to be of the 'Meet the Holy Deadline at all costs' school and
tuning is rarely perfomed; we've had some major resource issues due to bad SQL.
Our lead DBA got the idea of revising our migration process so that all SQL code migrates
fro
David,
SysDate is a function and can be referenced in any SQL statement. So you
could do the following if you want seconds between the two, or leave off
some or all of the trailing multiplicands to get fractional minutes, hours
or days.
Select ( SysDate - Next_Date ) * 24 * 60 * 60
>From User
Here is a script I recently made to help me understand how the date worked.
>>
REM Elapsed Time
define start_time = '03-25-02 11:17:12'
define stop_time = '03-27-02 12:36:30'
define date_fmt = 'mm-dd-yy hh24:mi:ss'
select trunc(to_date('&&stop_time', '&&date_fmt')
- to_date('&&
Seema,
What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in
DBA_Objects *does* show when an Index last had an "Alter Index
Rebuild" executed against it. I just now tested to verify that.
Jack
Jack C. Applewhite
Database Administrator/Developer
O
"Nguyen, David M" wrote:
>
> Jack,
>
> How about substracting a system date with a database replication date to get
> difference of time? Can you please give me a specific command?
>
> SQL> select to_char(sysdate, 'Dy Mon Dd HH24:MI:SS ') from dual;
>
> TO_CHAR(SYSDATE,'DYMONDD
>
Dennis,
I've had to keep after the Java developers here to use bind variables
instead of literals. Apparently, it's much easier for them to construct
literal SQL. They now understand the importance and use bind variable
pretty much all the time.
A few months ago they started spawning multiple
It can take
fffooorreevvveer
if you have a fragmented dictionary managed tablespace (lot's and lot's of
extents, free or used). Oracle is spending all it's time cleaning up the
sys.uet$
Brian P. MacLean
Oracle
Four years ago the only hardware striping available on EMC I was aware of
was RAID-S.
Recently researching striping ideas on EMC and was told that we can achieve
raid0+1 hardware striping on EMC.
I was told that EMC has some layer called meta-volume that is made of many
other hyper-volumes.
Told
We have a database that is currently patched to release 8.1.7.2.
I am about to install an additional product to the 8.1.7.2 Oracle Server
Home.
In this case it is "Oracle Transparent Gateway for Sybase" - but my question
is for any "additional Oracle Product" that I might install - after
performi
It works. Thank you so much, Jack.
David
-Original Message-
Sent: Monday, April 01, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
David,
Select (DateTime1 - DateTime2) * 24 * 60 * 60
>From Dual
;
Oracle date arithmetic results are in fractional days, so the above gets you
well, the number of objects in that tablespace and the number of
extents for each of these objects could definitely explain the amount
of time.
--- Seema Singh <[EMAIL PROTECTED]> wrote:
>
> Hi
> Drop tablespace including contents command is taking so much of
> time.
> Is any specific reas
Thanks for your advices, Stephane.
David
-Original Message-
Sent: Monday, April 01, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
"Nguyen, David M" wrote:
>
> Jack,
>
> How about substracting a system date with a database replication date to
get
> difference of time? Can yo
make them use Java prepared statements.
I ended up having to turn cursor sharing to force to deal with the fact
that the programmers refused to use prepared statements and insisted on
literals.
--- "Jack C. Applewhite" <[EMAIL PROTECTED]> wrote:
> Dennis,
>
> I've had to keep after the Java d
I sincerely apologize in advance if this email is bothersome to anyone.
I was just approached by another recruiter about a sql*server dba opening
here in Ft. Lauderdale. Don't know anything about relo, but if anyone is
interested here's the recruiter's email address:
[EMAIL PROTECTED]
My boss
Names change to protect the innocent/guilty, maybe?
-Original Message-
Sent: Monday, April 01, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
I wouldn't put it past him. But I don't recognize his name on any of
those questions :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
If you have successfully installed Oracle 9.0.1 on Red Hat 7.2, please
let me know what steps you had to take to make it work.
I've installed the compatibility libs and glibc stub patch for Oracle 8i,
and
have successfully installed 8.1.7.
The 9i install consistently fails on the ins_plsql.mk
If your listener.ora file is OK and you've just lost the service then go to
the C: prompt and type LSNRCTL START. This will fail,but it will have
created the service. You can then go start the service and set it up for
autostart from the SERVICES panel on the CONTROL PANEL.
Silly, but it's the
I have the good fortune? of creating two new databases on two Windows
2000 servers. I am familiar with Oracle on Solaris, but have no clue
about Windows 2000. I have installed Oracle release 8.1.7 and have
upgraded it to release 8.1.7.3. As part of the install I created the
demo database on both s
I think there's a new myth: Programmers should tune SQL.
Harrison says his book is for developers, but consider what he actually
covers. Chapter 8, Tuning Table Access, covers many topics that are for
DBA's, not developers:
-- hit rate in the buffer cache
-- db_file_multiblock_read_count
-- nu
8.1.6
>From: "Jack C. Applewhite" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: LAST REBUILD INDEX
>Date: Mon, 01 Apr 2002 10:17:42 -0800
>
>Seema,
>
>What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time
metal ink says:
From: Oracle, sivakumar saravanan 05-Mar-02 11:36
Subject: Re : Error when invoking /9.0/plsql/lib/ins_plsql.mk
Hi,
When receiving this error during installation, follow these steps:
1. Open a new console window on the host as the installation user.
2. Set up the O
first time you get the error,
open a new window go to $ORACLE_HOME/bin
look for genclntsh
vi the file, looking for -z defs, remove that part, the -z defs
./genclntsh
then hit retry, all should be good.
joe
[EMAIL PROTECTED] wrote:
> If you have successfully installed Oracle 9.0.1 on Red Hat
Kirti,
I am assuming you are still looking for some answers
to this. ( Allright I am late ..but it is because my
network is slow..;) )
Having done several conversions on HP from 32 bit
oracle to 64 bit I think I can safely say 64 bit is
the way to go.
There is a paper titled ORACLE 64-bit ADVANTA
OS: Windows NT
Oracle Database: 8.0.4
One of our production database instance OracleService
was down at least three times in a row. At this stage,
we have to restart OracleService to bring up the
database.
I saw couple of error messages in alert log file.
ORA-00600: internal error code, argume
OS: Windows NT
Oracle Database: 8.0.4
One of our production database instance OracleService
was down at least three times in a row. At this stage,
we have to restart OracleService to bring up the
database.
I saw couple of error messages in alert log file.
ORA-00600: internal error code, argume
Hi all,
Came across this on the IOUG page:
Results of the IOUG Board of Directors Election. The Winners are...
13-MAR-02
Michael Abbey - 48.5% of voters
Kimberly Floss - 45.6% of voters
Karen Langley - 41.5% of voters
Ari Kaplan - 40.3% of voters
Congratulations to the winners. Michael Abbe
And good luck when something (like OiD on 9.0.1.2) eventually gives you
grief and there's nothing even remotely close to your problem on Metaclink.
Oracle Support won't touch it.
Been there, done that.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Check the code in the trigger it seems that one of the variables is getting
assigned a value that is longer than it can hold. The ora-2 error is
user generated. Check on metalink you could be running into a bug, one of
the posters got it resolved by pinning all the packages in SGA.
Anyways, t
Thanks Ray.
Been there, done that, wish it worked. :)
Jared
Ray Stell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/01/02 12:58 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Installing
I may open a can of worms - but don't intend to...
Sometimes DBAs and Sys Admins make tuning impossible or at least
very hard for developers.
I am a developer and do a lot of tuning of statements used by our
applications. I have, in our office, the luxury of DBA access to
databases and access
Hmmm,
Think I forgot to do that last time.
I've been tinkering with the environment to get this to work.
Lotsa little 'gotchas'.
Jared
Joseph S Testa <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/01/02 01:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list
Oops. Forgot to do something.
I've been tinkering with the environment to get this to work.
9i has been mostly installed now. The OEM agent and the CTX
server both failed to link, but I don't care at the moment.
Now to try and create a database
Jared
Ray Stell <[EMAIL PROTECTED]>
Hi list,
Thanks John for the warm email. I am honored to have been elected to the
Board, and will listen and work hard to make IOUG continue to be great for
the Oracle community. There were many very strong candidates running this
year, so I know how valuable it was to have been elected.
Any com
Hi,
can you paste ora-600 trace files to list ?
"Jamadagni, Rajendra" wrote:
> Check the code in the trigger it seems that one of the variables is getting
> assigned a value that is longer than it can hold. The ora-2 error is
> user generated. Check on metalink you could be running into a b
> Congratulations to the winners. Michael Abbey, popular speaker, author,
and
> Oracle guru returns to the board.
Not to mention popular Pythian DBA! :-)
Paul
---
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementi
Hi everyone.
I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level". I disagree with their
approach, and I'd be interested to see what list members think.
The client believes that any DBA (there are about 16 on staff) should
be able to loc
Mama always said, "Anal is as anal does..."
--Forrest Gump
PS -- You're right. They're not.
> -Original Message-
> From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 4:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Seeking opinions
>
>
There is no major differences in your opinions/ideas here. Just think about
it as enforcing a naming conventions.
It's nice to have but hopefully it will last when one mount point gets
filled or slow and some files need to be created/moved somewhere else
violating the defined standards.
So come w
Blake,
When you open a command line window (aka DOS session I like to call them),
remember to issue the following statement before you try to use sqlplus:
Set oracle_sid=put_your_SID_here
e.g.
set oracle_sid=ORCL
sqlplus
Then connect internal if you can.
I like to try something like select
Yes and its a good time to look at the whole server configuration from
changes to mount points filesystem layouts swap space and just about any
other thing you and your sysadmin can look at.
A couple of years ago I had a HPUX 10-20 system that needed to be upgraded
to 11 and the end result was
Having worked mostly as a developer, the myth is that ALL programmers
should tune SQL. Poor programmers trying to tune a query just make it
unreadable. Good programmers should be able to tune, and depending on
the shop, they should be able to do it better than an DBA in some
situations (There ar
-- Paul Baumgartel <[EMAIL PROTECTED]> on 04/01/02 14:48:23 -0800
> Hi everyone.
>
> I'm currently working at a client where the OFA standard has been (as
> they put it) "taken to the next level". I disagree with their
> approach, and I'd be interested to see what list members think.
>
> T
Waleed & list,
I researched this issue recently and found out that
the meta volume was "concatenating a bunch of hyper
volume". As you know, concatenation is NOT striping.
The hyper volumes get filled with data one after
another, eventually giving you the "simulation of a
striped volume", when al
Seen that before. And it wouldn't be so bad except the DBA's were
complaining about the poor performing SQL. They blindfolded the developers,
tied their hands behind their back, to the point they could not even
generate an explain plan, much less do any tracing and use tkprof. And then
complained
1 - 100 of 119 matches
Mail list logo