His name was Magnus Lönnroth or Lonnrott or something. He moved to the
US after coming out with the WOW stuff, and help bring out the OWA or
whatever it was called.
Mladen Gogala wrote:
Mogens, do you happen to know the name of the Swedish or Norwegian
guy who wrote WOW gateway? He used to be a
Mogens, do you happen to know the name of the Swedish or Norwegian
guy who wrote WOW gateway? He used to be a member of this list. WOW
was the first thing to be able to access the oracle database through
the CGI interface. That guy was phenomenal, I believe that he has had
a part in WebIV as well.
[mailto:[EMAIL PROTECTED] *On
Behalf Of *Arup Nanda
*Sent:* Monday, August 18, 2003 11:14 AM
*To:* Multiple recipients of list ORACLE-L
*Subject:* Re: system tablespace at 50 pct_increase in 9i?
Tim, WebIV? I must have skipped a generation; I used the
OraSupport forum on CompuServ
list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: system tablespace at 50 pct_increase in 9i?
>
> Hi Mladen,
>
> Just to avoid any confusion, you have the *option* to create a LM
> System tablespace, the *default* is still DM. The ODCA uses the extent
> managemen
i did use the dbca to create this instance?
>
> From: "Richard Foote" <[EMAIL PROTECTED]>
> Date: 2003/08/18 Mon AM 10:39:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: system tablespace at 50 pct_increase in 9i?
&
[mailto:[EMAIL PROTECTED] On Behalf Of Arup
NandaSent: Monday, August 18, 2003 11:14 AMTo: Multiple
recipients of list ORACLE-LSubject: Re: system tablespace at 50
pct_increase in 9i?
Tim, WebIV? I must have skipped a generation; I
used the OraSupport forum on CompuServe before the MetaL
Title: Re: system tablespace at 50 pct_increase in 9i?
Tim, WebIV? I must have skipped a generation; I
used the OraSupport forum on CompuServe before the MetaLink. You had to
subscribe to CompuServe; and it was accessible only through dial-up; so we had
dial-up lines at our desk, had to buy
> touched System.
> >
> > you really should change system to locally managed tablespaces?
> > >
> > > From: Tim Gorman <[EMAIL PROTECTED]>
> > > Date: 2003/08/17 Sun PM 11:19:23 EDT
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTE
Title: Re: system tablespace at 50 pct_increase in 9i?
Another point of discussion - just what do you expect to gain by altering
the SYSTEM tablespace's storage params? It is not a high volume tablespace
- the O's part of I/O to this particular tablespace is very low. Alterin
Title: Re: system tablespace at 50 pct_increase in 9i?
Good point! Another war story...
Some 6 years ago, during v7.3.3 timeframe, a DBA decided to modify INITIAL, NEXT, and PCTINCREASE of everything, including stuff in SYSTEM. Unfortunately, he chose first to do this in pre-PROD (to become
ou should leave the system table space to the defaults? Ive never
touched System.
you really should change system to locally managed tablespaces?
>
> From: Tim Gorman <[EMAIL PROTECTED]>
> Date: 2003/08/17 Sun PM 11:19:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMA
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: system tablespace at 50 pct_increase in 9i?
>
> Better yet, use locally-managed SYSTEM tablespace and dispense with the
> issue altogether?
>
>
> on 8/17/03 5:39 PM, Ryan at [EMAIL PROTECTED] wrote:
>
> > any idea why ora
Title: Re: system tablespace at 50 pct_increase in 9i?
Better yet, use locally-managed SYSTEM tablespace and dispense with the issue altogether?
on 8/17/03 5:39 PM, Ryan at [EMAIL PROTECTED] wrote:
any idea why oracle has the system tablespace using 50 pct_increase in 9i? I k now it did that
Title: RE: System tablespace Oracle 9202
Isn't that the truth. GUI's don't seems to make our DBA work easier.
-Original Message-
From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 07, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subj
Which is a good reason to save scripts from DBCA as opposed to having it
create the DB for you. I always do this. I can't tell you how many times I
tried to let DBCA create the DB directly only to have it crap out for one
reason or another, and then you need to go back and plug in all the custom
va
Title: RE: System tablespace Oracle 9202
This is a UNIX Solaris running 5.8 I created the database from sqlplus using scripts. I somehow thought the default was LMT for system rather then DICTIONARY. I changed the script to LMT and recreated, but I was surprised by the Dictionary system
DBCA, by default in 92 will create SYSTEM as LMT. There is an option to do
dictionary if you prefer. CREATE DATABASE default is a dictionary managed
SYSTEM tablespace with LMT optioinal.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/6/2003 6:43 PM
What platform i
mine on Redhat Linux is LMT as well and I am certain I didn't do anything
special to create it that way.
At 04:43 PM 3/6/2003 -0800, you wrote:
What platform is this? I can't be sure (because my
laptop is miles away at the moment) but I think on 9.2
on NT when I used the creation assistant to ge
What platform is this? I can't be sure (because my
laptop is miles away at the moment) but I think on 9.2
on NT when I used the creation assistant to generate
scripts for me, SYSTEM was an lmt.
hth
connor
--- "Godlewski, Melissa"
<[EMAIL PROTECTED]> wrote: > List,
>
> System tablespace for Ora
Actually, I think the reason it's not default is because we don't
introduce something as a new default (generally!) without giving you a
release notice e.g. in reverse, we warned people more than one release
beforehand that SVRMGRL would be removed.
Pete
"Controlling developers is like herding c
Title: RE: System tablespace Oracle 9202
Metalink Note:175434.1 has some interesting information on the subject.
For example, it reminds you that if the SYSTEM tablespace is LOCAL, then you cannot create a tablespace with extent management DICTIONARY.
You can tell the database creation
lto:[EMAIL PROTECTED]Sent: Thursday, March 06, 2003
1:34 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: System tablespace Oracle 9202
Only if you use DBCA, I believe.
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DBA Handboo
Title: Message
Only if you use DBCA, I believe.
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DBA Handbook
"Oh
no, it's not. It's much harder than
that!"
Bruce
Pihlamae, long-term Oracle DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[E
It was only in 9.2 that it was possible to create the system tablespace
as locally managed, and rumour says that in 10i system tbs defaults to
locally managed.
The reason it's not default in 9.2 is most likely because..:
1. Most likely they just didn't update the DBCA default scripts to
Actually, SYSTEM is one of the only tablespaces I like to have it set on.
While I originally set it to autoextend when I was doing an upgrade I left
it active on the grounds that while I know how to recover if by some chance
one of my datafiles runs out of space, I'm uncertain as to the implication
Title: RE: System Tablespace and Autoextend
I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and
space problems when they extend, in the forums. I went to check and
mine are already set to 0 along with 2147483645 MAXEXTENTS. I created
a TAR and verified with Oracle that
I use AUTOEXTEND and it has been extremely helpful to me in managing growth.
However, my policy is not to use autoextend for SYSTEM, rollback tablespace,
or temp tablespace.
SYSTEM (for me) is relatively stable. The only time I have significant growth
in SYSTEM is during an upgrade. For rol
FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM
tablespace.
(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe on
dev and sandbox databases).
If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM
rollback) or temporary segments and the
I've been running with autoextend on (though limited to 2Gig) and never had
a problem.
-Original Message-
Sent: Thursday, October 24, 2002 5:26 PM
To: Multiple recipients of list ORACLE-L
I run my SYSTEM tablesaces in autoextend, and have for some time. I run them
that way from the poi
I run my SYSTEM tablesaces in autoextend, and have for some time. I run them
that way from the point of database creation and have never had a problem.
There were some problems with autoextend in earlier versions of 8 (and I
think they managed to migrate to early 8i versions as well) with 2GB
bound
Hello Sam
I do not know specifically about SYSTEM tablespace but from a bitter
experience beware of the 4GB limit. if a datafile on NT/2000 autoextend
beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a
production database crashing on this problem and had to call in Oracle with
Sam,
Autoextend caused tablespace corruption for me once, but it was over 5
years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS
that Oracle has ever ported to. ;-)
We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend,
even on System, has caused no pr
Sam -
I haven't made the system tablespace autoextend because I can't easily
recover the space if it overextends. I would rather take the risk that
something hits an error from a lack of space in the system tablespace. With
other tablespaces you can always rebuild the tablespace if you need to.
>From a later posting on this thread, it sounds like SYSTEM was originally
configured at that size?
Unless that wasted space is vital, chalk it up to "lessons learned", leave
the database alone (on this issue), and I'm sure you'll find a more valid
reason to recreate it in future (i.e. migrating
I did not see any performance issues , except some space issues on the box..
-Original Message-
Sent: Thursday, August 15, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L
Other than the SYSTEM tablespace consuming 10Gb of storage, are there any
indications at all that there a perf
Other than the SYSTEM tablespace consuming 10Gb of storage, are there any
indications at all that there a performance problem of any kind related to
the purported fragmentation?
Upshot: if it's not causing any problems, then just live with it; what's
not hurting you isn't hurting you. Otherwise
Paul ,
Yours is an excellent idea, but I have never implemented it in SYSTEM
tablespace.
I could see some Indexes & Tables owned by SYSTEM and OUTLN users in the
SYSTEM tablespace .. can I rebuild these indexes ??
Or can I move all objects ( tables & indexes to SYSTEM & OUTLN default
tablespaces
Rogers thanks for the mail,
I am trying to resize the datafile associated to SYSTEM and getting the
ORA-03297 error , can , what should I do to resize the datafile, I do not
want to see SYSTEM tablespace taking that much space
Thanks,
Madhu
-Original Message-
Sent: Thursday, August 15,
Ahmed,
The following is the o/p for your queries :
OWNER TABLESPACE_NAMEAllocated
MBytes
-- --
SYSSYSTEM
148.570313
SYSTEM SYSTEM
.
You've already been given the best and simplest method to defragment the
SYSTEM tablespace: export, recreate with locally
managed tablespaces, do a full import. You _could_ take a look at which SYS
objects have many extents and edit sql.bsq
**caution**caution**caution** before recreating your ne
To eliminate all confusion ( I came to know just now ) , somebody created
this tablespace with 1 MB at the time of database creation "MAY" be ,
and only 150 MB of space is consumed , remaining all wasted space. would
like to resize the SYSTEM tablespace datafile now !!!
Thanks
Madhu
-Or
Madhu,
Try these two queries to find out allocated space in SYSTEM tablespace:
select owner, tablespace_name, sum(bytes)/(1024*1024) "Allocated MBytes"
from dba_segments
where tablespace_name = 'SYSTEM'
group by owner, tablespace_name;
select tablespace_name, sum(bytes)/(1024*1024) "Total MByt
Rogers ,
If you mean to say Writing is Creating the segments , I did not see any
other user except SYS and SYSTEM users in the SYSTEM tablespace. But some
user IDs which were created for replication purpose have the
Default_tablespace as SYSTEM , but they do not have any segments in SYSTEM
tablesp
Check for 3rd party applications going in there. Peoplesoft was one that used to use
System as it's default tablespace.
Also in beginning in 11i apps 11.5.5 the patches now go in the database so System
grows quite a bit.
Kathy
-Original Message-
Sent: Thursday, August 15, 2002 11:51
Yes Steve, System tablespace was fragmented heavily and that's why its
taking 10 Gig .
The database size is 75 gig , and would you suggest me to take Full database
EXPORT and import it back after creating a new database with same structure
??
or is there any best or simple way ??
Thanks
Madhu
Madhu
some one or something is writing into your system tablespace. I would
check to see if anyone has the system tablespace as their default
tablespace.
SELECT username from dba_users where default_tablespace ='SYSTEM';
or SELECT username from dba_users where temporary_tablespace
='SYSTEM';
R
10G? Must have a lot of objects not belonging to sys/system in there.
(Unless someone turned auditing on and forgot about it.) I'd say the system
tablespace must be so fragmented that it's best to create another database
and recreate the users and import their data with default and quota set to
lo
Nah wouldn't do it! Ideally you separate everything that improves
performance and recovery chances in the event of a failure and I don't
like the idea of having code and data on the same volume spindles.
Remember that Oracle has to access the admin part of the tree to write
trace files and ale
Thanks!
-Original Message-
Sent: Friday, 5 October 2001 2:20 PM
To: Multiple recipients of list ORACLE-L
If the associated datafiles are not using AUTOEXENT feature then MAXBYTES =
0 is correct and there is no problem at all.
HTH,
- Kirti Deshpande
Verizon Information Services
If the associated datafiles are not using AUTOEXENT feature then MAXBYTES =
0 is correct and there is no problem at all.
HTH,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -Original Message-
> From: Sujatha Madan [SMTP:[EMAIL PROTECTED]]
> Sent: Thursd
seema ji,
depends on stored procedures in user schemas and also
oracle options like REPLICATION..
if you decide to create the replication code after creating the sys schema
without it..
you require around 100m of free space (8i) also if you plan to add stored
procedures/funtions
later , all tha
rtifiedCorporate & Finance Information SystemsGlaxo SmithKline> -Original Message-> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]> Sent: Tuesday, February 20, 2001 7:25 AMM> To: Multiple recipients of list ORACLE-L> Subject: Re: System Tablespace> > > Hi> > &
Sent: Tuesday, February 20, 2001 7:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: System Tablespace
>
>
> Hi
>
>
> Export entire database
> recreate database
> import entire database
>
> I believe is the
Hi
Export entire database
recreate database
import entire database
I believe is the only way to defrag system tablespace
Jack
david hill
Hi Gopal,
That was 8.1.5.
I have not tried it again since.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 7 February 2001 16:56
To: Multiple recipients of list ORACLE-L
Gautam !
If my memory serves ri
Gautam !
If my memory serves right... Steve tried this
some time back by editing sql.bsq and
got some funny ora-600s.
- Original Message -
From:
Reddy,
Gautam
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, February 06, 2001 8:10
PM
Subject: System
56 matches
Mail list logo
