We have a tool (an own-made pl/sql code generator) whose purpose
is to generate a PL/SQL Package containing one pls function for
each Table/View that has been configured in a specific repository table.
Depending on the number of table/view configured the package dimension
grows. Compiling one
You can find a little bit how it is in our organization
http://www.itsystems.lv/gints/eng/naming_conventions.htm
Gints Plivna
Tracy
Hi Imma,
This error is concerned with number of Diana nodes (PL/SQL internals) and
some other internal restrictions
of PL/SQL machine.
There is no direct relationship between appearance of PLS-00123 and size of
the package.
You can find 2 or 3 good notes on Metalink that explain the limitations
Hi,
I want to call a procedure dynamically which returns a pl/sql table (OUT
Parameter).
This is the package where the procedure is defined.
==
create or replace package body pk1 as
procedure proc1(no number, pltab out dbms_sql.varchar2_table)
as
tempdate
Probably the problem is with the DIANA dependencies of
the object that is limited to about 64k. However the
compiled version of the object called m-code has been
increasing over the releases. Therefore this also
could be a problem the chances here are less than the
DIANA thing.
Exactly look for
hi every body,
I have a user with no quota on it's temporary tablespace.
is it normal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Hi Salim,
I believe quota will appear only if he has been GRANTed some quota
explicitly. If he has been granted as
CREATE USER
..
TEMPORARY TABLESPACE ts
then quota wont appear in DBA_TS_QUOTAS
Hope this may help.
Regards,
Arul.
Djaroud Salim wrote:
hi every body,
IMHO the reason for prefixes/postfixes is so that dependent objects can be
given a more 'natural' name, that relates it to the object it depends on.
Therefore T_ is redundant because tables don't depend on anything, but V_,
T_ etc _may_ not be. Similarly, in pl/sql, you often want a procedure
Hi DBAs,
I have seen some packages / procs.. getting created with DIANA as names
while executing CATALOG / CATPROC scripts.
Does anyone have idea about it? What is special(!) about it??
Thank You.
Arul.
*
Disclaimer
This message
Hi Christian,
Didn't they remove their limitation on 64K ?
I don't have access to Metalink now, can't look at the notes.
Probably the problem is with the DIANA dependencies of
the object that is limited to about 64k. However the
compiled version of the object called m-code has been
Hi
Content d'avoir de tes nouvelles
From Oracle Documentation (Server Concept) , there is no effect of quotas on
temporary segments.
-Message d'origine-
De : Djaroud Salim [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 16 juillet 2001 09:00
À : Multiple recipients of list ORACLE-L
Objet :
HI,
If I am not mistaken ,there is no concept of granting Quotas on the
temporary tablespaces (Only on default tablespaces).
The temporary tablespace is managed by Oracle for sorting data ( if
memory sort is not possible).
Hope this helps.
shreepad
To: Shreepad
Hi,
I am using OEM 2.2.3 on window NT client 4.0
service pack 3.0 and database 8.1.5. platform HP-UX 11. I already
configure SMTP gateway and when I test this gateway through Preferences-
Notification, the test failed.Outlook mail is working on that machine(
window NT).
I need help in
Hi Erik,
Check out the dba_objects tables.
There is a column called as Last_ddl_time , which will give the ddl
time. But if you want to capture select,insert,delete,update
times ?
I guess you will have to write trigger and capture the times.
HTH
shreepad
Hi,
We had this one recently on the list.
1) This could also be caused if the user is able to change his
session level sort_area_size.
alter session set sort_area_size=size in mb ;
2) Check if the users have alter session privilege . Revoke this
privilege.
3) Check if
hi,
Moi aussi, je suis ravie .
Best Regards,
Nabila Mekkaoui
DBA Oracle
-Message d'origine-
De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 16 juillet 2001 09:46
À : Multiple recipients of list ORACLE-L
Objet : RE: Temp
Hi
Content d'avoir de tes nouvelles
IMHO the reason for prefixes/postfixes is so that dependent objects can be
given a more 'natural' name, that relates it to the object it depends on.
Therefore T_ is redundant because tables don't depend on anything, but V_,
T_ etc _may_ not be. Similarly, in pl/sql, you often want a
hi every body,
I have a user with no quota on it's temporary tablespace.
is it normal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
It is normal. You do not need quotas on temporary tablespaces. You need quotas
Hi,
On one system, while moving backup files from unix to
NT via NFS (yep state of the art backup strategy)
we had this message :
mv: cannot unlink
/SvgUnix/Oracle/Svg_J/ora_DWPQ/database/bowebi_doc_data03.dbf.Z:
No such file or directory
The file is still on the unix box, all the other files
The notes I've sent for the PLS 123 give you a briefly
idea of DIANA. However DIANA is an acronym of
Descriptive Intermediate Notation for ADA. And is an
intermedia language and uses the IDL tables for saving
the structure of tables and logic of PL/SQL program
units. In other words, is the
alter table monitoring.
--- Shreepad Vaidya [EMAIL PROTECTED]
wrote:
Hi Erik,
Check out the dba_objects tables.
There is a column called as Last_ddl_time , which
will give the ddl
time. But if you want to capture
select,insert,delete,update
times ?
I guess you will have to write
Better than my wordsthe notes themself:
Doc ID: Note:99882.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 23-FEB-2000
Last Revision Date: 13-JUN-2000
Overview
This article provides an overview of PL/SQL size
limits for the 8.1.x
Hi,
I want to return a PL/SQL Table dynamically from a pl/sql procedure
dynamically.
Here , is the package which has the procedure :
create or replace package body pk1 as
procedure proc1(no number, pltab out dbms_sql.varchar2_table)
as
tempdate date;
begin
Hi,
This is what i have gleaned from the previous discussions on the list.
As to what is actually inside these tables, here's a related extract
from the
PL/SQL docs:
PL/SQL is based on the programming language Ada. As a result, PL/SQL
uses a
variant of Descriptive Intermediate Attributed
I have an Analyze Schema running once a week for a 35G instance. The
Analyze is taking about 9 hours. This is too long. What is the opinion on
doing an Analyze on a percentage of the data? 20%? 40%?
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith,
Hi friends :
How to calculate the parameters :
Shared_pool_size, db_block_buffer, sort_area_size of Database for :
50 session simultaneous
512 MB ram
Linux
Regards.
_
Get Your Private, Free E-mail from MSN Hotmail at
please ignore
I believe that you could try and change the settings in the sqlnet.ora file
on the server side, SQLNET EXPIRE_TIME = 0. This may help:)
KK
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, July 16, 2001 2:50 AM
To: Multiple recipients of list ORACLE-L
We have a network that have
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
On 8i, use DBMS_STATS that you can do it in parallel
except for the indexes. You need to put as argument a
degree1. Also beware of the method_opt. Because the
default is 'FOR ALL COLUMNS SIZE 1'.
Regards.
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
I have an Analyze Schema running once a week
Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this
feature. Is the same that set it with huge value.
Regards.
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
I believe that you could try and change the settings
in the sqlnet.ora file
on the server side, SQLNET EXPIRE_TIME = 0. This
may
It seems you use 'compute' option of analyze command.
Try to use 'estimate' with about 45% sample of data and
then check whether the plans are still unchanged.
This solution may decrease the time you spend on analyzing
but usually keeps the precision of statistics.
Regards,
Ed
I have an
Hello
I would like to start tracing for different session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for different sessions with
different levels (not necessary diff. levels). I found that it should be
possible with dbms_support package, but i didnt find this
Hello
I would like to start tracing for different session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for different sessions with
different levels (not necessary diff. levels). I found that it should be
possible with dbms_support package, but i didnt find this package
Hi,
but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried
DBA_TAB_MODIFICATIONS...
Any init parameters to be enabled??
Arul.
Christian Trassens wrote:
However you can query the view dba_tab_modifications
for checking when and how many
Title: RE: A lazy connection!
Are any profiles implemented? I believe that's the error I get when a profile has kicked me out.
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 16,
There is not any profile defined, except default profile. There is a
problem only for the computers that has an acces with leased line. There is
other computers that has an acces using a local network and everything is
OK here.
-Original Message-
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED];
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote:
Hello
I would like to start tracing for different session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for different sessions with
different levels (not necessary diff. levels). I found that it should be
possible
You should backup all of the archivelogs if you are going to delete them and
maybe even if you are not. The redo logs contain data which is already in
the database when the backup is made so you don't need to back them up.
In my scripts I always to an 'archive log current' and backup all of
If you have just set a table as monitoring (and have no other tables
already set for this option), then you may not actually see any rows in this
table for a while. The one downfall with this option (if you want/need real
time info) is that this table may not update for some time after the
My first suspicion would be a firewall; check with your network people. I
would set the sqlnet.expire time to ten minutes to keep the firewall from
kicking idle sql*net connections.
--Michael
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 11:12 AM
To:
Andthen wait because the SMON updates it every
three hours or after an startup.
Regards.
PS: Even that you can manually wakeup the SMON through
oradebug wakeup orapid of SMON
--- JOE TESTA [EMAIL PROTECTED] wrote:
you have to turn monitoring on for each table.
alter table tablename
Or with oradebug:
oradebug setospid OS PID
oradebug event 10046 trace name context forever, level
4,8,12
--- Vladimir Begun [EMAIL PROTECTED]
wrote:
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote:
Hello
I would like to start tracing for different
session than my one. How it is
On Jul 16, 2001 at 07:12:00AM, Vladimir Begun wrote:
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote:
Hello
I would like to start tracing for different session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for different sessions with
different levels (not
Here you have:
--- Libal, Ivo [EMAIL PROTECTED] wrote:
Hello
I would like to start tracing for different
session than my one. How it is
possible in 8.1.7 EE? I want to start tracing for
different sessions with
different levels (not necessary diff. levels). I
found that it should
My best advice to you is to ignore me,
because I am a Stegosaurus standing in
the shadow created by an enormous asteriod about to land in the ocean,
creating a marine volcano, the downline
effect of which will be to obliterate
all sunlight on the planet for decades
driving the plant life to
Ivo,
See Metalink Note 1058210.6 for more details on ORADEBUG.
HTH
Srini Chavali
Oracle DBA
Cummins Inc
Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 07/16/2001
09:45:36 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
I meant that if you want to use expire_time feature,
you'll need to set it with a value greater than 0.
Remember that the value is in minutes. F.e.:
SQLNET.EXPIRE_TIME=20 .means that every twenty
minute SQL*Net or Net8 polls each connection
SQLNET.EXPIRE_TIME=0.means that SQL*NET or
Best option would be turn on the sql_trace and timed_statistice parameter
in init.ora and re-start the database.
But makes ure you have enought space to write trc files in OS
Baskar
-Original Message-
Sent: 16 July 2001 16:12
To: Multiple recipients of list ORACLE-L
On Jul 16, 2001
My first about this was about the SQLNET.EXPIRE_TIME
and I didn't look the first mail. And referring to the
question in that mail: there are two ways to forbid
the connection through TCP: protocol.ora file or
Connection Manager.
Regards.
--- Jenkins, Michael [EMAIL PROTECTED]
wrote:
My first
Which version of glibc is on RH 7.0?
If 2.2, you will need to apply a patch
from Oracle.
Aslo, I don't believe RH is a supported platform.
Jared
On Monday 16 July 2001 04:20, Rahul wrote:
List,
i'm trying to create a new instance of 8.1.6.1 on linux (red hat 7.0)
the installation goes
Title: RE: Tracing
Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate.
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL, USA
Oh it would only be cloudy for a couple of months, but yeah, your as_ would
be dead:)
-Original Message-
Sent: Monday, July 16, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
My best advice to you is to ignore me,
because I am a Stegosaurus standing in
the shadow created by an
I was under the impression that setting it to zero meant that the
connnections would wait indefinately. Like when I was receiving end of
file on communication errors setting it to 0 was suggested.
KK
-Original Message-
Trassens
Sent: Monday, July 16, 2001 11:46 AM
To: Multiple
and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1
hour upgrade ran like 16 hours, had me stumped for a while, thankfully the
upgrade scripts can be run multiple time with no impact :)
joe
[EMAIL PROTECTED] 07/16/01 12:00PM
Don't do this blindly. Turning
sql_trace
Friend :
The database will be used with :
- java applications accessing
- on line transactions by internet
- procedures schedulled ( a lot )
- pages getting data from internet
Eriovaldo
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
I am using rman on UNIX so I am not sure how it works for NT.
The rman log will have this information. You can spool it to disk.
HTH,
Ruth
--- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 11:20 AM
Hi
Does anyone have any
Hello ,
In one of our applications , we have many open implicit cursors from Oracle
Applications jobs ..
is there any way to close them?
We are running out of the max value for opened cursor parameter in init file
and we are also have
some performance issue with this one !!!
Any ideas ??
A setting of zero tells the server to never poll the connections and verify
that they are active. This allows firewalls and various other middlemen to
terminate inactive connections based on the fact that there is no sql*net
traffic coming through the network. By setting it to anything other
IMHO the reason for prefixes/postfixes. Postfixes ? Agggh! Is this
technical term? What's wrong with suffixes.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 16, 2001 2:21 AM
To: Multiple recipients of list
Hello list,
Following link explains all issues on sql/event10046 traces:
http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#sql_trace
16/7/01 07:10:35, JOE TESTA [EMAIL PROTECTED] wrote:
and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1
Is anyone familiar with how to grab space in one file system and allocate it
to another?
For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab
space from the
/u03 file system and allocate to /u06??
TIA,
Richard Huntley
--
Please see the official ORACLE-L FAQ:
Hi List,
Who can tell me what advantages/disadvantages of having private rollback
segments versus public rollback segments?
Thank you.
Lyuda Hoska
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
12/31/00
-Original Message-
Sent: Monday, July 16, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
Can anyone tell me when Oracle officially ceased providing support
for 7.3.4?
Thanks,
Jeff T
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
It really depends on what you are trying to accomplish. You can always create a
symbolic link on /u06 pointing to an item on /03.
-Original Message-
From: Richard Huntley [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
Title: 7.3.4 Support
Can anyone tell me when Oracle officially ceased providing support
for 7.3.4?
Thanks,
Jeff T
[EMAIL PROTECTED]
Hi Rukmini,
Is there any forum or mailing list for Oracle Applications?
Didn't see any replies so here you go...
http://www.oaug.org/public/oaugnet/oaugnet.html for Oracle Applications
(functional/technical)
http://www.oaug.org/public/oaugnet/oaugnet.html for Oracle Applications DBAs
Does any one know if it is possible to attach a file when using mailx to send
an email?
TIA
Yigal
Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Please see the official ORACLE-L FAQ:
Basically public rollback segment are used on OPS.
They don't need to be in init.ora and are public for
all the instances. Although it can be used on
non-parallel servers. I heard about bugs using it on
non-OPS while I was using 7.X. However I don't know
nothing about problems on 8.X.
Regards.
As far as I can remember I believe they cut it off in June of last year. Sorry,
I've been on 8.x since mid 99.
Dick Goulet
Reply Separator
Author: Thomas Jeff [EMAIL PROTECTED]
Date: 7/16/2001 10:00 AM
Can anyone tell me when Oracle officially
Lyuda,
The chief advantage of private rollback segments is that you can take them
offline if/when needed. A public rollback segment is online always consequently
making it impossible to get out of the way of batch processes or doing any kind
of maintenance on, unless your in restricted
What are you trying to do? If you need more space in a tablespace, you can create a
datafile on /u03. If you actually need additional space on /u06, you will need to
manage your drives with a DISK/Volume management software such as DiskSuite on
Solaris.
[EMAIL PROTECTED] 07/16/01 01:45PM
Dec. 31, 2000
Cherie Machler
Gelco Information Network
Thomas Jeff
Basically, my file system that stores the indx tablespace datafile is
running out of space and I need to allocate more space in order to create a
second datafile for my indexes and keep it separated from the data.
-Original Message-
Sent: Monday, July 16, 2001 2:15 PM
To: Multiple
Hello Oracle professionals,
Are there any Oracle DBA's currently looking for
work in and around London, England.
If so, send me a copy of your cv and I will do my
best to find you the right job.
We are an Oracle specialist recruitment
consultancy.
Regards
Culum SlaterManaging
Here is a simple command:
uuencode filename filename | mailx -s Here is file filename recipient
-Original Message-
From: Yigal Ran [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
Subject:UNIX mailx
Does any one know
Public and private rollback segments are like communism and capitalism.
The idea behind the public rollback segment is that any node in the cluster
that needs rollback segment can use them, but they end up being too slow.
The idea is good but the implementation is impractical, just like the
Rich, unless you know exactly the physical layout of the raid
system, keeping data and indexes separated, well the point is moot
:(
joe
[EMAIL PROTECTED] 07/16/01 03:30PM
Basically, my file system that stores the indx tablespace
datafile isrunning out of space and I need to allocate more
Hi all,
We recently upgraded a database from 815 to 816.
There is a SP which runs fine in 815 through sqlplus
or developer's application; it also runs fine using
sqlplus in 816. But when the programmer called it
through RoughWave, it shows error:
[SERVERMESSAGE] ORA-01023: Cursor context not
Ajay-
Try using the IP address for the mail server when asked to enter the SMTP
Mail Gateway.
Michael Bush
Corporate Systems
Database Administration
www.csedge.com
-Original Message-
Sent: Monday, July 16, 2001 4:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am using
Leslie Lu wrote:
Hi all,
We recently upgraded a database from 815 to 816.
There is a SP which runs fine in 815 through sqlplus
or developer's application; it also runs fine using
sqlplus in 816. But when the programmer called it
through RoughWave, it shows error:
[SERVERMESSAGE]
This morning I got a CD full of data files from a remote client database
server that went belly up. This production database (8.1.5 on NT) was put
together by a group of developers with no backups setup. They sent the CD
to me in hopes that I could recover the database. I laid the files down
Why not use DBMS_STATS? It is faster.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, July 16, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
I have an
Java use CLASSPATH, not CLASS_PATH, fyi.
-Original Message-
Sent: Monday, July 16, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L
Leslie Lu wrote:
Hi all,
We recently upgraded a database from 815 to 816.
There is a SP which runs fine in 815 through sqlplus
or developer's
Hello All,
I am currently running Oracle 816 64bit on a Solaris 8 box. I have three
databases on the system with one LISTENER for all of them. Is it possible
to configure multiple listeners, one for each database? We have tried in
the past with no success... If there is a document on the web
Friends :
I have the parameters below and we are receiving the message :
PMON: terminating instance due to error 601
Instance terminated by PMON, pid = 11300
Load Indicator not supported by OS !
Does anyone know this error ?
If i to alter all parameters MTS solve this
Chris,
1) Call Oracle
2) Lay out BIG $$$
3) import dmp file they provide into new DB
4) Go to customer site, watch file laydown cold backup.
5) Kick plenty of duhveloper ^% at site.
6) Go home, down 2 6-packs of your favorite.
Dick Goulet
Reply
A fast growing firm within 1/2 hour of Philadelphia in a
suburban New Jersey location is looking for a DBA Manager.
We are looking for someone who was a DBA and is now a strong people manager.
This person will manage about 5-7 very bright DBA's who
support Oracle, Sybase, and SQL Server, in a
Grabowy, Chris wrote:
This morning I got a CD full of data files from a remote client database
server that went belly up. This production database (8.1.5 on NT) was put
together by a group of developers with no backups setup. They sent the CD
to me in hopes that I could recover the
It is possible to define 3 listeners on 3 different ports, each one
serving another database, but why would you do dat? You have 3 little
databases and one big bad listener whichs huffs and puffs and connects
your clients to the instance of their choice. What would you benefit from
having 3
Edward,
Yes, you can setup multiple listeners. Here is an example:
LISTENERDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521))
)
)
)
LISTENERDB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
Because the more listeners you have - the better. If your damager ask you
how many listeners you are running and you answer one and he/she ( no sexizm
:-)) heard that someone running 2 or 3 ( from another moro... err damager) -
how would you explain why you are running only one.
I hope that
Mladen,
I can think of numerous reasons to have multiple listeners. For
example, imagine a server with several databases where you sometimes
wanted to restrict outside access on just one database. Meanwhile still
allowing local users on that server to access that particular database.
In
ED,
OK, looks like you've got 2 or more servers, each supporting a single DB or
are you running parallel server? I'll assume the later since that would make
more sense. Therefore, set up each listener to listen for requests on it's
hostname and port 1521 which is just about the standard.
However, to answer the question, you need to name the listeners something
other then listener and you need to have them listening on different ports.
When you use the lsnrctl command you have to reference the listener you
are dealing with.
There are reasons to have multiple listeners. For
Here is the syntax I am using:
execute dbms_utility.analyze_schema('PROD','COMPUTE');
Is there anything that might have made the analyze run so long? By the way,
we are running 7.3.4.
Ron
-Original Message-
Sent: Monday, July 16, 2001 5:32 PM
To: Multiple recipients of list ORACLE-L
Edward,
One must ask, what benefit do you perceive you will obtain from having
multiple listeners? The listener is only there to hear the end applications
request for database service and pass them along to the appropriate dedicated
server or dispatcher as required. Then it goes off to do
Really? On our approx. 200GB production DB (8.1.6 on Win2k)
DBMS_Utility.Analyze_Schema takes about an hour each morning (estimate,
sample 5%). I tried DBMS_Stats.Gather_Schema_Stats with 5% sampling a few
weeks ago and finally killed the thing after almost 3 hours and, if I
remember correctly,
We are running Veritas Cluster Server and need it to be able to shutdown and
startup the databases individually of themselves. We have the ability to
run the any of the databases on any of the servers we choose, so I can run
them on individual servers or all on the same server... I need to be
If you are using external procedures, the listener for them should be different as
well. The external procedures run under the authority of the user which started the
listener that has the sid list entry for them. If you place the entry in the main
listener and that listener is initialized
1 - 100 of 108 matches
Mail list logo