Hi all...
I am working on a Datawarehouse, the OLAP engine is ORACLE EXPRESS.
Whenever ORACLE EXPRESS fires a 'select' query to the oracle database, it
sets the transaction in
read only mode.
This is done by first setting the session in READ ONLY mode.
set transaction read only;
and then firing
LOBS are a pain to deal with. They take forever to import. I've put the tablespace and
table in NOLOGGING mode. Have also increased import's buffer size and recordlength. If
you find a way please let me know too.
---
From: =?iso-8859-1?q?Joshua=20Becker?=
Just a brief foot-note to this discussion.
The reason I selected the data, rather than attempted an automatic
correction, was that sometimes two words would be separated by ascii(10)
(forcing a line throw), and sometimes the corruption would appear as an
additional spurious character in a line.
A couple of comments on this. First, if you did go the route of using SRDF,
the only supported mode for Oracle databases is synchronous. That can be a
real performance hit depending on your configuration. Second, since you
mentioned RAC I assume you're on 9i and in that release you can switch
List,
Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot?
I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I need the system rebooted
Use 'shutdown now'
Then 'reboot -r' [EMAIL PROTECTED] 10/13/03 7:3
4:24
AM
List,
Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64
bit
os system. Is it init, shutdown or reboot?
I'm attempting to install Oracle 9i Release 2 on a Solaris machine.
I
received a
my company just got invited to on next month in Wash DC. Anyone know if these
will have meet or will they just be fluff? I dont want to waste my time going
to a sales pitch.
they had one last week that was just marketing. One of our guys went to it.
--
Please see the official ORACLE-L FAQ:
There was one here, in New York, last Thursday.
If whatever you've been invited to has a title that runs along the lines
of The Launch of 10g, then it's safe to say that it's probably pure
marketing.
Melanie
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 11:24 AM
Well, I guess there's something more for me to learn.
The last time I did an 11i install was more than 2.5 years ago, as a
consultant,
installing 11.5.3
Since then, I've been administering an 11.0.3 environment [alongwith 50
other databases].
Hemant
At 10:39 AM 12-10-03 -0800, you wrote:
It is
try init 6
[EMAIL PROTECTED] 10/13/03 11:04AM
Use 'shutdown now'
Then 'reboot -r'
[EMAIL PROTECTED] 10/13/03 7:34:24 AM
List,
Does anyone know the correct Solaris commands to reboot a UNIX Solaris
64 bit os system. Is it init, shutdown or reboot?
I'm attempting to install Oracle 9i Release
I assume that what Rachel is referring to is the fact that indexes will
generally not release much space when the underlying rows are deleted. They
just keep growing, so if you have a large indexed table that frequently
deletes and inserts the indexes can grow to fairly ridiculous sizes over a
Is it okay to resize datafile while user activity
is going on ? version 8.1.7.4 hp-ux .
-ak
Rajesh ,
I think in 9i dataguard this task became little easier . It doesn't take
that much time to change role of database from primary to standby and vice
versa . That's what doc says I haven't tried it myself though.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L
Hi List ,
I have a table set with pctincrease 50. After
growingmany times now it is asking for 520M of disk space and I dont have
that much space in dba_free_space . Now I want to change pctincrease to 0. So
that it doesn't have spiraling requirement . But event after changing
pctincrease
List,
We went throught an 8.1.5.0. to 8.1.7.4.0 server upgrade only (no code
changes, co app server changes oracle client 8.0), database server is AIX 4.3.3.
Before the upgrade everything was working fine, now when variables with decimal
places are passed from ASP to Oracle, they
Solaris, I believe, uses the System V shutdown command. Although you
could use init to switch to the appropriate reboot runlevel, the typical
way to reboot a Solaris system is:
# /etc/shutdown -i 6 -g 0 -y
I'll assume you haven't mucked with your inittab.
(This provides no grace period for
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress the PROMPT@path/scriptname and
PROMPT spool off statements from the report output.
The script contains both set heading off and set feedback off as part of the
formatting.
Posssible solutions?
--
Hi List,
I am looking for a tool to debug the sql procedures.
I tried with TOAD, but at times this is not working..
Any suggestions on any other tools would be great help..
Shreekanth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rama,
Hi List,
I am getting ORA-23394: duplicate propagator, but when
I execute DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR, it
says
ORA-23357: the propagator does not exist.
How do i resolve this issue? Anyhelp would be really
greatful.
Kindly see below
=
SQL connect system/[EMAIL
pl/sql developer is not bad. however, its the same debugging stuff as toad. most
debugging interfaces are generic. step into, step over, break points, etc...
From: Rama, Shreekantha (K.) [EMAIL PROTECTED]
Date: 2003/10/13 Mon PM 01:19:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Gaja,List
QUESTION IN CAPITALS BELOW :-
Thanks indeed
P.S. Welcome Back to the List . All have been missing you.
-Original Message-
Sent: Sunday, October 12, 2003 12:19 AM
To: Multiple recipients of list ORACLE-L
Vivek and list,
I don't think any reasonable person will be able to
say
Hi List:
I have a server with multiple network interfaces. When this server does
an IP address lookup, the address returned is the private backbone between
the database and application servers. The IA starts, and is listening on
this address. I am trying to query the agent from the public
dbms_output.put_line ??
joe
Rama, Shreekantha (K.) wrote:
Hi List,
I am looking for a tool to debug the sql procedures.
I tried with TOAD, but at times this is not working..
Any suggestions on any other tools would be great help..
Shreekanth
--
Please see the official ORACLE-L FAQ:
PL/SQL Developer from allround automations is the best, hands down. Go to
http://www.allroundautomations.com for a trial. It's only $150 and it's a
whole, integrated PL/SQL development environment. Fantastic program.
HTH,
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake
Hello Listers,
I'm trying to work out a solution for a client that I've not been able
to find any substantial documentation for.
Anybody familiar with the 9iAS and the PL/SQL Web Toolkit out there?
I thought I was, but a client of mine has come up with a very
interesting (and, I believe, very
I really like PL/SQL Developer
http://www.allroundautomations.com/plsqldev.html
It is only $150 and bundled licenses are even cheaper.
HTHs
Rich
-Original Message-
Rama, Shreekantha (K.)
Sent: Monday, October 13, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Hi List,
you will find the answer in the docs under 'alter table'
pay particular attention to the 'storage' clause
Jared
AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/13/2003 09:19 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Will your customer allow displaying a synonym instead of the stored
procedure name?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Melanie Caffrey
Sent: Monday, October 13, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
boxes
Hello Listers,
I'm trying to work out a
A temprary solution would be to allocat it manually, using something
like alter table emp allocate extent (size 65535M);
On Mon, 2003-10-13 at 12:19, AK wrote:
Hi List ,
I have a table set with pctincrease 50. After growing many times now
it is asking for 520M of disk space and I dont have that
What she said.
Very good tool.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, October 13, 2003
1:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Tools
Friends
:I have a part of statment as below :
select column1 from table1where column1 = v_parameter;The
column1 is not indexed, so the table full scan will be
executed.Right?Well, I would like to know if anyone knows the
resource :select column1 from table1where
column1 = v_parameter+0What does
Igor,
Possibly. I've not tried this approach. Have you? Is the synonym, in
fact, then displayed as opposed to the procedure name, in your address
line?
I am temporarily away from the testing site or I would test this out
straight away.
Thank you for your feedback.
Cheers,
Melanie
hmmm... fodder for an article I've been contemplating.
Indexes: to rebuild or not to rebuild - that is the question
There's no need to reclaim space, except in special circumstances.
As Kirti pointed out once, a sequentially incrementing numeric key is
possibly one of those circumstances.
Not
Folks,
Any good online documentation on Oracle's Table API/triggers, a deployable
component available via Oracle Designer? The documentation for this suite
of applications is poor -- in contrast to the database and iAS docs.
Thanks,
Adam
--
Please see the official ORACLE-L FAQ:
Try PL/SQL Developer from Allround Automations.
The cost is modest and the tool was developed just for Oracle.
Vicki Pierce
Database Administration
x2401
Rama, Shreekantha
(K.) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/13/2003 01:19 PM
Please respond to
[EMAIL PROTECTED]
To
I have used SQL-Programmer for several years. It was developed
by Sylvain-Faust, but they were bought out by BMC. It used to
be reasonably priced, but now BMC wants a ton of gold for it.
Good tool, but now overpriced.
We have also evaluated the SQL Navigator, Quest Software's
PL/SQL development
Friends :
I have a part of statment as below :
select column1 from table1
where column1 = v_parameter;
The column1 is not indexed, so the table full scan will be executed.
Right?
Well, I would like to know if anyone knows the resource :
select column1
Melanie,
I haven't used Web Toolkit.
Just assumed, that if it includes db call in address line, than
procedure name could be hidden, if application calls synonym created for
stored procedure.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Melanie Caffrey
Sent: Monday,
You're looking for deplorable components? There are plenty on
the market.
On Mon, 2003-10-13 at 14:44, [EMAIL PROTECTED] wrote:
Folks,
Any good online documentation on Oracle's Table API/triggers, a deployable
component available via Oracle Designer? The documentation for this suite
of
Title: Message
Jared,
Any
indexes supporting a "In-Today; Gone-Tomorrow" status table will require index
rebuilds. Most of them have monotonically increasing numbers which lends itself
to a 'holey' index... (I have a bunch of them with Oracle Apps Concurrent
Manager and Workflow tables)
Sorry -- my question was probably unclear.
Oracle Designer includes some deployable functionality known as a Table
API -- it's basically a package of procedures on the table to automate
checking and autopopulation of fields, along with triggers on various
events on the table. The key is the
perl -pe s/[[:cntrl:]]//g file_with_ctrl_chars file_without_control_chars
Robson, Peter [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/13/2003 03:49 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Tim/Dilip,
Unfortunately, as this is an 'Apps' instance, the parameters
DB_FILE_MULTIBLOCK_READ_COUNT should be set to 8 and the
OPTIMIZER_INDEX_CACHING parameter should *not* be set (letting it
default)... This is as per ML Note 216205.1 - non compliance = not
supported.
Since this is a
A week or so ago Jesse (I think) suggested a test to see whether
auto-allocate LMTs were susceptible to fragmentation, or whether the
fact that under the hood every allocation unit was 64k made this
irrelevant. The test below shows that under 9.2 creating 32 tables,
extending them until each has
Hi Melanie
you could use synonyms to hide the real names of the procedures if this
is a suitable alternative to showing procedure names but it doesn't
alter the fact that someone could then just call these synonyms if the
goal is SQL injection. You might be interested in the three papers I
wrote
Hi Pete,
Thanks much for the links to your papers!
The client has not stated as such that they'd like to hide the fact that
it is a Web toolkit based site, for the rest of the URL would still be
visible:
http://the_server/pls/the_dad/this_is_the_part_they_would_like_to_hide
It appears to be
Vivek,
I wrote:
On a related topic, I think it is relevant to mention
here that to carte-blanche curtail full-table-scans,
may not work to the long-term benefit of your
applications. However, I will assume here that you
are aware of the core point - amount of logical
I/O to be the most
You are absolutely correct for Apps 11.0.x and before. And I'm not saying
that some performance is not lost due to network latency for some ConcMgr
programs.
But it ain't as bad as it used to be, because of the steady migration away
from chatty PRO*C and Reports code to more network-friendly
what Jay said :)
in the beginning (hopefully this will have settled down), there were a
large number of deletes of daily data as the load process was refined
(ie, bugs were fixed)
--- [EMAIL PROTECTED] wrote:
I assume that what Rachel is referring to is the fact that indexes
will
generally
Richard,
Sorry for the confusion, let's see if I can clear it up a bit.
Background information:
our production database is monitored by a hosting company. This company
will extend the datafile sizes if there is less than 20% free space in
the tablespace. Each time they make a change, it counts
How essential the following tools to a DBAs job?
(viz) Rational Rose, Clear case for Versioning etc. What are Data
Modelling tools avbl. in the market and which are widely used
(other than Oracle Designer)?.
TIA
___
No banners. No pop-ups. No
You forgot perl.
On 2003.10.13 20:34, quriyat wrote:
How essential the following tools to a DBAs job?
(viz) Rational Rose, Clear case for Versioning etc. What are Data
Modelling tools avbl. in the market and which are widely used
(other than Oracle Designer)?.
TIA
If you're using Rational Rose, are you interested in UML modeling?
For if so, you might want to check out a tool created by Dulcian, Inc.
called BRIM.
http://www.dulcian.com
It's a free tool, but I do believe that you must contact them for an
initial consultation. I am not sure about all of
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Monday, October
13, 2003 11:44 said;
Solaris, I believe, uses the System V shutdown command. Although you
could use init to switch to the appropriate reboot runlevel, the typical
way to reboot a Solaris system is:
# /etc/shutdown -i 6 -g 0
I guess how important depends on what type of DBA role you are filling.
If it's a system type DBA role where your only real task is to keep the
database running and perform some basic backup / recovery type work then
understanding the intricacies of table relationships isn't very important.
If
I'd say having some sort of data modelling tool at your disposal
is pretty much essential to understanding the table layouts and
relationships for anything but the most trivial model. If you do
any sort of data modeling or database design, or if you interface with
developers, having a nice ERD
I seem to remember there were issues with DBI, DBD::Oracle and activestate 5.8.x
distros.
Can anyone (Jared?) remind me of any gotchas? (I've tried the list archive, but can't
get through at the moment). Platform is win2003, 9iR2.
Ciao
Fuzzy
:-)
--
for some reason when i created the OEM repositiory
the OEM assistant created the following username.
OEM_RYAN-2LE36OFJCE_OEMREP
I cant connect to this user, drop it or alter it
because of '-' in the name. how do i get rid of the repository and start over?
quriyat wrote:
How essential the following tools to a DBAs job?
(viz) Rational Rose, Clear case for Versioning etc. What are Data
Modelling tools avbl. in the market and which are widely used
(other than Oracle Designer)?.
TIA
The only essential DBA tool is sqlplus. Modelling tools can
Start the script from another script?
Johan Muller wrote:
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress the PROMPT@path/scriptname and
PROMPT spool off statements from the report output.
The script contains both set heading off and set feedback
Hi Tim/John,
Thanks a lot for such detailed reply. Tim, As you said, I verified the relationship
between the tables. Its two parent and one child table relationship.
John, thanks for referring that metalink note. For time being, I can use RULE hint and
make it work.
PS: Tim, 'CUT TO THE
It is not precalculated ,it will
calculate(allocate) extent when there is not enough space for your
data.
You can consider locally managed tablespace if u
are in 8i and above.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Monday,
62 matches
Mail list logo