from:"Reddy, Madhusudana"


Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
Now I have a plan to reduce the size of it . And database is running on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SYSTEM TABLESPACE IS SO HUGE ?


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

-Original Message-
Sent: Thursday, August 15, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L


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
locally managed tablespace(s).


-Original Message-
Sent: Thursday, August 15, 2002 12:07 PM
To: Multiple recipients of list ORACLE-L


Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
Now I have a plan to reduce the size of it . And database is running on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SYSTEM TABLESPACE IS SO HUGE ?


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
tablespace . And there wont be any chance of creating a new object/segment
under those users.

I believe the SYSTEM tablespace was fragmented and now I would like to
resize it , would like to know best and fastest way 

Thanks 
Madhu

-Original Message-
Sent: Thursday, August 15, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L


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';

Ron
ROR mô¿ôm

 [EMAIL PROTECTED] 08/15/02 02:06PM 
Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10
gig ,
Now I have a plan to reduce the size of it . And database is running
on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very
much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SYSTEM TABLESPACE IS SO HUGE ?


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

-Original Message-
Sent: Thursday, August 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L


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 AM
To: Multiple recipients of list ORACLE-L


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
locally managed tablespace(s).


-Original Message-
Sent: Thursday, August 15, 2002 12:07 PM
To: Multiple recipients of list ORACLE-L


Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
Now I have a plan to reduce the size of it . And database is running on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SYSTEM TABLESPACE IS SO HUGE ? ( Cant shrink the datafile


Ahmed,
The following is the o/p for your queries :

OWNER  TABLESPACE_NAMEAllocated
MBytes
-- --

SYSSYSTEM
148.570313
SYSTEM SYSTEM
.6328125



TABLESPACE_NAMETotal MBytes
-- 
SYSTEM1

High Water mark for the SYSTEM tablespace is 9.6 Gig and actual size is 10
gig , so Shirking the datafile may not help me , but is there any way to
shrink the tablespace size ??

Thanks
Madhu


-Original Message-
Sent: Thursday, August 15, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


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 MBytes 
from dba_data_files
where tablespace_name = 'SYSTEM'
group by tablespace_name;

Muqthar Ahmed
DBA

-Original Message-
Sent: Thursday, August 15, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L


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
tablespace . And there wont be any chance of creating a new object/segment
under those users.

I believe the SYSTEM tablespace was fragmented and now I would like to
resize it , would like to know best and fastest way 

Thanks 
Madhu

-Original Message-
Sent: Thursday, August 15, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L


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';

Ron
ROR mô¿ôm

 [EMAIL PROTECTED] 08/15/02 02:06PM 
Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10
gig ,
Now I have a plan to reduce the size of it . And database is running
on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very
much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muqthar Ahmed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing

RE: SYSTEM TABLESPACE IS SO HUGE ?


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, 2002 3:21 PM
To: [EMAIL PROTECTED]


Madhu,
  From all that I understand about the system tablespace, There is no
easy way to defragment the system tablespace. An Export, rebuild, Import
( under the direction of Oracle Support according to the metalink notes)
is a way to defragment the system tablespace.
 #What was the initial size of the system tablespace when created? Can
you explain the increase in size? Is your performance suffering and the
users complaining?
Be sure that you do a backup of everything before you attempt to work
on defraging the system tablespace.
Good luck,
Ron
ROR mª¿ªm

 Reddy, Madhusudana [EMAIL PROTECTED] 08/15/02
03:22PM 
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
tablespace . And there wont be any chance of creating a new
object/segment
under those users.

I believe the SYSTEM tablespace was fragmented and now I would like to
resize it , would like to know best and fastest way 

Thanks 
Madhu

-Original Message-
Sent: Thursday, August 15, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L


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';

Ron
ROR mô¿ôm

 [EMAIL PROTECTED] 08/15/02 02:06PM 
Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10
gig ,
Now I have a plan to reduce the size of it . And database is running
on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be
very
much
appreciated !!

Thank in advance,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SYSTEM TABLESPACE IS SO HUGE ?


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 )..

I too do not want to touch any SYS objects ... Would like to know the
possibilities with no downtime !!!

Thanks again
Madhu


-Original Message-
Sent: Thursday, August 15, 2002 4:44 PM
To: Multiple recipients of list ORACLE-L


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 new database.

Before you do that, figure out if the tablespace is really fragmented or
just heavily used.  Each version of Oracle has required
more SYSTEM tablespace.  Oracle Apps could be filling it up.  Or you could
just have lots and lots of source code.
Take a look at dba_extents and dba_free_space to see if you have lots of
unusable space.  It's pretty conceivable, since
Oracle likes to put a 50% increase on many of its segment definitions.

If the tablespace has lots of unusable free space,  you could possibly try
reclaiming the space the way I've often had to
reclaim space in a live database with no downtime allowed.  If Oracle will
allow alter index rebuild and alter table move
on the objects (I've never tried to move anything belonging to SYS), you
could construct a tablespace map showing where
each extent begins and ends.  Hopefully you'll have an overextended index or
table sitting at the bottom of a datafile.
With nobody else able to access the database, do an alter index rebuild or
alter table move, perhaps with new storage
parameters.  With luck, you'll now have a more compressed segment and space
freed at the end of the file.  Resize the data file
to reclaim the space.  Make sure your boss knows you might have to restore
and do a point in time recovery if something goes
wrong.


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 2:18 PM


 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

 -Original Message-
 Sent: Thursday, August 15, 2002 1:51 PM
 To: Multiple recipients of list ORACLE-L


 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
 locally managed tablespace(s).


 -Original Message-
 Sent: Thursday, August 15, 2002 12:07 PM
 To: Multiple recipients of list ORACLE-L


 Hello Listers,
 We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
 Now I have a plan to reduce the size of it . And database is running on
 8.1.7.2.
 What would be the best and faster way to do it. Your ideas will be very
much
 appreciated !!

 Thank in advance,
 Madhu


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California

RE: SYSTEM TABLESPACE IS SO HUGE ?


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 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, if you can see problems
related to data dictionary or if someone desperately wants that tablespace
shrunk from 10Gb to 1Gb or less, then recreate the database...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 1:18 PM


 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

 -Original Message-
 Sent: Thursday, August 15, 2002 1:51 PM
 To: Multiple recipients of list ORACLE-L


 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
 locally managed tablespace(s).


 -Original Message-
 Sent: Thursday, August 15, 2002 12:07 PM
 To: Multiple recipients of list ORACLE-L


 Hello Listers,
 We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
 Now I have a plan to reduce the size of it . And database is running on
 8.1.7.2.
 What would be the best and faster way to do it. Your ideas will be very
much
 appreciated !!

 Thank in advance,
 Madhu


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message

HP OpenView !!!!!!

2002-08-14 Thread Reddy, Madhusudana


Hello Listers,
We have a requirement to Implement HP OpenView as a corporate standard to
monitor the Databases. I am not having any idea how to better implement this
.Can somebody out there who can help me by sending some documents or
procedure to do this . 

Thanks in advance,
Madhu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Suggestions on MV Implementation !!!!!!!

2002-06-24 Thread Reddy, Madhusudana


DG,

I am getting the following error :


ERROR at line 13:
ORA-12015: cannot create a fast refresh snapshot from a complex query

I have executed the following 

  CREATE MATERIALIZED VIEW GENRELOB_TEST
NOLOGGING
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
DISABLE QUERY REWRITE
  AS SELECT DISTINCT
'1' AS CLIP, 
LOB.LOB_ID,
LOB.LOB_CD,
GENRE.GENRE_ID,
GENRE.GENRE_DESC,
GENRE.GENRE_DESC AS INSTANCENAME
  FROM
GENRE, 
GENRE_LOB_XREF, 
LOB,
GENRE_PRODUCT_XREF
  WHERE
GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
GENRE.DSPLY_IND = 'Y'
  ORDER BY
LOB_CD,
GENRE_DESC
  ;
  

I have also created the MV Logs on the base tables as follows:

create materialized view log on bbyent.genre
with
rowid(GENRE_ID,GENRE_DESC,PARENT_GENRE_ID,REC_CREATE_TS,REC_CREATE_USER_ID,R
EC_UPD_TS,REC_UPD_USER_ID,MIGRATION_ID,DSPLY_SEQ,
DSPLY_IND)
including new values
/
create materialized view log on bbyent.lob
with
rowid(LOB_ID,LOB_CD,LOB_DESC,REC_CREATE_TS,REC_CREATE_USER_ID,REC_UPD_TS,REC
_UPD_USER_ID,MIGRATION_ID)
including new values
/
create materialized view log on bbyent.genre_product_xref
with
rowid(GENRE_ID,PRODUCT_ID,ASSOC_PREF_NBR,REC_CREATE_TS,REC_CREATE_USER_ID,RE
C_UPD_TS,REC_UPD_USER_ID,MIGRATION_ID)
including new values
/
create materialized view log on bbyent.genre_lob_xref
with
rowid(LOB_ID,GENRE_ID,REC_CREATE_TS,REC_CREATE_USER_ID,REC_UPD_TS,REC_UPD_US
ER_ID,MIGRATION_ID)
including new values
/



To FYI : my DB is running on 8.1.7.2 ( Unable to drop an existing MV , got
end of communication error )

Seems there are some limitations fro Fast Refresh...

Thanks,
Madhu



-Original Message-
Sent: Monday, June 24, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L


Madhu,

What are the problems?

Dick Goulet

Reply Separator
Author: Reddy; Madhusudana [EMAIL PROTECTED]
Date:   6/23/2002 9:03 PM

Jack , DG and ALL,
I Have problem in creating the Fast Refresh MVs, from the existing code ,
which i can not change in present situation.
So I am still looking for another option to minimize the down time( blank
web pages at the time of MV refresh ) , even by using the COMPLETE refresh .
For me space is not a problem .. 

I would like to hear some more ideas to eliminate the down time , with the
existing MVs ( Complete Refresh )

Hope i hear you all soon ,
Thanks again
Madhu




-Original Message-
Sent: Friday, June 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L


Thanks Mahu. Do you get the feeling that I might have
done that a few times? ;)

Snapshots and materialized views are the same thing. I
guess I might start calling them materialized views in
the next version or two, but it is so hard to give up
old habits.

Another thing you might need to know - you can't
easily change a job in the Oracle job queue unless you
are the owner, which means that you can't do it as
DBA.

There is a package called dbms_ijob that will allow
you to change jobs as a dba even if you don't own
them. There is usually no public synonym for this
package, so you will have to refer to it as
sys.dbms_ijob. I believe that this package is not
officially supported, so you might not find a lot of
documentation on it, but I have used it for over a
year without any problems.

To turn off a snapshot refresh, use the
sys.dbms_ijob.broken function.

*BE ADVISED*

If you unbreak a job in the Oracle job queue, it will
try to run immediately. This includes snapshot jobs.
If you unbreak a *complete* snapshot refresh job, the
first thing it does is truncate the target table.
Unbreak a complete snapshot refresh job in the middle
of the day and viola, the users suddenly have no data.
Be careful.

hth,
jack


--- Reddy, Madhusudana
[EMAIL PROTECTED] wrote:
 Jack,
 Nice picture of the whole thing .
 
 Through out your solution , mentioned SNAPSHOT , you
 mean Materialized view
 ???
 
 Thanks,
 Madhu
 
 
 
 -Original Message-
 Sent: Friday, June 21, 2002 2:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Recreate the snapshot to allow fast refresh, (you
 will
 have to create a snapshot log on your source table)
 and refresh once every 5/10/20/30 minutes.
 
 Fast refreshes are just one commit that is either
 committed or rolled back at the end. Viola, fresh
 data
 instantaneously.
 
 You can do a refresh immediate when you recreate the
 snapshots so it will build the data right away.
 
 To do it really fast, create a new snapshot with the
 correct definition, rename the old snapshot, rename
 the new snapshot to the old name, recompile your
 packages and procedures, drop the old snapshot, and
 viola, new snapshot. 
 
 Snapshots refresh via a job in the Oracle job queue.
 You can adjust timing on this job to adjust your
 refresh frequency.
 
 Make sure you get your indexes, stats, and grants in
 place on the new snap too

RE: Suggestions on MV Implementation !!!!!!!

2002-06-23 Thread Reddy, Madhusudana


Jack , DG and ALL,
I Have problem in creating the Fast Refresh MVs, from the existing code ,
which i can not change in present situation.
So I am still looking for another option to minimize the down time( blank
web pages at the time of MV refresh ) , even by using the COMPLETE refresh .
For me space is not a problem .. 

I would like to hear some more ideas to eliminate the down time , with the
existing MVs ( Complete Refresh )

Hope i hear you all soon ,
Thanks again
Madhu




-Original Message-
Sent: Friday, June 21, 2002 5:33 PM
To: Multiple recipients of list ORACLE-L


Thanks Mahu. Do you get the feeling that I might have
done that a few times? ;)

Snapshots and materialized views are the same thing. I
guess I might start calling them materialized views in
the next version or two, but it is so hard to give up
old habits.

Another thing you might need to know - you can't
easily change a job in the Oracle job queue unless you
are the owner, which means that you can't do it as
DBA.

There is a package called dbms_ijob that will allow
you to change jobs as a dba even if you don't own
them. There is usually no public synonym for this
package, so you will have to refer to it as
sys.dbms_ijob. I believe that this package is not
officially supported, so you might not find a lot of
documentation on it, but I have used it for over a
year without any problems.

To turn off a snapshot refresh, use the
sys.dbms_ijob.broken function.

*BE ADVISED*

If you unbreak a job in the Oracle job queue, it will
try to run immediately. This includes snapshot jobs.
If you unbreak a *complete* snapshot refresh job, the
first thing it does is truncate the target table.
Unbreak a complete snapshot refresh job in the middle
of the day and viola, the users suddenly have no data.
Be careful.

hth,
jack


--- Reddy, Madhusudana
[EMAIL PROTECTED] wrote:
 Jack,
 Nice picture of the whole thing .
 
 Through out your solution , mentioned SNAPSHOT , you
 mean Materialized view
 ???
 
 Thanks,
 Madhu
 
 
 
 -Original Message-
 Sent: Friday, June 21, 2002 2:33 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Recreate the snapshot to allow fast refresh, (you
 will
 have to create a snapshot log on your source table)
 and refresh once every 5/10/20/30 minutes.
 
 Fast refreshes are just one commit that is either
 committed or rolled back at the end. Viola, fresh
 data
 instantaneously.
 
 You can do a refresh immediate when you recreate the
 snapshots so it will build the data right away.
 
 To do it really fast, create a new snapshot with the
 correct definition, rename the old snapshot, rename
 the new snapshot to the old name, recompile your
 packages and procedures, drop the old snapshot, and
 viola, new snapshot. 
 
 Snapshots refresh via a job in the Oracle job queue.
 You can adjust timing on this job to adjust your
 refresh frequency.
 
 Make sure you get your indexes, stats, and grants in
 place on the new snap too. Check your synonyms as
 well.
 
 hth,
 
 jack
 
 
 
 --- Reddy, Madhusudana
 [EMAIL PROTECTED] wrote:
  Hello All,
  
  I have a set of Materialized views in my DB . we
  refresh ( COMPLETE) these
  MVs, couple of times a day. Web server (
 application
  ) will hit these MVs to
  show the data on web pages. But the complete
 Refresh
  of MVs are consuming
  much time and , at this point of time ,
 Application
  is not able to show
  right data on web pages. This is like a down time.
 I
  need some suggestions
  from you all, in order to minimize or zeroing this
  down time.
  
  The first thing I can think of is , FAST refresh ,
  but one of my Sr.DBA told
  me that the MV definition will not allow us for a
  FAST refresh( Are there
  any limitations for FAST refresh  ). Here is a
  sample MV Definition :
  
  CREATE MATERIALIZED VIEW GENRELOB
NOLOGGING
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
DISABLE QUERY REWRITE
  AS SELECT DISTINCT
'1' AS CLIP, 
LOB.LOB_ID,
LOB.LOB_CD,
GENRE.GENRE_ID,
GENRE.GENRE_DESC,
GENRE.GENRE_DESC AS INSTANCENAME
  FROM
GENRE, 
GENRE_LOB_XREF, 
LOB,
GENRE_PRODUCT_XREF
  WHERE
GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
GENRE.DSPLY_IND = 'Y'
  ORDER BY
LOB_CD,
GENRE_DESC
  ;
  
  
  My Goal is to view the FRESH data on web pages all
  the time , irrespective
  of MV Refresh. Would anybody suggest me some
 bright
  ideas , to have no or
  less down time ???
  
  Thanks in advance
  Madhu V Reddy
  
  
  -- 
  Please see the official ORACLE-L FAQ:
  http://www.orafaq.com
  -- 
  Author: Reddy, Madhusudana
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX:
  (858) 538-5051
  San Diego, California-- Public Internet
  access / Mailing Lists
 


  To REMOVE yourself from this mailing list, send an
  E

Suggestions on MV Implementation !!!!!!!


Hello All,

I have a set of Materialized views in my DB . we refresh ( COMPLETE) these
MVs, couple of times a day. Web server ( application ) will hit these MVs to
show the data on web pages. But the complete Refresh of MVs are consuming
much time and , at this point of time , Application is not able to show
right data on web pages. This is like a down time. I need some suggestions
from you all, in order to minimize or zeroing this down time.

The first thing I can think of is , FAST refresh , but one of my Sr.DBA told
me that the MV definition will not allow us for a FAST refresh( Are there
any limitations for FAST refresh  ). Here is a sample MV Definition :

CREATE MATERIALIZED VIEW GENRELOB
  NOLOGGING
  BUILD IMMEDIATE
  REFRESH COMPLETE ON DEMAND
  DISABLE QUERY REWRITE
AS SELECT DISTINCT
  '1' AS CLIP, 
  LOB.LOB_ID,
  LOB.LOB_CD,
  GENRE.GENRE_ID,
  GENRE.GENRE_DESC,
  GENRE.GENRE_DESC AS INSTANCENAME
FROM
  GENRE, 
  GENRE_LOB_XREF, 
  LOB,
  GENRE_PRODUCT_XREF
WHERE
  GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
  GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
  GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
  GENRE.DSPLY_IND = 'Y'
ORDER BY
  LOB_CD,
  GENRE_DESC
;


My Goal is to view the FRESH data on web pages all the time , irrespective
of MV Refresh. Would anybody suggest me some bright ideas , to have no or
less down time ???

Thanks in advance
Madhu V Reddy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions on MV Implementation !!!!!!!


Thanks DG,
To my understanding from your reply, Can I have a fast refresh on a MV,
which is based on multiple tables , just by having log tables on base tables
of the MV ??

And u also said  You can also set it up so that when anyone makes a change
to the base tables the
MV gets updated as part of their transaction  ... could you please shed
some more light on it ???

Thanks again
Madhu

NB: version of DB is 8.1.7.2



-Original Message-
Sent: Friday, June 21, 2002 1:24 PM
To: Reddy; Madhusudana; Multiple recipients of list ORACLE-L


Madhu,

Go tell that SrDBA to go read up on MV's.  They do support a fast
refresh,
but you have to have a log table associated with the base tables in the
view. 
You can also set it up so that when anyone makes a change to the base tables
the
MV gets updated as part of their transaction.

Dick Goulet
Senior Oracle DBA
OCP 8i

Reply Separator
Author: Reddy; Madhusudana [EMAIL PROTECTED]
Date:   6/21/2002 10:58 AM

Hello All,

I have a set of Materialized views in my DB . we refresh ( COMPLETE) these
MVs, couple of times a day. Web server ( application ) will hit these MVs to
show the data on web pages. But the complete Refresh of MVs are consuming
much time and , at this point of time , Application is not able to show
right data on web pages. This is like a down time. I need some suggestions
from you all, in order to minimize or zeroing this down time.

The first thing I can think of is , FAST refresh , but one of my Sr.DBA told
me that the MV definition will not allow us for a FAST refresh( Are there
any limitations for FAST refresh  ). Here is a sample MV Definition :

CREATE MATERIALIZED VIEW GENRELOB
  NOLOGGING
  BUILD IMMEDIATE
  REFRESH COMPLETE ON DEMAND
  DISABLE QUERY REWRITE
AS SELECT DISTINCT
  '1' AS CLIP, 
  LOB.LOB_ID,
  LOB.LOB_CD,
  GENRE.GENRE_ID,
  GENRE.GENRE_DESC,
  GENRE.GENRE_DESC AS INSTANCENAME
FROM
  GENRE, 
  GENRE_LOB_XREF, 
  LOB,
  GENRE_PRODUCT_XREF
WHERE
  GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
  GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
  GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
  GENRE.DSPLY_IND = 'Y'
ORDER BY
  LOB_CD,
  GENRE_DESC
;


My Goal is to view the FRESH data on web pages all the time , irrespective
of MV Refresh. Would anybody suggest me some bright ideas , to have no or
less down time ???

Thanks in advance
Madhu V Reddy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions on MV Implementation !!!!!!!

 after
   Direct Load to the base tables; they are not FAST refreshable
after
   conventional DML to the base tables.
   iii)Materialized views from this category can have only the
   ON DEMAND option (so, the on-commit cannot be used for this
category).

  References
  --

  Oracle8i Data Warehousing Guide : A76994-01
  [BUG:888784]
  .


 

Reddy, Madhusudana

Madhusudana.Reddy@be   To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]   
stbuy.com  cc:

Sent by:Subject: Suggestions on
MV Implementation !!! 
[EMAIL PROTECTED]

 

 

06/21/2002 02:58 PM

Please respond to

ORACLE-L

 

 





Hello All,

I have a set of Materialized views in my DB . we refresh ( COMPLETE) these
MVs, couple of times a day. Web server ( application ) will hit these MVs
to
show the data on web pages. But the complete Refresh of MVs are consuming
much time and , at this point of time , Application is not able to show
right data on web pages. This is like a down time. I need some suggestions
from you all, in order to minimize or zeroing this down time.

The first thing I can think of is , FAST refresh , but one of my Sr.DBA
told
me that the MV definition will not allow us for a FAST refresh( Are there
any limitations for FAST refresh  ). Here is a sample MV Definition :

CREATE MATERIALIZED VIEW GENRELOB
  NOLOGGING
  BUILD IMMEDIATE
  REFRESH COMPLETE ON DEMAND
  DISABLE QUERY REWRITE
AS SELECT DISTINCT
  '1' AS CLIP,
  LOB.LOB_ID,
  LOB.LOB_CD,
  GENRE.GENRE_ID,
  GENRE.GENRE_DESC,
  GENRE.GENRE_DESC AS INSTANCENAME
FROM
  GENRE,
  GENRE_LOB_XREF,
  LOB,
  GENRE_PRODUCT_XREF
WHERE
  GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
  GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
  GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
  GENRE.DSPLY_IND = 'Y'
ORDER BY
  LOB_CD,
  GENRE_DESC
;


My Goal is to view the FRESH data on web pages all the time , irrespective
of MV Refresh. Would anybody suggest me some bright ideas , to have no or
less down time ???

Thanks in advance
Madhu V Reddy


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
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
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions on MV Implementation !!!!!!!


Would you share those TONS :)- or any link to show them ..


-Original Message-
Sent: Friday, June 21, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L


There are tons of restrictions for fast refresh!

Waleed

-Original Message-
Sent: Friday, June 21, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L


Madhu,

Go tell that SrDBA to go read up on MV's.  They do support a fast
refresh,
but you have to have a log table associated with the base tables in the
view. 
You can also set it up so that when anyone makes a change to the base tables
the
MV gets updated as part of their transaction.

Dick Goulet
Senior Oracle DBA
OCP 8i

Reply Separator
Author: Reddy; Madhusudana [EMAIL PROTECTED]
Date:   6/21/2002 10:58 AM

Hello All,

I have a set of Materialized views in my DB . we refresh ( COMPLETE) these
MVs, couple of times a day. Web server ( application ) will hit these MVs to
show the data on web pages. But the complete Refresh of MVs are consuming
much time and , at this point of time , Application is not able to show
right data on web pages. This is like a down time. I need some suggestions
from you all, in order to minimize or zeroing this down time.

The first thing I can think of is , FAST refresh , but one of my Sr.DBA told
me that the MV definition will not allow us for a FAST refresh( Are there
any limitations for FAST refresh  ). Here is a sample MV Definition :

CREATE MATERIALIZED VIEW GENRELOB
  NOLOGGING
  BUILD IMMEDIATE
  REFRESH COMPLETE ON DEMAND
  DISABLE QUERY REWRITE
AS SELECT DISTINCT
  '1' AS CLIP, 
  LOB.LOB_ID,
  LOB.LOB_CD,
  GENRE.GENRE_ID,
  GENRE.GENRE_DESC,
  GENRE.GENRE_DESC AS INSTANCENAME
FROM
  GENRE, 
  GENRE_LOB_XREF, 
  LOB,
  GENRE_PRODUCT_XREF
WHERE
  GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
  GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
  GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
  GENRE.DSPLY_IND = 'Y'
ORDER BY
  LOB_CD,
  GENRE_DESC
;


My Goal is to view the FRESH data on web pages all the time , irrespective
of MV Refresh. Would anybody suggest me some bright ideas , to have no or
less down time ???

Thanks in advance
Madhu V Reddy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Suggestions on MV Implementation !!!!!!!


Jack,
Nice picture of the whole thing .

Through out your solution , mentioned SNAPSHOT , you mean Materialized view
???

Thanks,
Madhu



-Original Message-
Sent: Friday, June 21, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


Recreate the snapshot to allow fast refresh, (you will
have to create a snapshot log on your source table)
and refresh once every 5/10/20/30 minutes.

Fast refreshes are just one commit that is either
committed or rolled back at the end. Viola, fresh data
instantaneously.

You can do a refresh immediate when you recreate the
snapshots so it will build the data right away.

To do it really fast, create a new snapshot with the
correct definition, rename the old snapshot, rename
the new snapshot to the old name, recompile your
packages and procedures, drop the old snapshot, and
viola, new snapshot. 

Snapshots refresh via a job in the Oracle job queue.
You can adjust timing on this job to adjust your
refresh frequency.

Make sure you get your indexes, stats, and grants in
place on the new snap too. Check your synonyms as
well.

hth,

jack



--- Reddy, Madhusudana
[EMAIL PROTECTED] wrote:
 Hello All,
 
 I have a set of Materialized views in my DB . we
 refresh ( COMPLETE) these
 MVs, couple of times a day. Web server ( application
 ) will hit these MVs to
 show the data on web pages. But the complete Refresh
 of MVs are consuming
 much time and , at this point of time , Application
 is not able to show
 right data on web pages. This is like a down time. I
 need some suggestions
 from you all, in order to minimize or zeroing this
 down time.
 
 The first thing I can think of is , FAST refresh ,
 but one of my Sr.DBA told
 me that the MV definition will not allow us for a
 FAST refresh( Are there
 any limitations for FAST refresh  ). Here is a
 sample MV Definition :
 
 CREATE MATERIALIZED VIEW GENRELOB
   NOLOGGING
   BUILD IMMEDIATE
   REFRESH COMPLETE ON DEMAND
   DISABLE QUERY REWRITE
 AS SELECT DISTINCT
   '1' AS CLIP, 
   LOB.LOB_ID,
   LOB.LOB_CD,
   GENRE.GENRE_ID,
   GENRE.GENRE_DESC,
   GENRE.GENRE_DESC AS INSTANCENAME
 FROM
   GENRE, 
   GENRE_LOB_XREF, 
   LOB,
   GENRE_PRODUCT_XREF
 WHERE
   GENRE.GENRE_ID = GENRE_LOB_XREF.GENRE_ID AND
   GENRE_LOB_XREF.LOB_ID = LOB.LOB_ID AND
   GENRE_PRODUCT_XREF.genre_id = GENRE.genre_id AND
   GENRE.DSPLY_IND = 'Y'
 ORDER BY
   LOB_CD,
   GENRE_DESC
 ;
 
 
 My Goal is to view the FRESH data on web pages all
 the time , irrespective
 of MV Refresh. Would anybody suggest me some bright
 ideas , to have no or
 less down time ???
 
 Thanks in advance
 Madhu V Reddy
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ocp exam/when?

2002-06-20 Thread Reddy, Madhusudana

http://www.oracle.com/education/certification/index.html?dba9i_ocp.html

The above page shows ,

Candidates for Oracle9i
DBA OCP must pass the following two exams as well as completing at least one
Oracle University required hands-on course within the Oracle9i DBA learning path
to obtain your OCP credential:

check out on the page , even I am not very clear about this ... but seems
like you can not eliminate that HANDS ON from Oracle to get OCP
credential

--Madhu

-Original Message-From: Lyuda Hoska
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 20, 2002 4:06
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ocp exam/when?

Thanks. I was
scared...
I am going to take it
a step at the time and become an Associate first. To me it is a good deal you become an
Oracle certified (how sweet the sound) only after two exams. I'll move to a
next level after gaining more knowledge and taking a little break from
studying.

Just talked to a
friend of mine. He decided to
finish his 8i first and then go for upgrade (trying to avoid that exam). He is a consultant. I think my company
would pay $2000 if I asked.
Depends on the
situation...

Buy the way; do you
have any reference to Oracle official statement that it is required for
Masters only? I would appreciate
it.
Thank
you.

-Original
Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20,
2002 2:37
PMTo: [EMAIL PROTECTED]Subject: RE: ocp
exam/when?

Check out education.oracle.com and look
for certification.

the reality is unless you want to become
an Oracle Certified Master(which you have to be Oracle Certified Professional
first), then the 2K price tag will not pertain to
you.

joe

Question regarding Oracel Financials CD Pack

2002-06-18 Thread Reddy, Madhusudana


Hello ALL,

The Following is a mail from my friend , I do not have answer for it.. do
anybody have , pl share with us ...

Thanks in advance
Madhu

  -Original Message-
 From: Pai, Ashish  
 Sent: Tuesday, June 18, 2002 1:33 PM
 To:   Reddy, Madhusudana
 Subject:  Question regarding Oracel Financials CD Pack
 
 Does the Oracle Financials 11i CD Pack for Linux/Solaris come with the
 client software for Windows NT. Or do I need a windows NT client software
 or 11i Apps for windows for the client piece.
 
 Ashish Pai
 
 IS - Infrastructure DBA 
 952 324 1328
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Question regarding Oracel Financials CD Pack

2002-06-18 Thread Reddy, Madhusudana


Thanks RON,

I shall update him now ...

-Original Message-
Sent: Tuesday, June 18, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L



Apps 11.5 is purely web/java based.  There is no client install except for
the java applet.  That
said, if they are going to use other tools such as ADI, etc, then sqlnet
will need to be installed
on the client machines.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're
sober.  --William Butler
Yeats.


 

  Madhusudana.Reddy@

  bestbuy.com   To:
[EMAIL PROTECTED]

  Sent by:  cc:

  [EMAIL PROTECTED]  Subject:  Question regarding
Oracel Financials CD Pack  
 

 

  06/18/02 12:53 PM

  Please respond to

  ORACLE-L

 

 





Hello ALL,

The Following is a mail from my friend , I do not have answer for it.. do
anybody have , pl share with us ...

Thanks in advance
Madhu

  -Original Message-
 From:Pai, Ashish
 Sent:Tuesday, June 18, 2002 1:33 PM
 To:Reddy, Madhusudana
 Subject: Question regarding Oracel Financials CD Pack

 Does the Oracle Financials 11i CD Pack for Linux/Solaris come with the
 client software for Windows NT. Or do I need a windows NT client software
 or 11i Apps for windows for the client piece.

 Ashish Pai

 IS - Infrastructure DBA
 952 324 1328


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: shared pool

2002-05-22 Thread Reddy, Madhusudana



Sherman,

I found the following SQL from Tim Gorman's site...

this will create a file , which can be run to pin the objects, It Pins
CURSORS as well as the other objects ( not the tables ).

set tab off echo off feedback off timing off trimout on pause off
set trimspool on pages 0 lines 500 verify off
col instance new_value V_INSTANCE noprint
select  lower(replace(t.instance,chr(0),'')) instance
fromsys.v$threadt,
sys.v$parameter p
where   p.name = 'thread'
and t.thread# = to_number(decode(p.value,'0','1',p.value));
col sort0 noprint
col sort1 noprint
col sort2 noprint
col sort3 noprint
spool run_pin_V_INSTANCE..sql
prompt whenever sqlerror exit failure
prompt set echo on feedback on timing on pagesize 100
prompt spool run_pin_V_INSTANCE
select  decode(kept, 'YES', 'unkeep', 'keep') sort0,
type sort1,
owner sort2,
name sort3,
'exec dbms_shared_pool.' ||
decode(kept, 'YES', 'unkeep', 'keep') || '(''' ||
owner || '.' || name || ''',''' ||
decode(type,'TYPE', 'T',
'TRIGGER', 'R',
'SEQUENCE', 'Q', 'P') || ''');' text
fromsys.v$db_object_cache
where   ((executions = 100 and kept = 'NO')
or   (executions  100 and kept = 'YES'))
and type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION','TYPE',
 'TRIGGER','SEQUENCE')
union
select distinct decode(o.kept, 'YES', 'unkeep', 'keep') sort0,
o.type sort1,
o.owner sort2,
o.name sort3,
'exec dbms_shared_pool.' ||
decode(o.kept, 'YES', 'unkeep', 'keep') || '(''' ||
a.address || ', ' || a.hash_value || ''');' text
fromsys.v$db_object_cache   o,
sys.v$sqlarea   a
where   ((o.executions = 100 and o.kept = 'NO')
or   (o.executions  100 and o.kept = 'YES'))
and o.type in ('CURSOR', 'INVALID TYPE')
and a.sql_text = o.name
order by 1 desc, 2 asc, 3 asc, 4 asc;
prompt spool off
spool off
--/*REM start run_pin_V_INSTANCE*/



Thanks,
Madhu

-Original Message-
Sent: Wednesday, May 22, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


Rafiq,

I ran your query as we have been in the process of tuning our shared pool,
and I have a question. When you see many more loads than executions for a
given table, is it a safe bet that the application in question is executing
queries that have that table in the from clause, but it is not being used by
that query ? For example, a table has 33 loads and 5 executions. Could I say
that 28 loads were caused by a query that had that table referenced, but not
used (and causing a full table scan, because that's what Oracle does when
you reference, but do not use, a table (in the from clause) ?

Thank you,

Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Shared Pool Tuneup

2002-05-21 Thread Reddy, Madhusudana


Hamid,
what happens , if an object is getting executed once in a while but takes
huge sharable memory, we may not be getting full use of pinning it in the
shared pool, except wasting the memory, So we need to consider the number of
executions also. if the number of executions are high for any object/SQL,
its good idea to keep it in shared pool.

--Madhu



-Original Message-
Sent: Tuesday, May 21, 2002 2:47 PM
To: Multiple recipients of list ORACLE-L


Hi List,
I have run some scripts for Tune up shared pool,here is the result of one
script which i run :
Script:
SELECT name,sharable_mem
FROM v$db_object_cache
WHERE sharable_mem  1
AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR
TYPE = 'FUNCTION' OR
TYPE = 'PROCEDURE')
AND KEPT = 'NO'
ORDER BY 2 DESC

here is the result:

NAMESHARABLE_MEM
-   --
DBMS_JAVA   56373
DBMS_STANDARD   24405
DBMS_UTILITY24212
DBMS_SPACE_ADMIN20832
DBMS_UTILITY20508
DBMS_JAVA   15189
DBMS_OUTPUT 13063
DBMS_APPLICATION_INFO   12461
DBMS_SHARED_POOL11148
DBMS_SHARED_POOL10648

Question is, do i have to pin all of these objects in my shared_pool or NOT?
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: What makes Export slow ?

2002-05-20 Thread Reddy, Madhusudana


Would you post the parameter file ??

Huge Buffer, commit=y, direct=y, assigning the big rollback segment should
help you to have faster export ,
and also you can have a look at the DISK I/O stats ( verify the OFA is same
on both the boxes ).

Thanks,
Madhu

-Original Message-
Sent: Monday, May 20, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L


Hi guys,

I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster
processors and more memory space)

I create the database with the same script that I used to for my database in
the older machine,

When I export my database from the older machine it was very fast and when I
import to newer machine it was fast too, 

and when I export from new machine it is really slow (very slow), (I am
using same export parameters in both servers)
Can someone help with tuning tips or anything you have... : (


- The no of records are the same for both machines
- v$session_wait.seconds_in_wait is more than 1



Thank you


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: What makes Export slow ?

2002-05-20 Thread Reddy, Madhusudana


The idea of huge rollback segment is just to eliminate the contention the
rollback segment. Well its not always applicable ( possible make sure all
the other applications are not used), but we can create a big rollback
segment and bring it on line and make other rollback segments offline, and
run the export . So definitely the big rollback segment will be used.

COMMIT=Y is not a parameter for export , instead good for import , its my
mistake.

Somewhere I have read that NFS Mounted file system will make the export
slower .

Thanks for your correction,
Madhu

-Original Message-
Sent: Monday, May 20, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


On Mon, 20 May 2002, Reddy, Madhusudana wrote:

 Huge Buffer, commit=y, direct=y, assigning the big rollback segment
 should help you to have faster export ,

What do you mean assigning the big rollback segment?  How do you do
that to an export and what does it accomplish?

What does COMMIT=Y do in an export?

If I were the original poster, I'd just look at v$session_event for
the export session after several minutes of slowness.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

 -Original Message-
 Sent: Monday, May 20, 2002 3:43 AM
 To: Multiple recipients of list ORACLE-L
 
 I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster
 processors and more memory space)
 
 I create the database with the same script that I used to for my database
in
 the older machine,
 
 When I export my database from the older machine it was very fast and when
I
 import to newer machine it was fast too, 
 
 and when I export from new machine it is really slow (very slow), (I am
 using same export parameters in both servers)
 Can someone help with tuning tips or anything you have... : (
 
 
 - The no of records are the same for both machines
 - v$session_wait.seconds_in_wait is more than 1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Unix Script --- Archive Log Destination Issue

2002-05-13 Thread Reddy, Madhusudana


Hello All,
I have a script, which cleans up the archive log destination by moving the
old archive logs to a retention area based on the thresholds 
1. Percent of space utilization
2. greater than 2 days old.

The script was working fine , except for the reason , sometimes we see
multiple copies of the same. So I have added the following to code just to
stop multiple copies. But now the script is not running at all and we did
see more than 90% space utilization archive log destination.

Here is the added code:


# Exit If Already Running

function ExitIfAlreadyRunning
{
copies=`ps -ef | grep OraProcessArch | grep $SID_NAME | grep -v grep | wc
-l`
if [ $copies -gt 2 ]
then
   echo $(date) Number Of Copies Running : $copies
   exit 0
else
   return 0
fi
}

Any suggestions ???

I am not  so good in using semaphores and all , looking for a simple
solution if possible ..

Thanks in advance,
Madhu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unix Script --- Archive Log Destination Issue

2002-05-13 Thread Reddy, Madhusudana


My mistake , this new script is only working sometimes. Which is scheduled
every hour , but not working at all the hour changes .

-Original Message-
Sent: Monday, May 13, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


Hello All,
I have a script, which cleans up the archive log destination by moving the
old archive logs to a retention area based on the thresholds 
1. Percent of space utilization
2. greater than 2 days old.

The script was working fine , except for the reason , sometimes we see
multiple copies of the same. So I have added the following to code just to
stop multiple copies. But now the script is not running at all and we did
see more than 90% space utilization archive log destination.

Here is the added code:


# Exit If Already Running

function ExitIfAlreadyRunning
{
copies=`ps -ef | grep OraProcessArch | grep $SID_NAME | grep -v grep | wc
-l`
if [ $copies -gt 2 ]
then
   echo $(date) Number Of Copies Running : $copies
   exit 0
else
   return 0
fi
}

Any suggestions ???

I am not  so good in using semaphores and all , looking for a simple
solution if possible ..

Thanks in advance,
Madhu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Locks and Waits

2002-05-10 Thread Reddy, Madhusudana


Hello All,
Here is the result I have got from the v$session_event 


 SID EVENT
TIME_WAITED
 
---
  22 direct path read
109
  20 db file scattered read
125
  24 db file scattered read
160
  26 SQL*Net more data to client
162
  26 db file scattered read
191
  26 db file sequential read
230
  26 log file sync
240
  27 db file sequential read
398
  24 db file sequential read
415
  22 rdbms ipc reply
533
  20 db file sequential read
603
  24 log file sync
813
  24 latch free
904
  20 log file sync
917
  27 log file sync
966
  26 latch free
983
  27 latch free
2779
  20 latch free
3212
  22 db file scattered read
4319
  24 SQL*Net message from client
5583
  20 SQL*Net message from client
6261
  27 SQL*Net message from client
7286
  22 db file sequential read
8883
  22 latch free
16164
  26 SQL*Net message from client
56266
  26 row cache lock
6487782
  27 library cache lock
7433464
  20 library cache lock
7433918
  22 library cache lock
7435227
  24 row cache lock
7435680

Could somebody explain me , what are thsese Librarycache Lock  and Row cache
lock, and what should I do..

I could see lot of locks on the database.. and batch jobs are going very
slow , taking hours ...

Seems to me like something is happening on database, any idea ???

Pl response will be very much appreciated.

Thanks,
Madhu


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Problem in Dropping a MV : ORA-07445: exception encountered: co

2002-04-30 Thread Reddy, Madhusudana


Hello ALL,
I am having a problem in dropping an un-used Materialized view and getting
the following error when I am trying to drop 

ORA-07445: exception encountered: core dump [kkzmtab()+76] [SIGSEGV]
[Address not mapped to object] [588] [] []

I have found in metalink that it was a bug in 8.1.6 and is fixed in
8.1.7 My DB is running on 8.1.7.2

But still I am unable to drop the MV , any ideas ???

Thanks in advance,
Madhu V Reddy
Database Support Services



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem in Dropping a MV : ORA-07445: exception

2002-04-30 Thread Reddy, Madhusudana


Yes I did.

I am getting end of comunication channel error and then ORA-07445 in
alert.log

Any Idea ???

--Madhu

-Original Message-
Sent: Tuesday, April 30, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
encountered:


did you try: drop snapshot .?

Waleed

-Original Message-
Sent: Tuesday, April 30, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Hello ALL,
I am having a problem in dropping an un-used Materialized view and getting
the following error when I am trying to drop 

ORA-07445: exception encountered: core dump [kkzmtab()+76] [SIGSEGV]
[Address not mapped to object] [588] [] []

I have found in metalink that it was a bug in 8.1.6 and is fixed in
8.1.7 My DB is running on 8.1.7.2

But still I am unable to drop the MV , any ideas ???

Thanks in advance,
Madhu V Reddy
Database Support Services



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Dbms_job not running

2002-04-19 Thread Reddy, Madhusudana


If the parameters suggested are already set up right , I have one more thing
to ask...

1. is this something do with the DB Link ???
2. if so , the user running the job is having any private DBLINK ???

--Madhu

PS: If the DB LINK is used to run this job , you need to have a private
dblink created for the user running the job.

-Original Message-
Sent: Friday, April 19, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L


Hi,

We have a job own by user MTSSYS which  we scheduled to run every 1 minute
but it is not running itself.
If we run the job manully from sqlplus it runs fine.
What can be the reason that job is not running itself???
Interval is set to SYSDATE+1/1440

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Re:Import excelfile into Oracle table

2002-04-18 Thread Reddy, Madhusudana




I heard , ( I think in the same list ) ... FILE PATH can be a path to 
your NT local machine too... ( even can have multiple UTL_FILE_DIR locations on 
NT machine )

So we should be able to read a file on NT machine to load the data to the 
Oracle using UTL_FILE package.

--Madhu

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002 
  5:13 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re:Re:Import excelfile into Oracle tableHere is an example. As far as I know, utl_file package 
  reads data from unix box. So the file path below should be on Unix and be 
  careful about your rights writing or reading from this path. 
  DECLARE outfile_handle UTL_FILE.FILE_TYPE; v_test VARCHAR2(1000) ; BEGIN outfile_handle := UTL_FILE.FOPEN('FILE PATH','file_name','A'); 
  v_test := 'This is a Test ' ; 
  -- To write a line into the 
  file UTL_FILE.PUT_LINE(outfile_handle, v_test) ; -- To close the file UTL_FILE.FCLOSE (outfile_handle) ; EXCEPTION WHEN 
  UTL_FILE.INVALID_FILEHANDLE THEN DBMS_OUTPUT.PUT_LINE('Invalid File Handle'); UTL_FILE.FCLOSE_ALL; WHEN UTL_FILE.INVALID_MODE THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Mode'); WHEN UTL_FILE.INTERNAL_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Internal Error'); WHEN UTL_FILE.INVALID_OPERATION THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Operation'); WHEN UTL_FILE.INVALID_PATH THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Path'); WHEN UTL_FILE.READ_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Read Error'); WHEN UTL_FILE.WRITE_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Write Error'); WHEN NO_DATA_FOUND THEN 
  UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('No Data Found'); WHEN VALUE_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Value Error' || step || ' ' || 
  SUBSTR(V_BUFF,25,7) || step); WHEN 
  OTHERS THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Error!' || substr(sqlerrm,1,75) || step); 
  utl_file.fclose_all; END ; M.Emre HANCIOGLUMasterfoods Services GmbHISI 
  Application SupportTel : +49 2162 500-576Fax: +49 2162 
  41497E-Mail: [EMAIL PROTECTED] 
  


  
  
  [EMAIL PROTECTED] ica.se Sent by: 
[EMAIL PROTECTED] 
18.04.02 11:38 Please respond to ORACLE-L 
  
  

  
  
To: 
Multiple recipients of list 
  ORACLE-L [EMAIL PROTECTED] 
  
cc: 


  
  
Subject: 
Ang: Re:Import excelfile into 
  Oracle table  Ok, thanks 
  can you give me a good example on how to write the pl/sql 
  code?Thanks in 
  advance.Roland[EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 
  PSTSänd svar till 
  [EMAIL PROTECTED]Sänt av: 
  [EMAIL PROTECTED]Till: Multiple 
  recipients of list ORACLE-L 
  [EMAIL PROTECTED]Kopia:Hi,You'd better do the following:* Convert the excel file 
  to .csv file.* Use utl_file package to read the data and insert to Oracle 
  Tables.M.Emre 
  HANCIOGLUMasterfoods 
  GmbH--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-5051San 
  Diego, California-- Public Internet access / 
  Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from). You mayalso send the HELP command 
  for other information (like subscribing).

RE: datafile sizing ?

2002-04-18 Thread Reddy, Madhusudana


Hello Darren,ROR and all,

How about using locally managed tablespaces and allocating uniform extent
size ( say 4M ) , when we create a tablespace with multiple small datafiles
( say 500 M ) 

I would prefer to have a standard for the size of the datafile .

--Madhu

-Original Message-
Sent: Thursday, April 18, 2002 7:23 AM
To: Multiple recipients of list ORACLE-L


Darren,
 It also depends on the extent sizes you use for the tables in the
tablespace. Will each extent completely use the datafile or will there
be wasted space in the smaller datafiles. As an example: if there is 100
M free space and the extent is 150 M it will not fit in the datafile and
will use the next free space in the new datafile, wasting the 100 M free
space. That can add up to a lot of space over time. 
 Also remember to set the MAXDATAFILE to a limit allowable by the os.
once you reach the limit if it is set small you have to rebuild the
database to raise the limit. Different os's have different limits.
Ron
ROR mª¿ªm

 [EMAIL PROTECTED] 04/17/02 08:34PM 
Darren, discuss this with your SA. There may be a limit on the os side
you
need to be aware of.  

Also, consider MTTR.  Seems to me that MTTR won't be that different
between
a 500MB file and a 2GB  file.  

Beyond that, it's your comfort level. Personally I like having larger
files
for ease of administration. 

Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
954-935-4117


 -Original Message-
 From: Browett, Darren [SMTP:[EMAIL PROTECTED]] 
 Sent: Wednesday, April 17, 2002 5:48 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  datafile sizing ?
 
 I am currently building a new 8i database, and have the oppurtunity
to
 consolidate
 some of my datafiles.  In the current configuration I have 4 500Mb
 datafiles
 that make up
 a tablespace.
 
 Is it okay to create a 2Gb datafile, or am I better off to create 2
1Gb
 datafile's, or 
 stay with 4 500Mb datafiles.
 
 Thanks
 
 Darren
 
 
 

--
 --
 --
 Darren Browett P.Eng
This
message
 was transmitted
 Data Administratorusing
100%
 recycled electrons 
 Information and Communication Technology
 City of Coquitlam 
 P:(604)927 - 3614 
 E:[EMAIL PROTECTED] 

--
 --
 --- 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Browett, Darren
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY

RE: ????How to find Os Block Size????

2002-04-17 Thread Reddy, Madhusudana

 mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ????How to find Os Block Size????

2002-04-17 Thread Reddy, Madhusudana


I have ran this on a test database

bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_1.ctl

Database file: tstd1_1.ctl
Database file type: file system
Database file size: 232 8192 byte blocks
bbuxdv01:/db02/oradata/tstd1 dbfsize tstd1_0101.rlg

Database file: tstd1_0101.rlg
Database file type: file system
Database file size: 102400 512 byte blocks
bbuxdv01:/db02/oradata/tstd1 

and I also did 

ORACLE BBED1 select  lebsz from x$kccle;

  LEBSZ
 --
512
512
512
  0
  0
  0
  0
  0

 8 rows select


SO MY OS BLOCK SIZE IS  512 K , AM I RIGHT 

AND THANKS A BUNCH FOR YOUR TIME 
--MADHU




-Original Message-
Sent: Wednesday, April 17, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


Madhu,

Oracle has a fixed (at compile time) (OS) physical blocksize to work with.
That blocksize is basically the minimum blocksize the control file and the
redo log file get accessed in. So by doing 'dbfsize controlfile' you can
see
what the physical blocksize is. Or check from x$kccle.  Now Veritas or the
OS
may have some other ideas what they think is the physical blocksize.

Anjo.


Reddy, Madhusudana wrote:

 Rao,
 This following is the one I am seeing on my m/c

 ORACLE BBED1 !df -g .
 /db01  (/dev/vx/dsk/root2dg/db01): 8192 block size
 1024 frag size
 12582912 total blocks8284512 free blocks  7766758 available
 1089844 total files
  1035561 free files 53554381 filesys id
 vxfs fstype   0x0004 flag 255 filename length

 ORACLE BBED1 connect internal;
 Connected.
 ORACLE BBED1 select  lebsz from x$kccle;

  LEBSZ
 --
512
512
512
  0
  0
  0
  0
  0

 8 rows selected.

 Which one of the above is correct ???

 --Madhu

 -Original Message-
 Sent: Wednesday, April 17, 2002 9:47 AM
 To: LazyDBA.com Discussion

 login as sys and do give  this
 select  lebsz from x$kccle--w ould give the O/S block size

 Venkat

 -Original Message-
 Sent: 17 April 2002 15:40
 To: LazyDBA.com Discussion

 on unix system : df -g

 on nt : correct me if i am wrong but i think it is allways 512 bytes

 From: paresh mehta [EMAIL PROTECTED]
 To: LazyDBA.com Discussion [EMAIL PROTECTED]
 Subject: How to find Os Block Size
 Date: Wed, 17 Apr 2002 14:18:38 +
 
 Hi Friend
 thanks for help.infact i want to know the OS Block Size not DB block
size
  can u tell me from where i can get this info.??
 
 regards
 Paresh
 
 
 -Original Message-
 From: Yustiono [EMAIL PROTECTED]
 To: LazyDBA.com Discussion [EMAIL PROTECTED]
 Date: Wed, 17 Apr 2002 07:17:55 +0700
 Subject: Re: *** Urgent Help Plz ***
 
 (1) use show parameter db_block_size or  select name, value from
 v$parameter where name = 'db_block_size'; . I assume your Oracle version
 is
 prior to 9i or has uniform database size.
 (2) Yes, you can. The recovery steps depend on many things:
 - what do you lose; datafile, control file, whole database?
 - how did you make the backup; using RMAN, OS command?
 - your RAID configuration?
 
 - Original Message -
 From: paresh mehta [EMAIL PROTECTED]
 To: LazyDBA.com Discussion [EMAIL PROTECTED]
 Sent: Wednesday, April 17, 2002 1:56 AM
 Subject: *** Urgent Help Plz ***
 
 
 Hello Friends,
 I have some queries, for solving i need ur help
 (1) How can i find my OS Block Size??? is there any Dynamic Performance
 view?
 (2) Can i make complete recovery upto the time of media failure, if i
have
  * last latest cold backup
  * and set of all redo logs from last cold backup to failure time
 
 Thanking u in advance
 
 Regards
 Paresh Mehta
 
 
 
 Oracle documentation is here:
 http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
 To unsubscribe: send a blank email to [EMAIL PROTECTED]
 To subscribe:   send a blank email to [EMAIL PROTECTED]
 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 documentation is here:
 http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
 To unsubscribe: send a blank email to [EMAIL PROTECTED]
 To subscribe:   send a blank email to [EMAIL PROTECTED]
 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 documentation is here:
 http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
 To unsubscribe: send a blank email to [EMAIL PROTECTED]
 To subscribe:   send a blank email to [EMAIL PROTECTED]
 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

CSSCAN Failed

2002-04-16 Thread Reddy, Madhusudana


Hello All,
I am getting the following error , when I was trying to run the CSSCAN
utility

/usr/lib/dld.sl: Can't open shared library:
/opt/java/jre.1.1.8/lib/PA_RISC/native_threads/libjava.sl
/usr/lib/dld.sl: No such file or directory
Abort

And another Question I do have  I have my database running on
WE8ISO8859P9 character set , I am trying to upgrade a 3rd party application
running on the DB and the application document suggests that it expects
WE8ISO8859P1 character set on the database. 

As we know WE8ISO8859P9 is superset of WE8ISO8859P1 , by leaving the
database in the same WE8ISO8859P9 , will it be a problem in future ???
Your suggestions are very much needed .

Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: runInstaller problems - urgent

2002-04-15 Thread Reddy, Madhusudana


PROBLEM DESCRIPTION
---
 
AutoInstall worker failed during Oracle Applications Release 11.0
installation with the following error:

Unable to initialize threads: cannot find class java/lang/thread.
Could not create Java VM.


Configuration Information:

Product:Oracle Applications 
Version:11.0 
Platform:   Sun Sparc Solaris
Version:2.5.1
Oracle Version: 8.0.4



SEARCH WORDS:
 
adaimgr auto install thread

SOLUTION DESCRIPTION

 
The $OA_JDK_TOP/lib/rt.jar path needs to be included in the
$CLASSPATH environment variable.

The steps taken to solve this problem are as follows:

1. Include the $OA_JDK_TOP/lib/rt.jar path in the $CLASSPATH
   environment variable.

   The $CLASSPATH environment variable resided in the
   $APPL_TOP/admin/adovars.env file, and it is edited by the
   user.  Other variables such as JAVA_TOP, OA_JDK_TOP,
   OAH_TOP, and OAD_TOP are defined also in this file.

2. Export the $CLASSPATH variable to the environment.

3. Invoke the adctrl tool to label the worker that failed as
   Fixed/Restart.

4. Invoke the AutoInstall adaimgr to continue where the
   installation left off.


http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=1059189.6

--Madhu


-Original Message-
Sent: Monday, April 15, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L


Hi,

I'm trying to get the runInstaller working ... I've done this a million and
one times, but for some reason, tonight of all nights it doesn't want to
run.

It keeps saying: 

Initializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please
wait...
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM

I've got the CLASSPATH set to $ORACLE_HOME/jdbc/lib/classes111.zip

I'm running 8.1.7 on HP-UX

Please help.

Thanks

--- 
Sujatha Madan 
Database Administrator 
Custom Management Centre 
Optus Business Operations 
'yes' OPTUS
PH # +61 2 9775 5316 
Mobile # +61 402 354 347 
FAX # +61 2 9775 5360 
Email [EMAIL PROTECTED]  
WEB http://www.optusbusiness.com.au/ 
--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Product_User_profile

2002-04-14 Thread Reddy, Madhusudana



Hello List,
I am having a problem when I am connecting to the database using a normal
user. ( Pl see below )
I have executed the pupbld.sql as SYSTEM user. But still getting the error,
but I am able to connect to database and run some queries.
Why I am seeing this message again and again , any idea 

+++
here is the error:
__

Enter user-name: ccadmin
Enter password: 
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
+++

Thanks,
Madhu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Product_User_profile

2002-04-14 Thread Reddy, Madhusudana


Done !!

I have found that the the objects created by SYSTEM user is defaulting to a
tablespace which is not there, i have altered the user SYSTEM and ran the
PUPBLD.SQL again and it worked. 

--Madhu

 -Original Message-
 From: Ray Stell [SMTP:[EMAIL PROTECTED]]
 Sent: Sunday, April 14, 2002 8:18 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Product_User_profile
 
 On Sun, Apr 14, 2002 at 03:18:17PM -0800, Reddy, Madhusudana wrote:
  
  Enter user-name: ccadmin
  Enter password: 
  Error accessing PRODUCT_USER_PROFILE
  Warning:  Product user profile information not loaded!
  You may need to run PUPBLD.SQL as SYSTEM
 -- 
 
 
 Note:1019310.102 ( edited to run in the alotted time ) 
 Type:  PROBLEM 
 Status:  PUBLISHED 
  Content Type:  TEXT/PLAIN 
 Creation Date:  03-NOV-1999 
 Last Revision Date:  22-JAN-2002 
 
 Problem Description:
 
  
 You are receiving the following warning message when starting a SQL*Plus 
 session:
 
   WARNING-PRODUCT USER PROFILE INFORMATION NOT LOADED 
 
 
 
 If you have run the PUPBLD.SQL script and are still receiving this
 warning, 
 then do the following: 
   
 Connect as user system, drop the PRODUCT_PRIVS view and rerun the
 PUPBLD.SQL 
 script. 
 
  
 Explanation:
 
 
 SQL*Plus reads product restrictions from the PRODUCT_USER_PROFILE table
 when a
 user logs in to SQL*Plus, and maintains those restrictions for the
 duration of
 the session.  Changes to PRODUCT_USER_PROFILE will only take effect the
 next
 time the affected users login to SQL*Plus.  If the PRODUCT_USER_PROFILE
 table is
 created incorrectly, all users other than SYSTEM will see a warning when
 connecting to Oracle from SQL*Plus, that the PRODUCT_USER_PROFILE
 information
 is not loaded.  This message is a warning you that the
 PRODUCT_USER_PROFILE 
 table has not been built in the SYSTEM account.
 
 Running the SQL script PUPBLD.SQL ( or V7PUP.SQL on some platforms)
 will 
 build the PRODUCT_USER_PROFILE table, thus avioding the warning message.
 .
 --
 --
  
  Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal
 Notices and Terms of Use. 
 ===
 Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ray Stell
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 1Z0-007 Exam

2002-04-12 Thread Reddy, Madhusudana




Its not a Upgrade exam.. in fact its the first exam in Oracle 9i OCP core 
series

  -Original Message-From: John Hallas 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, April 12, 2002 
  12:58 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: 1Z0-007 Exam
  
  Ken,
  If 
  this is the 9i upgrade exam then there was a discussion on this recently 
  (about 3-4 weeks ago)
  Search 
  the archives for a post by Mike Hateley and responses from Robert 
  Freeman.
  If 
  is not the 9i upgrade which exam is it?
  
  John
  
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of KENNETH JANUSZSent: 12 April 2002 16:26To: Multiple recipients of list 
  ORACLE-LSubject: 1Z0-007 
  Exam
  
  Has anyone 
  taken this exam? If so, I would like your feedback.
  
  Thanks,
  Ken Janusz, 
  CPIM

OEM Error On Unix


Hell All,
I am seeing the following error , when I am trying to start OEM console on
HP Unix. Any Idea , what I am missing and would like to know , what is this
Management server and how to start it on HP Unix .. Thanks in advance



 ...OLE_Obj... 


Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM Error On Unix


Oops !!! Error message is missing ,
here is the error:

VTK-1000: Unable to connect to the management server server.mydomain.com.
Please verify that you have entered the correct host name and the status of
the Oracle Management Server.


Thanks
Madhu

-Original Message-
Sent: Thursday, April 11, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


Hell All,
I am seeing the following error , when I am trying to start OEM console on
HP Unix. Any Idea , what I am missing and would like to know , what is this
Management server and how to start it on HP Unix .. Thanks in advance



 ...OLE_Obj... 


Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM Error On Unix


I could not see this on HP-UNIX client ( $OH/bin ) where I have installed
all the Oracle Client ( Administration ),
Would you let me know the location , where I can find this on UNIX

--Madhu

-Original Message-
Sent: Thursday, April 11, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L


Try

oemctrl start oms



-Original Message-
Sent: Thursday, April 11, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


Hell All,
I am seeing the following error , when I am trying to start OEM console on
HP Unix. Any Idea , what I am missing and would like to know , what is this
Management server and how to start it on HP Unix .. Thanks in advance



 ...OLE_Obj... 


Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORACLE 9i doesn't start on Linux


try this :
svrmgrl  connect internal;

svrmgrl  startup;

Then you should be able to see the error message and post that message here

--Madhu

-Original Message-
Sent: Thursday, April 11, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L



Hi,


I've installed Oracle 9i on Suse Linux 7.1.

The lsnrctl starts nicely, however when I type dbstart then
it does absolutelly nothing.
No error message, but the database won't start.

Any ideas?


Thank you in advance

Zsolt Csillag,
Hungary
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Zsolt Csillag
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Currently log-in users


users and what they are doing ?


select v2.sid, v2.username, v2.machine, v2.program, v1.sql_text
from  V$sql v1, V$session v2
where (v1.address = v2.sql_address or
   v1.address = v2.prev_sql_addr)
and v2.username is not null
ORDER BY 1




---Madhu


-Original Message-
Sent: Thursday, April 11, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L



I'm sure that everyone is sending you their version of this:
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername format a8 heading 'Process|User'
column terminal format a14 heading 'Terminal'
column pprogram format a26 heading 'Process program'
column susername format a8 heading 'Session|User'
column server format a9 heading 'Server'
column osuser format a8 heading 'Op Sys|User'
column sprogram format a27 heading 'Session program'
select value from v$parameter where name='db_name';
select
sessions_current, sessions_highwater from
v$license;
select
p.username pusername,
s.terminal,
p.program pprogram,
s.username susername,
server,
osuser,
s.program sprogram
from v$process p, v$session s
where addr=paddr(+)
/


 

Nguyen,

David M To: Multiple recipients of list
ORACLE-L  
david.m.nguy[EMAIL PROTECTED]

en   cc:

@xo.com Subject: Currently log-in users

Sent by: root

 

 

04/11/2002

11:53 AM

Please

respond to

ORACLE-L

 

 





How do I check who is currently logging into database, where he is
accessing
from and what he is doing?

Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
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
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM Error On Unix


$ /usr/local/bin/sudo find / -name *oem* -print
/usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/
1/DataFiles/Expanded/Scripts/oemapp
/db01/app/oracle/product/8.1.7/bin/oemapp
$ 

The above will confirm that , I do not have oemctrl on my Oracle Client on
HP Unix machine. 

Any idea how to get that stuff , do I need to install anything else here
 like OMS , if so where can I get it

Thanks,
Madhu

-Original Message-
Sent: Thursday, April 11, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L


Try to do

$which oemctrl  

or 

$find / -name *oem* -print


Someone on the distro might add in comments


David


-Original Message-
Sent: Thursday, April 11, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


I could not see this on HP-UNIX client ( $OH/bin ) where I have installed
all the Oracle Client ( Administration ),
Would you let me know the location , where I can find this on UNIX

--Madhu

-Original Message-
Sent: Thursday, April 11, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L


Try

oemctrl start oms



-Original Message-
Sent: Thursday, April 11, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


Hell All,
I am seeing the following error , when I am trying to start OEM console on
HP Unix. Any Idea , what I am missing and would like to know , what is this
Management server and how to start it on HP Unix .. Thanks in advance



 ...OLE_Obj... 


Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: test



SUCCESS !! And Congrats

-Original Message-
Sent: Thursday, April 11, 2002 6:19 PM
To: Multiple recipients of list ORACLE-L


test

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ivan Llamoca
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: init file ???


$OH/database is the place where ORACLE will look for the parameter file and
here you can (also) have a soft link created to the Actual location of the
parameter file i.e. . PFILE directory(ORA_HOME/admin/SID/pfile) .

And for the control file location see the initsid.ora file ( parameter
control_file ) and make sure the control files are in proper locations.

Then start the database.

--Madhu




-Original Message-
Sent: Thursday, April 11, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L


Hi,

I'm using 9.0.1 on win2000.  When a database is
created using configuration assistant, two init files
are created: one in ORA_HOME/database, and the other
in ORA_HOME/admin/SID/pfile.  Here are my questions:

1. what's the difference between these two, why
created two copies.

2. the one in ORA_HOME/database has strange format ef:
*.variable=value, why?

3. how to find out which init file the db is using,
assuming the db cannot be mounted.  I got a problem
that the alert.log keeps telling me the control file
cannot be found.

ORA-00202: controlfile:
'c:\ora_9i\oradata\small\datafile\small.ctl' (I didn't
specify this path in both init file, where did Oracle
get this directory???)

O/S-Error: (OS 2) The system cannot find the file
specified.

Since db is not mounted yet, I cannot use show
parameter pfile.  So how do I know which init file
Oracle is reading?

Thank you!

Leslie

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM Error On Unix


No I was trying to start the OEM console , which requires OMS, but I do not
have it on HP Unix server.
So I have installed OEM on Windows and now able to work with console from my
m/c.

Thanks for suggestions , but not much help
Thanks
Madhu

-Original Message-
Sent: Thursday, April 11, 2002 5:57 PM
To: Multiple recipients of list ORACLE-L



Wouldn't it be:  oemapp dbastudio 

Reddy, Madhusudana wrote:
 
 $ /usr/local/bin/sudo find / -name *oem* -print

/usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/
 1/DataFiles/Expanded/Scripts/oemapp
 /db01/app/oracle/product/8.1.7/bin/oemapp
 $
 
 The above will confirm that , I do not have oemctrl on my Oracle Client on
 HP Unix machine.
 
 Any idea how to get that stuff , do I need to install anything else here
  like OMS , if so where can I get it
 
 Thanks,
 Madhu
 
 -Original Message-
 Sent: Thursday, April 11, 2002 3:13 PM
 To: Multiple recipients of list ORACLE-L
 
 Try to do
 
 $which oemctrl
 
 or
 
 $find / -name *oem* -print
 
 Someone on the distro might add in comments
 
 David
 
 -Original Message-
 Sent: Thursday, April 11, 2002 1:04 PM
 To: Multiple recipients of list ORACLE-L
 
 I could not see this on HP-UNIX client ( $OH/bin ) where I have installed
 all the Oracle Client ( Administration ),
 Would you let me know the location , where I can find this on UNIX
 
 --Madhu
 
 -Original Message-
 Sent: Thursday, April 11, 2002 12:29 PM
 To: Multiple recipients of list ORACLE-L
 
 Try
 
 oemctrl start oms
 
 -Original Message-
 Sent: Thursday, April 11, 2002 11:26 AM
 To: Multiple recipients of list ORACLE-L
 
 Hell All,
 I am seeing the following error , when I am trying to start OEM console on
 HP Unix. Any Idea , what I am missing and would like to know , what is
this
 Management server and how to start it on HP Unix .. Thanks in advance
 
  ...OLE_Obj...
 
 Thanks,
 Madhu V Reddy
 Database Support Services
 (952) 324-0392 ( work )
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Nguyen, David M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Nguyen, David M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Reddy, Madhusudana
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists

RE: Urgent --- Locking problem

2002-04-08 Thread Reddy, Madhusudana


Hello List,

I am seeing Locks and the OS process is SNP process , I have to run the same
job which will refresh the MVs. I am stuck due to the locks on the database
, when I have tried to kill the session , it says me its is Marked for kill.

Can anybody suggest me what to do ???
Its one kind of urgent 

Thanks
Madhu

-Original Message-
Sent: Monday, April 08, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L


hello All,
I tried to kill a session and now it is showing me as marked as killed.
But It is still holding the Locks. And I need to rerun the same . 
Its holding a lock type of 'JI' in exclusive mode . Can anybody suggest me
what to do now ???

PS: Its a job which refreshes the Materialized views , so it will be using
the SNP process

Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

STATSPACK PURGE

2002-04-04 Thread Reddy, Madhusudana




Hello All,
I have a need to purge the old statistics accumulated by statspack and I 
am manually using the 'SPPURGE" ( I pass 'losnapid' and 'hisnapid' ) utility , 
instead I would like have a PL/SQL program which can be automated through 
DBMS_JOB . Would somebody help me in this .

Thanks in advance,
Madhu

How much space is required for STATSPACK


Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error

create table  STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
CCXSTL01

Would like to know , how much space is required for this. 
Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )
(612) 589-8721 ( pager)
Email: [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How much space is required for STATSPACK


Yeah I did read all the SPDOC.txt in $ORACLE_HOME/rdbms/admin.
I have created a tablespace of ( a locally managed , uniform , extent size
10 MB ) of size 500 MB , but still getting the below mentioned problem, I
think I have to go for auto extend rather than uniform with 10 MB each. If
you have any suggestions , let me know .

yeah , as you mentioned about the documents which were referred in the LIST
, they are really worth while to read . And I am doing that now. 

Thanks,
Madhu

-Original Message-
Sent: Friday, March 29, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


Hello,

I suggest that you read the readme file for the STATSPACK installation. If
8.1.7, it says that it needs approx. 45MB. You could create a schema, or use
something like TOOLS for the default tblsp, and use TEMP for the temporary
tblsp. Also, I would suggest that you read the articles on STATSPACK on OTN
and elsewhere (I'm pretty sure that someone on this list sent out some nice
URLS about STATSPACK just the other day). Since I was interested, I pulled
the articles, read through them, and did a test install on one of my
development boxes. Also, I suggest that you change the PERFSTAT password.

Thank you,

Paul Sherman
DBA
voice -  781-501-4143 (office)
fax-  781-278-8341 (office)
email - [EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 29, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error

create table  STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
CCXSTL01

Would like to know , how much space is required for this. 
Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )
(612) 589-8721 ( pager)
Email: [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Paul R.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How much space is required for STATSPACK


seems like I need small extent size , I have given 10MB for each extent ,
and in your case it is just 128 K.
so by reducing the extent size , should it work ?

-Original Message-
Sent: Friday, March 29, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L


It shouldn't take that much space to install. Is CCXSTL01 the correct
tablespace? After you get it installed the space requirement depends on how
many snapshots you take and how long you retain them. I take level 5 snaps
every 15 minutes and actively purge data and rebuild indexes. I retain some
data for 3-7 days and other data for 2 months. With my current snapshot and
purging schedule I'm maintaining an equilibrium of about 250MB for storage.
The extent size for my LMT is 128K. 


Steve Orr
Bozeman, MT



-Original Message-
Sent: Friday, March 29, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L


Hello All,
I am trying to install the statspack utility by assigning PERFSTAT user to a
locally managed tablespace of size 500 MB, it is giving me the following
error

create table  STATS$LEVEL_DESCRIPTION
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
CCXSTL01

Would like to know , how much space is required for this. 
Thanks,
Madhu V Reddy
Database Support Services
(952) 324-0392 ( work )
(612) 589-8721 ( pager)
Email: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How much space is required for STATSPACK


Yep , Ethan , you are mistaken , Seems my problem is with very big extents ,
I will try with small extents , let all you guys know.

-Original Message-
Sent: Friday, March 29, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L


Perhaps he is not installing as user SYS.  The PERFSTAT user is granted
UNLIMITED tablespace in the install scripts on the tablespace that is
selected, so either there is not enough free space or the grant is bombing
because he is not SYS...or something else that I am not thinking about at
the moment.

- Ethan

-Original Message-
Sent: Friday, March 29, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L


It shouldn't take that much space to install. Is CCXSTL01 the correct
tablespace? After you get it installed the space requirement depends on how
many snapshots you take and how long you retain them. I take level 5 snaps
every 15 minutes and actively purge data and rebuild indexes. I retain some
data for 3-7 days and other data for 2 months. With my current snapshot and
purging schedule I'm maintaining an equilibrium of about 250MB for storage.
The extent size for my LMT is 128K. 


Steve Orr
Bozeman, MT

  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to duplicate production database onto development box

Title: How to duplicate production database onto development box



if you not affordable to a down time , may be hot 
backups will help you out.
1. Copy the Hot backups to a different machine where 
you want to have a duplicate database.
2. Edit the Init.Ora and control file 
.
3. run the control file and recover the 
database.


  -Original Message-From: Daiminger, Helmut 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 26, 
  2002 7:48 AMTo: Multiple recipients of list 
  ORACLE-LSubject: How to duplicate production database onto 
  development box
  Hi! 
  We want to put an exact copy of our production database 
  (approx. 200 GB) onto a development box. What would be the best way to achieve 
  this? Export/import would take kinda long... ;)
  Would transportable tablespaces be the way to go? 
  This is 8.1.7 on Sun Solaris. 
  Thanks, Helmut

RE: .dbf is a valid name for a datafile name?


.dbf is perfectly OK

-Original Message-
Sent: Tuesday, March 26, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L


I have added a datafile to a the temp tablespace with the name of .dbf only
is ithis a valid name?, is there any way to rename it without shutdown the
database,if yes HOW?

Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: EXPORT FAST?


FAST EXPORT:

1. High Buffer
2. Have export on a disk where you have less activity of i/o
3. Do Not Export to a NFS mounted file system/disk , which is very slow.

Hope this helps
---
Madhu

-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


Hi
one of export for 35GB database is taking 12 hours.How to reduce this export

time.
Thx
Seema



_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8.1.7 LMTs Autoallocate vs Uniform Extents


http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/tspaces.htm

-Original Message-
Sent: Tuesday, March 26, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L


Can someone point me to good reading material on this
subject. Is one better than the other for performance
and manageability?

Syntactically the autoallocate is shorter and seems to
be more hands off (does that mean worry free also?).  


TIA


=

Sundeep Maini 
Consultant 
Currently on Assignement at Marshfield Clinic WI 
[EMAIL PROTECTED] 

__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sundeep maini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: STATSPACK


Dennis,
I have got all the statistics in the STAT tables now and I would like to
query them to see the last info. regarding performance of the system. Seems
like I may need to purchase a book .

Thanks for the mail.
Reddy

-Original Message-
Sent: Tuesday, March 26, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L


Reddy - I assume that you mean that you ran the statsrep.sql and printed the
report. Is your question about interpreting this report? There is a good
series of articles at
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html

Or is your question how to write your own queries? If that is the question,
I would recommend that you invest in the book Oracle High-Performance
Tuning with STATSPACK by Don Burleson, available at your local bookstore.
Don offers some articles on-line at http://www.dba-oracle.com/articles.htm

Let me know if that is the information that you want.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, March 26, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L


Hello ALL,
I have set up the statspack on Oracle 8.1.7 and just now I also got the
REPORT , but poor me unable to understand that . Can anybody help me out in
this ... Well I know www.oraperf.com will do it for me by sending a report ,
but I want to do it myself by writing some queries ... would anybody help me
with some white paper. 

Thanks In advance,
Madhu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL*Loader-282: Unable to locate character set handle for


seems like You are loading data from one version of database to the other
version , try to use the version compatible tool like 
sqlldr80, sqlldr73. sqlload.

I guess this may be your problem

-Original Message-
Sent: Tuesday, March 26, 2002 4:30 PM
To: Multiple recipients of list ORACLE-L
charact


I am trying to load data from a 8.1.7 SQL Loader session to a 7.3.4
database.
I am getting a  SQL*Loader-282: Unable to locate character set handle for
character set ID (0).
error message.  Can anyone tell me how to get around this?

Thanks!
Ron Smith
DBA
Kerr-McGee Corp
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

STATSPACK