Hi guys,
This is my test:
SQL desc emp
Name Null?Type
-
EMPNO NOT NULL CHAR(3)
NAME
We use 4Gb datafiles here as the norm without any problems at all and those
datafiles are all backed up with Legato. No problems whatsoever.
Lee
-Original Message-
Sent: 05 March 2002 03:33
To: Multiple recipients of list ORACLE-L
That being said is there anything wrong with having
- Original Message -
I have also an other question.
Do you you why they did not test postgressql ?
I bet they failed to run it on NT (not a trivial task)
Marin
...what you brought from your past, is of no use in your present. When
you must choose a new path, do not
Works nicely for us. It was a bit flakey before we had a region database,
but is rock solid now. I installed OID for a 'play' recently, and after
considerable pain I finally got the GUI running, only to find that what was
on the screen made absolutely no sense to me whatsoever. RTFM'ing had a
Hi All
I am facing a lot of problems in testing Stored Procedures and
Functions. I have many functions which requires a lot of
parameters to be passed. Even a small mistake make me lot of
retype.
Again testing everything against requires a lot of testing data.
If any good UI is available it
SQLExpert - Leccotech / Cool-Tools (;p) http://www.cool-tools.co.uk
TOAD - Toadsoft / Quest http://www.toadsoft.com
SQL Navigator (?) - Quest http://www.quest.com
PL/SQL Developer - All Round Automations http://www.allroundautomations.com
Rapid SQL - Embarcadero http://www.embarcadero.com
...
...
hello ,
I am getting a syntax error no PCC-W-02044 ,CMD-LINE,Illegal or out
of range value for option for the line below in my program:
EXEC ORACLE OPTION (MAXLITERAL=2000)
any solution for the same??
thanks.
_
Do You
-someone shoot me
Bang!! As the dart with the suction cup firmly attaches to Rachel's forehead.
;o)
-Original Message-
Sent: Monday, March 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
sigh...
someone shoot me. I am spending WAY too much time being unemployed
these
I would try select * from sonusrpt where upper(subject) like '%GENERAL%';
Might be a case issue w/ subject - if the word is General as you state above, you are
searching for general below.
Good Luck
-Original Message-
Sent: Monday, March 04, 2002 3:33 PM
To: Multiple recipients of
I use 10gb datafiles for a 1tb db and also back up using Legato. Thinking about using
Rman :)
[EMAIL PROTECTED] 03/05/02 03:18AM
We use 4Gb datafiles here as the norm without any problems at all and those
datafiles are all backed up with Legato. No problems whatsoever.
Lee
-Original
yowch! that tickles
--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
-someone shoot me
Bang!! As the dart with the suction cup firmly attaches to Rachel's
forehead.
;o)
-Original Message-
Sent: Monday, March 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
Hi Kathy,
The only thing I can think of for your original question is a bad guess on
the file size. They
guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace,
ran out again
added 50 mb again. never ran out again.
Reading other dba's minds is so much fun :-)
John
Not using the RBS tablespace as the tablespace of discussion because it
has special requirements and can create a lot of discussion.
I can fore see a reason for using multiple datafiles in a tablespace.
Lets say that you have a large table than contains information based on
dates. you load the
I've found the note. It wasn't what I remembered,
it was worse. I've just re-run a test on 9.0.1.2
that shows an interesting issue:
create table t1 (n1 number, v1 varchar2(10));
create index i1 on t1(n1) pctfree 0 initrans 10;
insert into t1
select rownum,'x'
from all_objects
where rownum =
Yes, and that's exactly what I was suspecting. Thanks for the quick
confirmation.
-rje
KG I guess you are looking in 'itc' in block dumps which shows the
KG ITL Count.
KG And yes.. There is an upper bound for number of ITLs based on the
KG block size. The transaction slots (and other
Pardon my expression, but Why in the world are you dividing by zero?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Do you know of a web site where I could research particular thought
on? I have not seen anything like that in my research. Thanks.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 8:53 PM
To: Multiple recipients of list ORACLE-L
In a UNIX system it is better to have
However, if all the disks that you are spreading the files out among
are stripped you lose that advantage do you not? We strip then mirror,
so we have multiple big strips and partition against that.
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 9:48 PM
To: Multiple
FWIW, there is a strong case for keeping consistent datafile sizes, similar
to the argument for extent sizes. This makes for easier file exchanges for
hot to not-so-hot disks, or copying the database to a new system. And
segment extent size should be kept in mind, i.e., you don't want to be
For our OLTP systems, we standardize on all data files to be 2GB (basically
for each data file we have additional two backup locations as well). Then we
use whatever amount we need and keep remaining so that data file can be
extended up to 2GB when required.
It has been working well for us, and
Hi,
We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc)
We are using read-only snaphots with multiple groups (one/schema),
replication every minute. Simple 'select *' replication.
One of the snapshot process seems to stall and all access to one of the
tables in the actual group is
Using Sql Backtrack for backups, you are able execute the backups of multiple
datafiles in parallel. Therefore, it will be faster to backup 4-1g files
rather than 1-4g file if you have the necessary hardware in place.
4:58 AM
PST
Please respond to [EMAIL PROTECTED]
Sent by:
I had the opportunity to work with a very good sys
admin. We used raw on an EMC Sym and managed it all
with Veritas. We both decided to keep our datafiles
no bigger than 1GB regardless of TS size and at least
4 datafiles per TS. We used 36GB drives in our Sym,
each divided into 9GB LUNs. Our
Ah, but we use partitioning. However, the design you described is
slightly flawed me thinks. I had to do something similar at the last
job and what we did is have a separate tablespace for each month, which
in turn produces a separate data file of course. Not that there was
anything wrong in
I agree with everyone. Oracle Names saved many days/months of maintenance
time in migrating new TNSNAMES to over 3 desktops. The only gotchas
with ON was the creation of a separate Administrative database and 24x7
maintenance of it. With the new extensibility features not requiring a
Assuming that the lob itself is in another place,
I seem to remember that the pointer in the row
is 37 bytes.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Mon, March 04, 2002 4:43 PM
To: Multiple
Hi Kim,
Ahamed Alomari (Oracle8i and Unix Performance Tuning p142-143)discusses this
in more detail. However I don't think this is more relevant with the Async
IO and multiple DB Writers.
But this is a serious issue in older versions (oracle 7 and below) because
the number of Asnyc IO thread
Title: RE: Number / 0
Sinardy
You are trying to create a function based index. To do so you need the query rewrite privilege
The index will still fail with a divide by 0 error (don't know why you are dividing by zero)
AS USER
create index wrong_logic on john(income/0) *
ERROR at line
Lee,
Be aware of bug 2220597. I believe metalink identifies other 64bit OS's,
but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug fix
available yet.
Mike Hand
Polaroid Corp
-Original Message-
Sent: Friday, March 01, 2002 3:23 AM
To: Multiple recipients of list
I am sure its been said in the notes I have not read yet but, my
biggest reason for having the multiple files is to have multiple drives.
Each file on a different drive means that the access to the file can be
spread out. Therefore you can have multiple processes accessing the files
at the
500 M for batch transactions?
--
Chris J. Guidry P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 07:28 PM
To: Multiple
Hi, I have heard and saw a demo on the top of the line
laptop from Apple, that you can download jdeveloper from the
Oracle Technet web site. Get the Linux version.
suppose to run something like ./jdeveloper with no modifications.
This might be a start for using the iMac with Oracle.
Who did the
Hello All
I saw some remarks about updating tnsnames on many desktops.
Why would you have tnsnames in every machine?
I put our client software on a central server, with the tnsnames.
One update to the tnsnames in the server apply to all.
Installing for a new PC is importing the registry entries
- Original Message -
Does someone know what command can be used to display total capacity of
disk
drive? I can use command df -k but it breaks partitions apart so I have
to add them up. I need command just display a total.
for an IDE drive do:
cat /proc/ide/xxx/capacity
Thanks Mike, I'll keep an eye out for it.
Lee
-Original Message-
Sent: 05 March 2002 15:29
To: Multiple recipients of list ORACLE-L
Lee,
Be aware of bug 2220597. I believe metalink identifies other 64bit OS's,
but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug
Disk capacity is relevant to partition. Your df -k could show 10 partitions, this
could be 10 1 drive, or 10. You might find what you need in fdisk, but use it with
caution if you aren't a unix admin.
-Original Message-
Sent: Tuesday, March 05, 2002 9:59 AM
To: Multiple recipients of
I'm trying to get a handle on the amount of memory allocated to a dedicated
server process using NT. From having examined manuals to to begin with the
terminology seems to be inconsistent. There appear to be interchangeable
references to PGA and UGA and also to Dedicated Server Process memory
I just downloaded the free version of TOAD (6.3.11.1g) and it
works without any errors on 9i. (9.0.1 on XP Prof./ DELL
8200).
Ken Janusz, CPIM
I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online'
I got corrupted indexes. I saw on metalink that it's supposed to be fixed by
8.1.7.1 - anybody using successfully now?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw John-P55297
INET:
Works great on 9.0.1
david
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Tel. (919) 466-6723
Fax (919) 466-6783
Mobile (919) 225-4962
[EMAIL PROTECTED]
http://www.arsenaldigital.com/
*** NOTICE ***
Hello,
I have used this dynamic script (on 8.1.6.x and 8.1.7.x) successfully with
no corruption, for the past two years. The script actually moves the indexes
from where they are originally built on a data tblsp to its index tblsp.
However, dropping the and tablespace_name = 'TBLSPD', will
It might be possible for someone to help you if
you include the relevent OS info ( version and service packs )
and the oracle version.
Praveen Sahni [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 11:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list
Maybe I'm an anachronism, but I've tried IDE's for programming, and
just can't seem to give up vi and sqlplus.
If you get into some real heavy duty unit testing, throw 'make' into the
mix.
Jared
Mark Leith [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/05/02 02:43 AM
Please respond to
Hi Pat,
to cut to the chase here is how we do it in our shop
..
we have :
1. East Coast: we have bunch of DB's 1 tape server
2. West Coast: we have bunch of DB's 1 tape server
Rman Strategy:
We have two catalogs, one which caters to all db's on
east coast and backs ups db's on east coast
Pat
There are several reasons to have multiple catalog, but the most
importen one is that gives the possibility to upgrade the catalog
without interfering
with other database backup's. There is as well the benefit if you at
some time is going to query the catalog using Sql you will not have
Yechiel,
That's all well and good if you get to set it up from the beginning.
I inherited it. Tnsname.ora everywhere. Different desktops with
different names for the
same databases. It's a nightmare. I plan to setup Onames when I get a
chance to do so.
Putting tnsnames.ora on
Pat,
This makes no sense to me. I have one Rman catalog for all our databases
that are at the same release level.
I can see separate Rman catalogs for different release levels, but even this
is not necessary. Lower levels of Rman work with higher levels of the Rman
repository.
Hope this
Well, I have a slightly different way of approaching file sizing. Here we
have Hatachi storage array's on a FIDI setup. We stripe several drives,
RAID, and get quite good performance.
I do NOT limit datafiles to any particular size (in production). Why?
Because I want to eliminate, as much as
Jared,
I think he is talking about direct grants. Not granting through a view.
SQL grant select on X$BH to system;
grant select on X$BH to system
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
We switched to names server last year. We had our NT administrator net use
to each client in the company (effectively assigning a drive to the
administrators machine) and copy the sqlnet.ora over to the remote
machine. Fired up about 10 machines and updated 1000 systems in three
different
I have a dedicated RMAN database (8.1.7.2) to support the RMAN catalog.
Should I run this RMAN database in cost-based or rule-base optimizer
mode ?
_
Patrick J. Howe
Oracle DBA
Illuminet Inc. (Carrier Division of Verisign)
4501 Intelco Loop SE
Olympia, WA 98507
I am fairly new to RMAN, but here is my $.02. Use a separate RMAN db for each version
of db's to be backed up (e.g. rman817, rman901, ...). In each RMAN db, I would create
a separate schema, same name as Oracle_SID for each db. This model makes scripting,
maintenance, and upgrades simple.
I have two repositories in test and will have 2 in production. One to
backup the databases (an instance unto itself) and one to backup the RMAN
instance (schema within one of the lesser instances). In a perfect world
where you have acres of dasd and unlimited everything, I guess it might be
pipe df -k to awk and sum the column you want
On Tue, 5 Mar 2002, Nguyen, David M wrote:
Does someone know what command can be used to display total capacity of disk
drive? I can use command df -k but it breaks partitions apart so I have
to add them up. I need command just display a
Hi Hemant,
I did a conversion of 4.5 forms to 6i in Windows, Motif and Web environments
simultaneously 2 years ago. I must tell you that the biggest challenge was
the Motif environment (well, I did have some challenges with the web stuff
too). Of course, we were also trying to keep everything
Has anyone taken the initial 9i OCP exam
(1Z0-007)?
I'd like your feedback.
Thanks,
Ken Janusz, CPIM
working with some folks who are frightened by anti-joins
Last Halloween I went as an anti-join. It was pretty scary.
Harrison:
Performance from the hash antijoin was dramatically better than for any
other [anti-join optimization] method we tried.
...
To take advantage of Oracle's antijoin
How was the service created? Is it set to automatically start?
Jared.Still
@radisys.com To:
Riddle me this Batman.
Assume Oracle9i...
assume you have a table thusly defined:
Table Name: TEST
col_1 number
col_2 varchar2(200)
And now a procedure defined thusly:
create or replace procedure blah_blah
( p_in_one test.col_2%type )
Now, here is the question, how much memory will
Sean,
I'm also interested in this and whilst I can't provide a definitive answer I can
provide some numbers and a script that I'm using - if anyone can point out problems or
issues with the script I'll learn and correct them.
Anyway, script is below (originally written to try to help find a
Hi ,
This is from one post in other shell group ..
I forgot who is the poster.
#! /bin/sh
year=`date +%Y`
month=`date +%m`
day=`date +%d`
# figure out what yesterday was.
day=`expr $day - 1`
case $day in
0)
month=`expr
You did not specify in, out or in out, so the default is: IN.
Parameters that are defined as IN don't get copied but are referenced
(passed by reference).
Regards,
Waleed
(I hope I'm right!)
-Original Message-
Sent: Tuesday, March 05, 2002 4:48 PM
To: Multiple recipients of list
I believe that the President of OraKnowledge (Ed Haskins) is a member of
this list.. (?)
Mark
-Original Message-
Nemeth
Sent: 05 March 2002 20:36
To: Multiple recipients of list ORACLE-L
Has anyone gone through OraKnowledge's eboot camp? If so, what are you
thoughts?
So the answer is none of the above.
-Original Message-
Sent: Tuesday, March 05, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
You did not specify in, out or in out, so the default is: IN.
Parameters that are defined as IN don't get copied but are referenced
(passed by
Bruce,
You can load Oracle Names from a tnsnames.ora file, the repository is
not required. Setting it up this way is fairly easy.
Jared
Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/05/02 03:18 PM
Please respond to ORACLE-L
To: Multiple recipients
March 5, 2002:
Relational Database Consultants, Inc. (RDC) - Proudly
announces the release of the Standby Wizard For Unix
Linux. The Standby Wizard is a GUI interface that
automates the creation, maintenance, and fail-over
functions of Oracle's standby database paradigm. With
the Standby Wizard
Please, try ORADIM command utility.
Ferry Situmorang:
Using Oracle 8.1.7 Designer 6i R4
PT Perkebunan Nusantara XIII (Persero)
Pontianak-Indonesia
http://www.ptpn13.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 10:23 PM
Kevin, let me introduce you to the world of stripping. Course, if
you are on old hardware that really isn't like it is today.
-Original Message-
Sent: Tuesday, March 05, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L
I am sure its been said in the notes I have not read yet
Sweet. Sounds like a solid setup to me.
-Original Message-
Robert
Sent: Tuesday, March 05, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Well, I have a slightly different way of approaching file sizing. Here we
have Hatachi storage array's on a FIDI setup. We stripe several
And how is this different from OEM data guard manager/broker?
joe
James Forgy wrote:
March 5, 2002:
Relational Database Consultants, Inc. (RDC) - Proudly
announces the release of the Standby Wizard For Unix
Linux. The Standby Wizard is a GUI interface that
automates the creation,
Hi All,
I have an online program that is timing out and when I trace
it I get the following at the bottom of my tkprof output. Its easy to
see why the transaction is running slow, because of all the parsing. But the
program and all called modules are compiled with max_opencursors = 75
The services are set to start automatically and version for the Oracle is
(Oracle Standard Edition 9.0.1) on windows and we open a tar with oracle
india suppport but no help as of now.
we have reinstalled Operating system (Windows Advance Server with service
pack II) and Oracle Standard Edition
I have a shell script called exfail.sh which checks for potential extent
failures on a database. The script accepts a couple of command line
switches.
exfail.sh -p -g dba apps TEST
Basically this says run the exfail.sh script against the TEST instance,
(-p) page people if there are problems,
Ian,
I'll start with some easy questions:
What version of Oracle and what OS?
Can you show the SQL being run or some of it?
What does v$session_event and v$session_wait show?
Can you reproduce it when you run the SQL called by the program from SQLPlus?
I had a problem ion 815 / NT with really
On Tue, 5 Mar 2002, Kimberly Smith wrote:
Kevin, let me introduce you to the world of stripping. Course, if
you are on old hardware that really isn't like it is today.
I was unaware of the concurrent data access benefits of stipping. I
did know about certain things being spread out, but
Fair Point,
but isn't Async I/O limited to Raw Devices only: If not using raw, many
companies don't, you can still face contention issues.
Also enabling more dbwr processes gives the overhead of more background
processes: I feel that multiple files per tablespace is a workable
compromise.
--
Anyone know what patterns are typically recognized as errors in the
listener.log file? ORA-, error etc...?
Thanks,
Ethan Post
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Forgot something the call from inside the check_all_exfail.sh script looks
like this...
exfail.sh $EXFAIL_OPTIONS $ORACLE_SID
-Original Message-
Sent: Tuesday, March 05, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
I have a shell script called exfail.sh which checks for
Hello,
How do I disbale connect sys as sysdba with a null password. Thanks.
ltiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Hallo,
anyone know knows any webpage where I can ask MsAccess questions about error messages?
Thanks in advance
Roland
--
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
Hi All
Can anyone recommend me the book for SQL/PLSQL OCP exam paper. I
would like to know the book which will be guiding me thoroughly
Amol
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nandu Garg
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
81 matches
Mail list logo