In addition to the excellent answers by others, I would like to add one
rather simple thing regarding the section below.

Create multiple tablespaces and assign objects to tablespaces based on their
expected size and behaviour. If one object needs "thousands of extents" in
a particular LMT so as to not waste a lot of space for other objects in that
LMT, then it simply should not be in the same tablespace as those other
objects!

-Don Granaman
[certifiable OraSaurus]

----- Original Message -----
From: "Cordell C. Davidson" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, August 24, 2001 4:10 PM
Subject: locally managed tablespaces


[...]
> As a matter of fact, it seems that since all exetents are the same size, a
> locally managed tablespace could easily have a thousand extents for one
> large table if the extents are sized such that the other tables in the
> tablespace are not wasting gigs of space. If so, then wouldnt the number
of
> extents cause some degradation in performance instead of the increase that
I
> keep hearing about? I can see that if the tablespace was setup for just a
> few tables that are roughly the same size but if managed properly but the
> data dictionary could manage a tablespace like this efficiently too, cant
> it?
[...]
----- Original Message -----
From: "Courtney, Patricia" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, August 23, 2001 7:21 AM
Subject: RE: Listener problem


> Go into Metalink and lookup note 69725.1 Configuring
TNSNAMES.ORA,SQLNET.ORA
> & LISTENER.ORA in net8
> Or note 69546.1 Oracle 8i - Instance Registration to Listeners
> These files all need specific entries that have to work together to get
the
> listener up and running.
> What you need to know before you start is the following
>
> What ports you want to configure the listener on (default is 1521 & 1526)
> What is the ip address or host name alias (if using an alias the ip must
be
> in the hosts file on the server)
> What default domain your are using (.world , .com) this is in the
> sqlnet.ora NAMES.DEFAULT_DOMAIN
> What is the Oracle service id (SID) a.k.a service_name.
>
>
> In the init<SID>.ora you need to set the following parameters
> Instance_name=
> Service_names= --- Note in the Listener.ora the call
> this service_name or sid_name
>
> Patricia Courtney
> (718) 694-5001
>
> -----Original Message-----
> From: Harvinder Singh [mailto:Harvinder.[Email Address Removed] Sent: Wednesday, August 22, 2001 5:17 PM
> Subject: Listener problem
>
> Hi,
>
> I am doing a fresh install of oracle 8.1.6.0.0 on win2k and it hangs at
the
> Net 8 configuration assistant at this
> step :
>
> Done parsing command line arguments.Net8 Configuration:Profile
configuration
> complete.Net8 Listener Startup:
> Running Listener Control:
> D:\Oracle\Ora81\bin\lsnrctl start LISTENER
>
> when i try to kill this process and try to see the status as:
>
> D:\Oracle\Ora81\BIN>lsnrctl
>
> LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 22-AUG-2001
> 17:12:
> 00
>
> (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
>
> Welcome to LSNRCTL, type "help" for information.
>
> LSNRCTL> status
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
> TNS-01103: Protocol specific component of the address is incorrectly
> specified
> TNS-12541: TNS:no listener
> TNS-12560: TNS:protocol adapter error
> TNS-00511: No listener
> 32-bit Windows Error: 2: No such file or directory
>
> and listener.ora looks like:
>
> # LISTENER.ORA Network Configuration File:
> D:\Oracle\Ora81\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = my_machine)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = my_machine)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
> )
>
> I am not able to start , stop or create listener again...
> what might be the problem??
>
> Thanks
> -Harvinder
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page