Re: Set processes at init.ora
Thanks Pd for your answered. The Os is window 2000 and Oracle 8.1.6.0.0. I run the query v$resource_limit after I reset processes No to 250. and saw the No. is up and stable to 110 process. I will keep monitor it and make sure all session disconnected. I wonder if processes is set to higher, any impact to memory or resource usage? Mitchell - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Monday, October 27, 2003 5:39 PM Subject: Re: Set processes at init.ora Mitchell, It would be most helpful if you supplied the Oracle Server version info. You may have simply had legitimately 190 users connected. You may have a problem with sessions being disconnected by the client that are not being terminated properly. It is a known issue that support for dead connection detection on win32 is non-existent, hence improperly terminated sessions can hang around for quite awhile. You do not have to explicitly set any OS parameters in hiking up the number of processes in the init.ora. Depending upon your oracle server version (which again, is unknown here) you might want to change either the number of rollback segments or the number of transactions/segment. hth. PdMitchell <[EMAIL PROTECTED]> wrote: DBAsOur database running on NT 2000 is over 200 processes today and I had toreset to a hight No. As I know, if I set highter for this parameter, thewill be impact on Unix system, I wonder there is any impact on windows.thanks in advanceMitchell-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: MitchellINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). Do you Yahoo!?Exclusive Video Premiere - Britney Spears
Re: Set processes at init.ora
DBAs Our database running on NT 2000 is over 200 processes today and I had to reset to a hight No. As I know, if I set highter for this parameter, the will be impact on Unix system, I wonder there is any impact on windows. thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 pricing ain't going down
ing: 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: David Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SGA
Hi Jared This is the website http://www.oraperf.com/ . If you upload your report ( utilb or statpack) , they will give you good suggestion. Try and you will find it. Mitchell - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 15, 2003 12:50 PM Subject: Re: SGA Mitchell, Which portion of the statspack report suggests increasing the cache size? Maybe you could post that portion here. The cause for poor performance needs to be located and corrected. What are the user complaints specifically? Have you checked to see where your system is spending its time? This query may prove helpful in that regard: col event format a35 head 'EVENT NAME' col total_waits format 999,999,999 head "TOTAL|WAITS" col total_timeouts format 999,999,999 head "TOTAL|TIMEOUTS" col time_waited format 999,999,999 head "TIME|WAITED|SECONDS" col average_wait format 9 head "AVG|WAIT|100ths" set line 150 set trimspool on select event, total_waits, total_timeouts, time_waited/100 time_waited, average_wait from v$system_event order by time_waited / ttitle off Jared Mitchell <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/15/2003 09:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: SGAHi JaredI have reset to previous value and restarted the database anyway. Since Ihave 8G Memory and I may set SGA more than 3G. Actually I did at our AIXSP that set SGA total up to 5G of 8G memory.Anyway I found a solution on metalink ( Note 115753.1 and 1028623.6. ) toset SGA to higher. You may be interest to read it.You are right it is best to find a root cause of poor performance. Thereason I want to increases db buffer is our customer complain slow on ourdatabase and Statpack report suggest to increase it as wellThanksMitchell- Original Message -To: <[EMAIL PROTECTED]>Cc: <[EMAIL PROTECTED]>Sent: Friday, August 15, 2003 10:42 AM> Was a low cache hit ratio the only 'problem'?>> Were jobs taking longer than normal?>> Were users complaining of a slow system?>> Did your average response time shoot up dramatically?>> I'm afraid you may have succumbed to the dreaded disease,> CTD, or Compulsive Tuning Disorder.>> This is the urge to tweak database parameters due to some> arbitrary threshold. even though everything seems to be> working fine.>> It isn't your fault, as a number of publications in the> past, including Oracle's, have taught that having a block> cache hit ratio, or BCHR, lower than 90 or 95% meant that> your system was performing poorly.>> The first thing to do is set your db_block_buffers size> back to a value that allows you to start the database.>> Then head on over to http://www.hotsos.com and register> for the site. Click on 'Knowledge On-Line' at the top> of the page, and get the paper "Why 99% Database Buffer> Cache Hit Ratio is NOT Ok".>> There are other useful papers there as well, and indeed> many other sites where you can find useful information> about BCHR. This will get you started.>> Of course, someone (Connor McDonald I think) wrote a nice> utility that will increase your BCHR for you, but I don't> think you want to use it in production. :) It's chief> purpose is to underscore the futility of trying to tune> via the block cache hit ratio.>> HTH>> Jared>>>>> On Thu, 2003-08-14 at 16:19, Mitchell wrote:> > Hi DBAs> >> > We have Sun Sparc system (Sun Fire 880) with 8G memeory. We has setting> > /etc/system to the max and data buffer catch 1000m and total SGA 1745MBon> > our . Oracle 8.1.7.3.0 Server. Since Dat Buffer Cache hit ration> > lower then 50% for last a few days, So We decide to increase another400MB> > to DB buffer. We faile to restart instance then, reside to 1200M, still> > failed. I have no clue at all for why. (I have checked the Metalink, no> > solution but redece SGA size). Anybody has any idea?> >> > Thanks in advance.> >> > Mitchell> >> >> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.net> > -- > > Author: Mitchell> > INET: [EMAIL PROTECTED]> >> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
Re: SGA
Hi Jared I have reset to previous value and restarted the database anyway. Since I have 8G Memory and I may set SGA more than 3G. Actually I did at our AIX SP that set SGA total up to 5G of 8G memory. Anyway I found a solution on metalink ( Note 115753.1 and 1028623.6. ) to set SGA to higher. You may be interest to read it. You are right it is best to find a root cause of poor performance. The reason I want to increases db buffer is our customer complain slow on our database and Statpack report suggest to increase it as well Thanks Mitchell - Original Message - To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 15, 2003 10:42 AM > Was a low cache hit ratio the only 'problem'? > > Were jobs taking longer than normal? > > Were users complaining of a slow system? > > Did your average response time shoot up dramatically? > > I'm afraid you may have succumbed to the dreaded disease, > CTD, or Compulsive Tuning Disorder. > > This is the urge to tweak database parameters due to some > arbitrary threshold. even though everything seems to be > working fine. > > It isn't your fault, as a number of publications in the > past, including Oracle's, have taught that having a block > cache hit ratio, or BCHR, lower than 90 or 95% meant that > your system was performing poorly. > > The first thing to do is set your db_block_buffers size > back to a value that allows you to start the database. > > Then head on over to http://www.hotsos.com and register > for the site. Click on 'Knowledge On-Line' at the top > of the page, and get the paper "Why 99% Database Buffer > Cache Hit Ratio is NOT Ok". > > There are other useful papers there as well, and indeed > many other sites where you can find useful information > about BCHR. This will get you started. > > Of course, someone (Connor McDonald I think) wrote a nice > utility that will increase your BCHR for you, but I don't > think you want to use it in production. :) It's chief > purpose is to underscore the futility of trying to tune > via the block cache hit ratio. > > HTH > > Jared > > > > > On Thu, 2003-08-14 at 16:19, Mitchell wrote: > > Hi DBAs > > > > We have Sun Sparc system (Sun Fire 880) with 8G memeory. We has setting > > /etc/system to the max and data buffer catch 1000m and total SGA 1745MB on > > our . Oracle 8.1.7.3.0 Server.Since Dat Buffer Cache hit ration > > lower then 50% for last a few days, So We decide to increase another 400MB > > to DB buffer. We faile to restart instance then, reside to 1200M, still > > failed. I have no clue at all for why. (I have checked the Metalink, no > > solution but redece SGA size). Anybody has any idea? > > > > Thanks in advance. > > > > Mitchell > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mitchell > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SGA
Hi DBAs We have Sun Sparc system (Sun Fire 880) with 8G memeory. We has setting /etc/system to the max and data buffer catch 1000m and total SGA 1745MB on our . Oracle 8.1.7.3.0 Server.Since Dat Buffer Cache hit ration lower then 50% for last a few days, So We decide to increase another 400MB to DB buffer. We faile to restart instance then, reside to 1200M, still failed. I have no clue at all for why. (I have checked the Metalink, no solution but redece SGA size). Anybody has any idea? Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Find the table's name that using sequences
Title: Message Hi All At first I thought it is easy to find those tables to use sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell
salary question
Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ORA-01041: internal error. hostdef extension doesn't exist
Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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_stats.gather_schema_stats
Hi All May I know what is best interval to exec dbms_stats.gather_schema_stats on a instance with 300 tables that updated everyday. By the way, Anybody has any detailed command reference for dbms_stats. I am not sure for the following such as degree? execute dbms_stats.gather_schema_stats ( ownname ='FNSS', degree => 4, cascade => true ); Thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Monitor
Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Set Email alert at NT
Thanks for your reply.
Yes. you are right. There is another line after send out ' mv
alert_oraclesid newnaem.{date}'
There is another cron job for logflip at 12:00am everday
Mitchell
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 4:08 PM
>
> Use the NT 'AT' command to schedule a .bat file to skim your
> alert log and use BLAT (Public Domain SMTP utility) instead of
> mailx. As mentioned in the last few days batch file scripting
> is a poor substitute for a real shell but it's all do-able. The
> other problem is how to get rid of an error from the alert file
> after it has emailed you onceyou haven't said how you do this
> on your Unix box...looks like it will keep emailing you the
> same error every 30 minutes, but I could be missing something =8-)
>
>
> HTH
>
> Jeff Herrick
>
> On Fri, 21 Feb 2003, Mitchell wrote:
>
> > Hi
> >
> > The following sh is one I used for monitoring all 20 instances on unix
> > boxes(aix and sun). So I could receive the ora message by palm. Now
> > there are 2 nt box with Oracle 8.17 installed. I have no idea how to
> > do it in windows. Any idea?
> >
> > This is my ksh and run as cron job every 30 min.
> >
> > if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log
> |
> > grep 'ORA' | wc -l) -gt 0 ];
> > then
> >
> > cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log |
> > grep 'ORA' > $HOME/alert_me
> > mailx -s " Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!!"
> > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <
> > $HOME/alert_me
> > fi
> >
> >
> > Thanks in advance.
> >
> > Mitchell
> >
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jeff Herrick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> 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.net
--
Author: Mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Set Email alert at NT
Title: storing credit card numbers in a database
Hi
The following sh is one I used for
monitoring all 20 instances on unix boxes(aix and
sun). So I could receive the ora message by palm. Now there are
2 nt box with Oracle 8.17 installed. I have no idea how to do it in
windows. Any idea?
This is my ksh and run as cron job every 30 min.
if [$(cat
$ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep 'ORA' | wc
-l) -gt 0
];
then
cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log |
grep 'ORA' > $HOME/alert_me mailx -s " Warning: ${ORACLE_SID}
Oracle Alert: ORA_error !!!" [EMAIL PROTECTED] <
$HOME/alert_mefi
Thanks in advance.
Mitchell
Java routine for data validation
I have been asked to request the following: Does anyone have information for a JAVA date validation routine in Oracle? Helen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ORA-28030: Server encountered problems accessing LDAP directory service
Title: RE: ORA-28030: Server encountered problems accessing LDAP directory service
Yes. This was indeed the case. I was using
"current_user" to create the link. I just dropped and re-created the link
using an named user account and the link works fine now. Thanks for the
quick response!
David
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02,
2003 9:57 AMTo: David MitchellSubject: RE: ORA-28030:
Server encountered problems accessing LDAP directory
service
Displayed below are the messages of the selected thread.
Thread Status: Closed From: TABAINET
MOHAMED 01-Aug-02 14:54 Subject: ORA-28030 Server
encountered problems accessing LDAP directory service
RDBMS Version:: 8.1.7.0 Operating
System and Version:: windows NT4 Error Number (if
applicable):: ORA-28030 Server encountered problems accessing LDAP directory
service Server Net Version:: 8.1.7.0 Client Operating System and Version:: 8.1.7.0 Client Net Version:: 8.1.7.0
ORA-28030 Server encountered problems accessing LDAP directory
service
I have 2 servers def03 and def64 I
have created a dblink in def03 to connect to def64 I
deinstalled Oracle advanced security in def03. but when I want to connect to
database in def64 using dblink whith current_user option, i have this message
ORA-28030 Server encountered problems accessing LDAP directory
service
SQL> select name,value from v$parameter 2 where name in ('db_domain','db_name','global_names');
NAME VALUE --
db_domain global_names FALSE
db_name THORATFE
any helps please
morad
From: Oracle, MICHAEL SEIBT 01-Aug-02 16:09 Subject: Re : ORA-28030 Server encountered problems accessing LDAP
directory service
This is a bug (954379)
Workaround: ===
Don't use current_user or create user identified
globally. OR Set
_ENT_DOMAIN_NAME to ANY value in init.ora file for dblinks which use
current_user.
Is this your case ?? Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot
com Any opinion expressed here is personal and doesn't
reflect that of ESPN Inc. QOTD: Any clod can have
facts, but having an opinion is an art! -Original
Message- From: David Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-28030: Server encountered problems accessing LDAP
directory service
Yes, that's correct. That is what the error message
says. Anyone have any idea why it's trying to use LDAP to resolve the
database link? I thought with my sqlnet.ora file set to use tnsnames.ora
I'd be using my local files to resolve the service name. Any suggestions
as to why it's trying to use LDAP are welcome.
David
RE: ORA-28030: Server encountered problems accessing LDAP directory service
Yes, that's correct. That is what the error message says. Anyone have any idea why it's trying to use LDAP to resolve the database link? I thought with my sqlnet.ora file set to use tnsnames.ora I'd be using my local files to resolve the service name. Any suggestions as to why it's trying to use LDAP are welcome. David -Original Message-From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: ORA-28030: Server encountered problems accessing LDAP directory service Looks like are trying to resolve service name using LDAP naming . David Mitchell <[EMAIL PROTECTED]> wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..! .David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now
ORA-28030: Server encountered problems accessing LDAP directory service
I've recently inherited an Oracle 8.1.6 system and was just trying to setup a database link between two instances. I've granted the "create database link" priv to the user account and can successfully create the link but when I try to do a "select from table_name@linked_db;" I get the following error: ERROR at line 1: ORA-28030: Server encountered problems accessing LDAP directory service Earlier I had a TNS error and found that my tnsnames.ora file was missing one of my instances. I fixed that problem and tnsping now responds correctly but I'm still getting the error listed on the subject line. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" so everything should be set to use my local tnsnames.ora file. I've been going through Oracle Net 8 documentation but still haven't found anything. Does anyone have any suggestions? Thanks... David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Application Server on .net
It sounds like there's a considerable amount of confusion about this from some of the responses to this question so far. There are lots of .Nets currently in the Microsoft world. There's Visual Studio .Net which is a development environment. There's the .Net CLR which is a runtime environment for a variety of OS's (primarily Microsoft's) and then there's the upcoming Windows .Net Server 2003 which is the successor to Windows 2000 Server. I assume from your description that you are talking about Windows .Net Server 2003 which is currently in Release Candidate 2 status. If this is what you are talking about then it is most definitely an operating system and has nothing to do with OAS. I wouldn't expect any .Net Server compatibility from Oracle until the OS is actually released by Microsoft (currently scheduled for April 2003). David -Original Message-From: Barbara Baker [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 17, 2002 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Application Server on .net List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server. He's using the install disk for Windows NT and 2000. Needless to say, it gives him an error and throws up. He considers .net just another operating system like np or 2000. I think of it more like a competitor for OAS. At any rate, I can't find any mention of .net on either Metalink or OTN (except how much better OAS is than .net) Does anyone know if Oracle has an application server installation for .net? If so, do you know how I might get it? Is this a silly question? Should I be hanging my head in shame?? Thanks in advance for any information. Barb Do you Yahoo!?Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: DBMS_JOB does not run on NT
Hi I had same situation before. Check owner of the job and security and add necessary privilege. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 14, 2002 10:33 AM > Dear gurus ! > I submit a job via the DBMS_JOB package , it looks OK , select from > user_jobs shows that broken='N' . > When i execute the job manually , using dbms_job.run , it runs , but it does > not run automatically (each 5 minutes , as i have specified when submitting > the job). > Any guess ? > Thanks a lot ! > > DBAndrey > > * 03-9254520 > * 058-548133 > * mailto:[EMAIL PROTECTED] > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Andrey Bronfin > 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: mitchell 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: connect as internal
Hi I just view readme about installing Oracle Patch on Oralce 8.1.6 One thing mentioned as Invoke sqlplus, connect as internal and run catalog catproc etc .. I wonder why Connect as internal. what is different between those 3 login 1. sqlplus system login, connect as internal 2. sqlplus system/manager login 3. sqlplus system login , connect system as sysdba Thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: table size.
Title: RE: table size. Hi Godlwski Thanks for your reply. This is not locally managed tablespace and num_rows are the same. The following result from dba_tables. This big different is empty_blocks. I still confused why the size is the same but with much more empty_blocks. I think the empty_block means never used. If whole block data is deleted, what happed to this column? used but emptied? Mitchell 1. exported table TABLE_NAME EMPTY_BLOCKS CHAIN_CNT BLOCKS AVG_SPACE-- -- -- --STATEMENT_LINE 30 0 40401 421 2. imported table TABLE_NAME EMPTY_BLOCKS CHAIN_CNT BLOCKS AVG_SPACE-- -- -- --STATEMENT_LINE 46099 0 35225 421 - Original Message - From: Godlewski, Melissa To: '[EMAIL PROTECTED]' Sent: Monday, July 08, 2002 12:54 PM Subject: RE: table size. Mitchell, Is this table in a Locally Managed Tablespace? If so your extents might be the issue. Check blocks and empty blocks, and num_rows in dba_tables. (after an analyze of course) -Original Message- From: mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Subject: Re: table size. Sorry : table is 8 million rows and I deleted 5 million rows. - Original Message - To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 12:20 PM > > Hi all > > I have a table with 8 millions rows and I deleted the 500 million. Then I > exported tables (300 mb) and imported into another schema. After that, the > table size is still the same. > > I thought table size should be taken much less space. the storage clause for > both table is the same: pct10,pctused 40. > > any idea. > > Mitchell > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: table size.
Sorry : table is 8 million rows and I deleted 5 million rows. - Original Message - To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 12:20 PM > > Hi all > > I have a table with 8 millions rows and I deleted the 500 million. Then I > exported tables (300 mb) and imported into another schema. After that, the > table size is still the same. > > I thought table size should be taken much less space. the storage clause for > both table is the same: pct10,pctused 40. > > any idea. > > Mitchell > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: table size.
Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both table is the same: pct10,pctused 40. any idea. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: Replication question
Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 10:58 AM > We are just starting to look at replication so each manufacturing plant can > have their own server. The applications are being developed in-house. I feel > the first issue is to analyze each table and decide how it will be > replicated and what schema changes need to me made to accommodate > replication. Instead, one of the developers wants to talk to Quest about > their solution. It seems to me that you need to make the same evaluation and > schema changes where needed. If anyone can point me to a white paper on > schema changes to consider, that would be appreciated. > > Dennis Williams > DBA, 20% OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -- > 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: mitchell 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 put ' on statement
hi I forget how to put single qutation on sql. somebody can help me. Mitchell I could't make it from following. select 'ALTER TABLESPACE rename file "'" '||file_name||' to '||file_name||'"'";' from dba_data_files where tablespace_name = 'TBL_STATEMENT'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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).
looking at notes in METALINK
How do I find a specific note number in METALINK? The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. BEGIN:VCARD VERSION:2.1 N:Mitchell;Helen FN:Helen Mitchell NICKNAME:Helen TEL;HOME;VOICE:303.841.9528 TEL;CELL;VOICE:303.907.4204 ADR;HOME:;;15362 Foxglove Ct.;Parker;CO;80134-9589;USA LABEL;HOME;ENCODING=QUOTED-PRINTABLE:15362 Foxglove Ct.=0D=0AParker, CO 80134-9589=0D=0AUSA EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20020426T205222Z END:VCARD
Oracle 8i Study Guide
I just got a job after being out of work in Denver for the past eight months. I need to complete the Oracle certification. I will completing Oracle's Mixed Release Path program. Does anyone know of a free site where I can get study guide material for the Oracle 8i exams? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helen J Mitchell 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: Houston, TX- Oracle DBA/Web Developer Needed
> PLEASE DO NOT send your resume for this position UNLESS you aalready live in > the > Houston area and have the skills outlined below for this position. PLEASE DO NOT sent your mail for this purpose UNLESS you want to hire the guy where ever they are. joke for a day. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 10:13 AM > Houston Texas company needs an Oracle DBA/Web Developer to join its' I.T. team. > > PLEASE DO NOT send your resume for this position UNLESS you aalready live in > the > Houston area and have the skills outlined below for this position. > > DO NOT send your resume unless you have a stable work history (no job hoppers). > Candidates whose work history includes frequent job changes connot be > considered. > If you are employed by a consulting company you must have a long term > project history. > > This is a full time staff position so no sub-contractors or third parties > please. > > Requirements: > -We need a good Production 24/7 DBA who has > done web development with C++, Visual Basic, .net or any other Microsoft > programming tools. > -They also need to be a U.S. citizen or permanent resident. > > The base salary depends on experience. > > For immediate consideration, please send your resume as a Word attachment to: > OraStaff, Inc. > Email: [EMAIL PROTECTED] > Please use job code: One/Houston/DBA/Web Dev./Sharon > (*Houston area candidates only) > ph: 1-800 -549-8502 > > All Submissions are handled in confidence. > > *We pay referral fees. > So please contact me if you know of anyone who would be qualified/interested > in the posiition described above- if it is not a match for your skills. > Thanks, > Bill Law > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: OraStaff > 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: mitchell 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: database clone:
Hi DBAs. Thanks all your reply. I am still thinking it is possible to use backup file or cp files. It is hard to exp/imp on a large system with 300GB. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 11:53 AM > [EMAIL PROTECTED] wrote: > > > Hi DBAs: > > > >What is the best way to clone large oracle database ( 8.0.5, 300g) from aix > >4.3 o to Sun Soloris (2.8). > >Any idea, articles, experience? > > > > > >thanks in advance. > > > >Mitchell > > > > > exp from aix, install, create the database and the tablespaces on sun, > then imp. > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > > "Books won't stay banned - Ideas won't go to jail." - Alfred Whitney Griswold > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: bill thater > 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: mitchell 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: database clone:
Hi DBAs: What is the best way to clone large oracle database ( 8.0.5, 300g) from aix 4.3 o to Sun Soloris (2.8). Any idea, articles, experience? thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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).
Veritas Software
Can anyone supply a site or information about how to use Veritas software as it applies to databases? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 6:03 AM > Can anyone supply a site or information about how to use Veritas software as it >applies to > databases? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Helen J Mitchell > 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: Helen J Mitchell 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: Software Vs Hardware Firewall.
Can anyone supply a site or information about how to use Veritas software as it applies to databases? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helen J Mitchell 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: Changing dump destinations in init.ora
Rich, Hi there. This is Helen Mitchell. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, February 24, 2002 7:58 PM > Yes, the SPFILE is stored in binary format in the database, but you can > sort of work around it. To create a text file from the SPFILE, you can > issue: > > CREATE PFILE 'pfilename' FROM SPFILE 'filename'; > > And vice versa with: > > CREATE SPFILE = 'filename' FROM PFILE = 'pfilename'; > > When starting the instance, you can also specify an alternate SPFILE: > > SQL> startup pfile=filename > > There's also some new syntax for the ALTER SYSTEM command to specify the > scope of the change: > > ALTER SYSTEM set parameter = value SCOPE = MEMORY | SPFILE | > BOTH; > > Rich Holland > Guidance Technologies, Inc. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > > [EMAIL PROTECTED] > > Sent: Wednesday, February 13, 2002 3:43 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:RE: Changing dump destinations in init.ora > > > [...] > > during the discussion on database management it was revealed that init > > > files are on the way out, probably in 9i version 2. Their being > replaced > > by an SF file that is humanly unreadable and consequently > unmodifiable. > > Seems we'll have to do all modifications with the assistance of an > alter > > database or alter system command. > > On the plus side, if your starting a database remotely you'll not need > a > > copy of the init.ora locally. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rich Holland > 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: Helen J Mitchell 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: Bitmap Indexes
oops ... forgot ... - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 11:23 AM Subject: Re: Bitmap Indexes Helen, Attachments do not make it to the list. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Helen J Mitchell To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 12:18 PM Subject: Re: Bitmap Indexes Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes >for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal >From: "Deshpande, Kirti" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Bitmap Indexes >Date: Thu, 07 Feb 2002 19:58:20 -0800 > >Ethan, > I have been using bitmap and b-tree indexes on the same table in our data >mart since 7.3.4. Never had a problem with query performance. Now we have >partitioned the tables in 8.1.7.x and most tables that were using bitmaps do >not need to use them anymore. Just one table uses it, with b-tree indexes >for PKry and one other non-unique index. No problems so far. > The only issue we had with bitmap indexes was the way it used up extents, >if those were not droppped before the dataloads. The problem still exists >with 8.1.7.x. Have not tried with 9i yet.. > >HTH, > >- Kirti > > >-Original Message- >Sent: Thursday, February 07, 2002 3:07 PM >To: Multiple recipients of list ORACLE-L > > >Posted on behalf of a friend... > > >Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this >note now): > I have a question regarding Oracle's bitmap indexes. We have been DABBLING >with bitmap indexes with mixed results here. In >many cases, they are great solutions. In some cases, where we have a mix of >bitmap and b-tree indexes on the same table, we occasionally get into >trouble --- this has to do with the Oracle optimizer deciding, on the fly, >to convert a regular b-tree index into a bitmap. It does this so that it >can AND or OR the various bitmap indexes together. Sounds great on the >surface but when this occurs, response time goes in the toilet. > >In one situation we have, we have a fact table with two bitmap indexes and a >few other b-tree indexes. A particular query we run bogs down (NEVER >COMPLETES) with this mix of indexes. Based on the access path that's being >chosen, we know which b-tree index is being converted on the fly. If we >convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and >Oracle does not need to create the third one on the fly), the query really >runs well. If we replace the bitmap indexes with b-tree indexes (so we only >have b-tree indexes), we get decent response times. (This is all on Oracle >8.1.7.2.0, by the way.) > >I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" >with bitmap indexes. My testing shows that when Oracle doesn't have to >create a bitmap index on the fly, the queries respond wonderfully. So, I'm >wondering if our dabbling is actually a bad validation approach and, >instead, we should be 'running' with LOTS bitmap indexes instead of >'crawling' with only a few of them. In other words, maybe we're not "taking >all of our medication", as someone else put it recently. > >Any insight would be most appreciated. I'm not looking
Re: Bitmap Indexes
Hi, Here is an article about it bitmap indexes ... I hope this gives you information. Helen - Original Message - From: Shaibal Talukder To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 6:58 AM Subject: RE: Bitmap Indexes Kirti, Just cureous. Normally bitmap indexes ae ae used for low cardinality columns. I am confused when you state - "Just one table uses it(bitmap index), with b-tree indexes >for PKry and one other non-unique index" If you mean - you use Bitmap index for the non unique index with b-tree index for PKey I am OK with that. Shaibal >From: "Deshpande, Kirti" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Bitmap Indexes >Date: Thu, 07 Feb 2002 19:58:20 -0800 > >Ethan, > I have been using bitmap and b-tree indexes on the same table in our data >mart since 7.3.4. Never had a problem with query performance. Now we have >partitioned the tables in 8.1.7.x and most tables that were using bitmaps do >not need to use them anymore. Just one table uses it, with b-tree indexes >for PKry and one other non-unique index. No problems so far. > The only issue we had with bitmap indexes was the way it used up extents, >if those were not droppped before the dataloads. The problem still exists >with 8.1.7.x. Have not tried with 9i yet.. > >HTH, > >- Kirti > > >-Original Message- >Sent: Thursday, February 07, 2002 3:07 PM >To: Multiple recipients of list ORACLE-L > > >Posted on behalf of a friend... > > >Fellow Oracle data warehouse DBAs (if this isn't you, you can delete this >note now): > I have a question regarding Oracle's bitmap indexes. We have been DABBLING >with bitmap indexes with mixed results here. In >many cases, they are great solutions. In some cases, where we have a mix of >bitmap and b-tree indexes on the same table, we occasionally get into >trouble --- this has to do with the Oracle optimizer deciding, on the fly, >to convert a regular b-tree index into a bitmap. It does this so that it >can AND or OR the various bitmap indexes together. Sounds great on the >surface but when this occurs, response time goes in the toilet. > >In one situation we have, we have a fact table with two bitmap indexes and a >few other b-tree indexes. A particular query we run bogs down (NEVER >COMPLETES) with this mix of indexes. Based on the access path that's being >chosen, we know which b-tree index is being converted on the fly. If we >convert that b-tree index into a bitmap (so we now have 3 bitmap indexes and >Oracle does not need to create the third one on the fly), the query really >runs well. If we replace the bitmap indexes with b-tree indexes (so we only >have b-tree indexes), we get decent response times. (This is all on Oracle >8.1.7.2.0, by the way.) > >I'm wondering if the rest of you data warehouse DBAs have gone "whole hog" >with bitmap indexes. My testing shows that when Oracle doesn't have to >create a bitmap index on the fly, the queries respond wonderfully. So, I'm >wondering if our dabbling is actually a bad validation approach and, >instead, we should be 'running' with LOTS bitmap indexes instead of >'crawling' with only a few of them. In other words, maybe we're not "taking >all of our medication", as someone else put it recently. > >Any insight would be most appreciated. I'm not looking for insight on the >query I have used as an example. I'm looking for a generalized answer that >says, "Yes, if you start using bitmap indexes, you should go TOTALLY to >bitmap indexes" or, "Hmmm, we're using some bitmap indexes and some b-tree >indexes and don't have the problem you have". >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Post, Ethan > INET: [EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deshpande, Kirti > 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). MSN Photos is the easiest way to share and print your photos: Click Here-- Please see the official ORACLE-L FAQ: http://www.orafaq.
Identifying Long Running SQL's
Does anyone have a script that can identify the most inefficient SQL code running in the application ranking from least to most efficient? Helen J Mitchell Oracle Database Administrator E - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helen J Mitchell 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: Pin object into shared pool
Hi DBAs
I try on my test database to pin the table into shared pool and got error
message. (I already pin the most used packages and procedures in to shared
pool and it is ok ).
Is there anyway we can put table into memory.
Mitchell
SVRMGR> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
ORA-06564: object ARDB.SKILL_MAPPING does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at line 2
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 1:50 PM
> Hi DBAs
>
> It is recommend by Oracle to pin frequenly used packages into shared
pool,
> I had a table (read only) and mostly used,. Can I pin it into shared pool.
> What kind of objects could I pin into shared pool area?
>
>
>
> Thanks in advance
>
> like this:
>
> execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
>
> Mitchell
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mitchell
> 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: mitchell
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: Pin object into shared pool
Hi DBAs
It is recommend by Oracle to pin frequenly used packages into shared pool,
I had a table (read only) and mostly used,. Can I pin it into shared pool.
What kind of objects could I pin into shared pool area?
Thanks in advance
like this:
execute dbms_shared_pool.keep('ARDB.SKILL_MAPPING')
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
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: tablespace default maxextents
Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: grant to public
Hi DBAS if grant select a table to a public, any user would have the select right to this table. am i right? what is real meaning for public? thanks advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: RECOMPILE INVALID OBJECTS
Hi I just created last week. package: set pagesize 1000; set heading off; select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects where status='INVALID' and object_type <> 'PACKAGE BODY'; package body: set pagesize 1000; set heading off; select 'alter package '||owner||'.'||object_name||' compile body;' from dba_objects where status='INVALID' and object_type ='PACKAGE BODY'; Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 1:20 PM > Group, > Does anyone have some SQL handy that will re-compile INVALID objects for a > given user, that they would be willing to share?? > > > TIA > > Al Rusnak > 804-734-8453 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rusnak, George A. > 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: mitchell 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 database from AIX to Sun
I still prefer Aix for it logical volume manager as well as support from IBM that is much better then Sun and Oracle. I think Oracle is the worst on serive support. Hope my opinion is not offending anybody here. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 2:31 PM > > Kevin, > > Keep up on your D.H. Brown reports! :) > > Solaris surpassed AIX this year. I used to feel the same > way from the admin sense of AIX, but Solaris is much more > developer friendly than AIX. > > IBM seems to be favoring Linux now anyway. > > Jared > > > > > Kevin Lange > <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > om> cc: > Sent by: Subject: RE: export database from AIX to Sun > [EMAIL PROTECTED] > om > > > 12/12/01 10:00 > AM > Please respond > to ORACLE-L > > > > > > > first of all ... WHY would you want to leave AIX for SUN > ... What a step down . > > Second An Export file is an Export file is an Export file . or so > its said. > > The export should be the same for all OS's so it should work on whatever OS > you decide to move it to. Only difference might be limits on the OS as to > file size. > > -Original Message- > Sent: Wednesday, December 12, 2001 11:36 AM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus: > > It is possible to exp database from aix 4.3.3. oracle 8.0.5.1 and imp to > Sun Soloris 2.7 Oracle 8.1.7 > I have only done on same os. env before. > > > Thanks in advance > Mitchell > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mitchell > 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: Kevin Lange > 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: mitchell 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 database from AIX to Sun
Thanks Kevin for your advise. We still keep both AIX and SUN. It is money talking to decide we have more Suns. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 1:00 PM > first of all ... WHY would you want to leave AIX for SUN > What a step down . > > Second An Export file is an Export file is an Export file . or so > its said. > > The export should be the same for all OS's so it should work on whatever OS > you decide to move it to. Only difference might be limits on the OS as to > file size. > > -Original Message- > Sent: Wednesday, December 12, 2001 11:36 AM > To: Multiple recipients of list ORACLE-L > > > Hi Gurus: > > It is possible to exp database from aix 4.3.3. oracle 8.0.5.1 and imp to > Sun Soloris 2.7 Oracle 8.1.7 > I have only done on same os. env before. > > > Thanks in advance > Mitchell > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mitchell > 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: Kevin Lange > 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: mitchell 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 database from AIX to Sun
Hi Gurus: It is possible to exp database from aix 4.3.3. oracle 8.0.5.1 and imp to Sun Soloris 2.7 Oracle 8.1.7 I have only done on same os. env before. Thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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).
exp/imp unable to create unix index
Hi gurus
I had oracle1452 when imp/exp database from test to prod databases.
I have no idea why but found out from both imp and exp log that record
exp/imp is the same while unique index still exist in test database
exporting tablePA_PROJECTS_ALL 3160 rows exported
importing table "PA_PROJECTS_ALL" 3160 rows imported
exporting tablePO_VENDORS 57688 rows exported
importing table "PO_VENDORS" 57688 rows imported
Why, any idea?
Mitchell
This is the log from imp.
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "PA_PROJECTS_U3" ON "PA_PROJECTS_ALL" ("NAME" )
PCTFRE"
"E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS
"
"1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL
D"
"EFAULT) TABLESPACE "PAX" NOLOGGING"
IMP-3: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
IMP-00017: following statement failed with ORACLE error 1452:
"CREATE UNIQUE INDEX "PO_VENDORS_U2" ON "PO_VENDORS" ("VENDOR_NAME" )
PCTFR"
"EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144
MINEXTENT"
"S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1
BUFFER_POOL"
" DEFAULT) TABLESPACE "POX" NOLOGGING"
IMP-00003: ORACLE error 1452 encountered
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
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: Checking DB Status in NT env.
Hi Is there any easy way for our operator to check db status on NT env. any clue? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: surpress message.
Dear DBA
Help : how to surpress those msg when running the kshell
Mitchell
Result currently got: spool /usr/oracle/drop_user.sql
cgoqats:system SQL> select 'DROP USER '||USERNAME||' CASCADE ;'
2 fromDBA_USERS
3 where USERNAME not in ('SYSTEM','SYS') ;
DROP USER APPLSYSPUB CASCADE ;
DROP USER OEMMGR CASCADE ;
DROP USER APPLSYS CASCADE ;
DROP USER APPLSYSPUB CASCADE ;
This is kshell
###
#!/usr/bin/ksh
# 2001-11-02
###
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/8.0.5
export ORACLE_SID=cgoqats
###
sqlplus system/manager <http://www.orafaq.com
--
Author: mitchell
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: invalid object after imp
Dear DBAs I exp/imp whole OFA database and there are some invalid package bodies left on newly imported db. When I recompile it I got message "insufficient privilege to access object SYS.DBMS_LOCK" I check dba_sys_priv and both exp and imp databases are the same for those package bodies owner. I also checked dbms_lock and found everybody has exec privilege on the package. What is wrong. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell 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: Result of Analyze
You can use the Oracle supplied package DBMS_STATS to export the schema statistics into a table. There are separate procedures within the package to export stats for the entire schema, for tables or for indexes. Check out the docs describing the supplied packages. Glen Hamid Alavi wrote: List, How can I store the result of "analyze index index_name validate structure" for the list of all indexes, INDEX_STATS just keep the last index name. I want to keep all the result in a separate table. Any Idea??? Hamid Alavi Office 818 737-0526 Cell 818 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: system hanging where modify table stru.
I have some difficult to update ver540 on patch db_update_patche6.sql Hi DBAs I am running following script on the system with only one user sys but everytime it has exclusive lock with system hanging there for ever. I had to kill the process. Why. System is 8.0.5.1. and aix 4.3.3.1. No foreing key for this table. Thanks in advance. Mitchell This is the scripts: ALTER TABLE ver540.rate_code modify ( rauth01 char(3), rauth02 char(3), rauth03 char(3), rauth04 char(3), rauth05 char(3), rauth06 char(3) ); -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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).
NUMBER Datatype
Hi All, I have witnessed some strange behaviour (what I think is strange!) with the NUMBER datatype. I have a column which is defined as NUMBER - which means it is a floating point number eg. the QTY_CHARGED column in the following table ... SQL> desc eb_inv_item Name Null? Type - E_INVNUM NOT NULL NUMBER(10) INVITEMNUM NOT NULL NUMBER(10) INV_ITEM_TARIFF NOT NULL NUMBER(5) INV_ITEM_TYPE NOT NULL CHAR(1) INV_ITEM_CODE NOT NULL NUMBER(5) RATE_CHARGED NOT NULL NUMBER QTY_CHARGED NOT NULL NUMBER AMT_INV_ITEM NOT NULL NUMBER(11,2) DATE_INV_ITEM NOT NULL DATE CHARGE_SOURCE CHAR(1) INSTALLNUM NUMBER(10) When I select distinct values for the qty_charged column I get ... SQL> select distinct QTY_CHARGED from eb_inv_item where QTY_CHARGED < 5; QTY_CHARGED --- 0 .0 .032967035 .0 .03335 .065934069 .46 .66687 .9994 1 1.02479339 The strange part is the "0" and ".0" entries. I changed the column formatting in order to see more decimal places ... SQL> col QTY_CHARGED for 999.999 SQL> select distinct QTY_CHARGED from eb_inv_item where QTY_CHARGED < 5; QTY_CHARGED .000 .000 .032967034727335 .000 .033350718021000 .065934069454670 .460 .66686534882 .99940395355 1.000 1.024793386459350 To me they look like the same value but they are returned as distinctly different values. Can anyone explain this to me. I am unsure as to how the data got into this column in the first place. Thanks Glen -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Logical Backup for a large database
DBAs Last week one of my user dropped a table since we don't have any backup except for rman backup. It is not allowe me to do any recovery on 7/24 database. Anyway we recreate the table(we are lucky, this table hold parameters) This make me think of situation of lossing very important big table. We have about 1000 tables with bigget one of 8GB . Is there any idea how to perform a logical backup on a database with 150GBs. Or take a TSPITR in case of those kind of thing happen again. From my case, imp/exp looks impossibe from point of view of timing and spacing. The question will be the same for TSOITR on large database. Is there any other way to prepre those kind of situation. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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).
import table from SQL server To Oracle
Dear DBAs is there any tool available to import table from SQL 2000 server To Oracle 8.5 online or by other way. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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 32bit / 64bit
Dear DBAs How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3. The limit is 2gb for 32bit ? I only know if you switch from 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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
Thanks Jack. It is working now after commit. Mitchell - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 4:00 AM > > Hi, > > > Did you do a commit after you submitted the job? > > > Jack > > > > "Yadav, > Shailesh" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED] cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > ate.ny.us> Subject: RE: DBMS_JOB > Sent by: > [EMAIL PROTECTED] > > > 06-07-2001 22:20 > Please respond > to ORACLE-L > > > > > > Mitchell, > > What did you specify for next_date? Try to set it to something like a > second after you setup the job.. It should work and you should not have to > execute a new job... > I think JOB_QUEUE_PROCESSES is the maximum number of jobs that can run in > parallel and JOB_QUEUE_INTERVAL is the seconds after which the processes > wake up to execute any job. > > Shailesh > > -Original Message- > Sent: Friday, July 06, 2001 2:42 PM > To: Multiple recipients of list ORACLE-L > > > Dear DBAs > > I have submitted a job to run at a time but never go. I had to send > dbms_job.run(jobno) and then the job will run at defined interval. > > My question is > 1. I have to exec dbms_job.run(jobno) everytime to init the the new job. > 2. What is real meaning for JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL at > initdb.ora > > Mitchell > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mitchell > 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: Yadav, Shailesh > 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). > > > > > = > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender > en het origineel en eventuele kopieën te verwijderen en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > = > The information contained in this communication is confidential and is > intended solely for the use of the individual or entity to whom it is > addressed. You should not copy, disclose or distribute this communication > without the authority of Ernst & Young. Ernst & Young is neither liable for > the proper and complete transmission o
DBMS_JOB
Dear DBAs I have submitted a job to run at a time but never go. I had to send dbms_job.run(jobno) and then the job will run at defined interval. My question is 1. I have to exec dbms_job.run(jobno) everytime to init the the new job. 2. What is real meaning for JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL at initdb.ora Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Ora-1654 Unable to extend index on tablespace
Title: RE: Ora-1654 Unable to extend index on tablespace
Hi DBAs
Whenever I have the ora-1654, I
will
1. alter index/table name deallocate unused
2. alter tablespace name coalescs;
3. run querys to check dba_free_space and
dba_data_files
There are total 140 indexes on this tablespace with
setting init 1024k and next 1024k.
I got confused now that for message 'unable to extend by 256'. What is mean for 256
here?
The free space(byte) must be over 1024k here
to avoid ora-1654 for each of 140 index segments?
Thanks in advance.
Mitchell
This the query I run today. I only take first
few lines and last few lines.
compute sum LABEL 'TOTAL of SEGMENTS' of
totalofsegments on reportselect tablespace_name, bytes free_space,
count(bytes) segcount, (bytes *
count(bytes)) totalofsegments from dba_free_space where
tablespace_name=UPPER('&1') group by tablespace_name,
bytes order by tablespace_name, bytes;
TABLESPACE_NAME
FREE_SPACE SEGCOUNT TOTALOFSEGMENTS--
IDX_FINC_C70614
4,096
1
4,096IDX_FINC_C70614
24,576
6
147,456IDX_FINC_C70614
28,672
1
28,672IDX_FINC_C70614
364,544
1
364,544IDX_FINC_C70614
368,640
2 737,280
IDX_FINC_C70614
1,396,736
1
1,396,736IDX_FINC_C70614
2,801,664
1
2,801,664
TOTAL of
SEGMENTS
913,092,608
- Original Message -
From:
Koivu, Lisa
To: '[EMAIL PROTECTED]' ; '[EMAIL PROTECTED]'
Sent: Tuesday, June 26, 2001 8:08
AM
Subject: RE: Ora-1654 Unable to extend
index on tablespace
Mitchell have you tried coalescing
your tablespace? How big are your extents?
-Original Message- From: Mitchell [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 5:28 PM To: Multiple recipients of list ORACLE-L Subject: Re: Ora-1654 Unable to extend index on
tablespace
Dear DBAs
I have a tablespace for index
with 5 file with different size from 500mb - 2000 mb. Total tablespace size is 6g and used 5317mb
abote 86.13% usage.
I got the error today.
ora-1654 unable to extend
indx sechma.indexname by 256 in tablespace tablespacename.
The following is the query I got for the
tablespace .
We can see the index takes 92 extents and
maxextends setting is 8192. I then set
autoextend on a datafile then error is gone.
What is the reason to cause ora-1654 even there
are 700mb space avai. I also checked the
tablespace and index setting with both have next extend 1024k,
maxextend 8092.
Mitchll
SEGMENT
TYP BYTES NEXT_EXTENT
EXTENTS MAX_EXTENTS ---
---
- 8,192
C70614.FINC_INFO_ATTRIBUTE_080101_PK
IND 94,269,440
1,048,576
92 8,192
C70614.FINC_INFO_ATTRIBUTE_090101_PK
IND 52,457,472
1,048,576
51 8,192
-- Please see
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell
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 Reports
Greetings All, Has anyone out there figured out how to format the output from the STATSPACK report (statsrep.sql) into a format that is easily imported into an MS Excel Spreadsheet eg. comma delimited ... The way I see it there are two ways that this can be done. 1) edit the statsrep.sql file so that all queries produce delimited results or 2) process the actual output report using perl etc ... to produce a delimited file. Both methods look fairly complex. I am wondering if anyone has anything like this before I attempt it? Thanks -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: Ora-1654 Unable to extend index on tablespace
Dear DBAs I have a tablespace for index with 5 file with different size from 500mb - 2000 mb. Total tablespace size is 6g and used 5317mb abote 86.13% usage. I got the error today. ora-1654 unable to extend indx sechma.indexname by 256 in tablespace tablespacename. The following is the query I got for the tablespace . We can see the index takes 92 extents and maxextends setting is 8192. I then set autoextend on a datafile then error is gone. What is the reason to cause ora-1654 even there are 700mb space avai. I also checked the tablespace and index setting with both have next extend 1024k, maxextend 8092. Mitchll SEGMENT TYP BYTES NEXT_EXTENT EXTENTSMAX_EXTENTS --- --- - 8,192 C70614.FINC_INFO_ATTRIBUTE_080101_PKIND 94,269,4401,048,576 92 8,192 C70614.FINC_INFO_ATTRIBUTE_090101_PKIND 52,457,4721,048,576 51 8,192 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Locks
This one showed up on the list a couple of weeks ago. It has heaps of good diagnostic info. set linesize 132 pagesize 66 break on Kill on username on terminal column Kill heading 'Kill String' format a13 column res heading 'Resource Type' format 999 column id1 format 990 column id2 format 990 column lmode heading 'Lock Held' format a20 column request heading 'Lock Requested' format a20 column serial# format 9 column username format a10 heading "Username" column terminal heading Term format a6 column tab format a35 heading "Table Name" column owner format a9 column Address format a18 select nvl(S.USERNAME,'Internal') username, nvl(S.TERMINAL,'None') terminal, L.SID||','||S.SERIAL# Kill, U1.NAME||'.'||substr(T1.NAME,1,20) tab, decode(L.LMODE,1,'No Lock', 2,'Row Share', 3,'Row Exclusive', 4,'Share', 5,'Share Row Exclusive', 6,'Exclusive',null) lmode, decode(L.REQUEST,1,'No Lock', 2,'Row Share', 3,'Row Exclusive', 4,'Share', 5,'Share Row Exclusive', 6,'Exclusive',null) request from V$LOCK L, V$SESSION S, SYS.USER$ U1, SYS.OBJ$ T1 where L.SID = S.SID and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2) and U1.USER# = T1.OWNER# and S.TYPE != 'BACKGROUND' order by 1,2,5 / Ravindra Basavaraja wrote: Does anyone have any script that will help me find out the locks that are held in the database. We are facing a problem related to lock.One of the transaction is holding a lock on a table and there is another transaction wanting a lock on that table but waits for long time .Is there any lock timeout parameter that can be set on the database. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re:setup alert on oracle
Dear DBAs Is anobody here setup email alert sent to exchange server from unix box on Oracle or Oracle application server. Any suggested reading, white paper I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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 size db_block_size?
http://www.ixora.com.au/tips/creation/raw_log_files.htm
has some details related to log block sizes.
Christopher Spence wrote:
log
file block size is generally 512, 1024 bytes, dispite the file system block
size.
"Walking on water and developing software
from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original
Message-
From: hp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
12:11 PM
To: Multiple recipients of
list ORACLE-L
Subject: RE: How to size db_block_size?
ok
I'm confused.if i run df -g
i get this
(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment
size
and
if i run
select
max(l.lebsz) log_block_size
from
sys.x$kccle l
where
l.inst_id = userenv('Instance');
i
get
LOG_BLOCK_SIZE
__
1024
does
this mean my os block size is 1k?
if
so how do i change it to 8k?
-Original
Message-
From: Christopher Spence [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
9:26 AM
To: Multiple recipients of
list ORACLE-L
Subject: RE: How to size db_block_size?
df
-g "Walking
on water and developing software from a specification are easy if both
are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original
Message-
From: Herman Susantio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
5:14 AM
To: Multiple recipients of
list ORACLE-L
Subject: Re: How to size db_block_size?
Hi all, just
want to ask,How do we know the OS Block size from our system ?We use Sun
Solaris 2.7any command to show OS Block Size ? Thanks
& Regards Herman
- Original Message -
From:Nirmal
Kumar Muthu Kumaran
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, June 19, 2001 4:30
PM
Subject: RE: How to size db_block_size?
Hi Justin,
A larger data
block size provides greater efficiency in disk and memory I/O (access and
storage of data). Such cases include:
a) Oracle is
on a large computer system with a large amount of memory and fast disk
drives. For example, databases controlled by mainframe computers with vast
hardware resources typically use a data block size of 4K or greater.
b) The operating
system that runs Oracle uses a small operating system block size. For example,
if the operating system block size is 1K and the data block size matches
this, Oracle may be performing an excessive amount of disk I/O during normal
operation. For best performance in this case, a database block should consist
of multiple operating system blocks.
Hope that this
would helps you.
Nirmal.
-Original Message-
From: Justin Coleman
[SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19,
2001 10:06 AM
To: Multiple
recipients of list ORACLE-L
Subject:
How to size db_block_size?
Dear All,
Is there a recommended approach on
how to decide on the db_block_size for
your database? I am looking
to create a database that during the day will
be used for light OLTP, but during
the day and night will have heavish batch
jobs. Therefore I was intent
on using 8k or 16k blocks. Most likely 8k
blocks. But is there an approach
to actually chosing the correct
db_block_size?
Cheers for any help in advance.
Justin
_
Get Your Private, Free E-mail from
MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Justin Coleman
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).
--
Glen Mitchell NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software Email: [EMAIL PROTECTED]
Re: what's wrong with this...DBMS_SQL
Title: RE: what's wrong with this...DBMS_SQL
DBAs
I have tried to pin package into memory and I got
those message. what means for pls-00201 error here.
Mitchel
execute dbms_shared_pool.keep('SYS.STANDARD');
BEGIN dbms_shared_pool.keep('SYS.STANDARD');
END;
*ERROR at line
1:ORA-06550: line 1, column 7:PLS-00201: identifier
'DBMS_SHARED_POOL.KEEP' must be declaredORA-06550: line 1, column
7:PL/SQL: Statement ignored
LOB Storage Characteristics
Greetings All, I am using Oracle 81630 on Solaris 7 and I have a table which contains a LOB (CLOB actually). The DDL statement is as follows ... CREATE TABLE B_STATEMENT_TEXT_ORA (stmtnum NUMBER(10) NOT NULL, statement_content CLOB) STORAGE (INITIAL 100M NEXT 100M PCTINCREASE 0) TABLESPACE energy_proc_data_100M_02 LOB (statement_content) STORE AS b_statement_text_ora_lob (TABLESPACE energy_proc_lob_100M DISABLE STORAGE IN ROW STORAGE (INITIAL 100M NEXT 100M PCTINCREASE 0) CHUNK 8192 PCTVERSION 10 ); The details from user_lobs are ... SEGMENT_NAME TABLESPACE_NAME SEGMENT_TYPE BYTES EXTENTS -- -- -- -- -- B_STATEMENT_TEXT_ORA ENERGY_PROC_DATA_100M_02 TABLE 104857600 1 SYS_IL046179C2$$ ENERGY_PROC_LOB_100M LOBINDEX 104857600 1 B_STATEMENT_TEXT_ORA_LOB ENERGY_PROC_LOB_100M LOBSEGMENT 104857600 1 The DML operations on the table include SELECT, INSERT and DELETE. There is no UPDATE activity. Typically the data for each CLOB entry is larger than 4K so I am specifying that it is stored in the lobsegment and not the table. My question is one related to data access for the table, lobsegment and lobindex. Would there be any I/O performance benefit in having the table, lobsegment and lobindex located in different tablespaces (which would be located on different physical drives)? As you can see I can split the table and lobsegment/lobindex into separate tablespaces. I have tried to split the lobsegment and lobindex up into separate tablespaces but according to the 816 documentation this is no longer supported under 8i (depracation of the LOB_index_clause). According to Metalink the lobsegment and lobindex are co-located in 8i for a specific reason - but I cannot find what that is! Also, is there any way to specify a name for the lobindex, rather than rely upon the system generated name? Thanks Glen -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: simple question
alter tablespace tbname adddatafile '/u02/test.dbf' size 100m autoextend on next 8m maxsize 2000m; - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, May 29, 2001 3:52 PM > Does any one have an example of 'alter tablespace add datafile' > statement? I am having a little trouble.. > Thank you. > > > > > -- > 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: Mitchell 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 DBA vs. Oracle Apps DBA - Different? and how?
I had the opportunity to meet the architect of Quest Software's "Spotlight for Oracle Apps" product in a recent demo. His opinion was that a good Oracle Apps Administrator has a good understanding (and experience) of the business/functional side of the Apps system. That knowledge/experience needs to be combined with experience in pure database administration and operations. The bits in between, forms and webserver etc..., can be picked up along the way where proficiency is proportional to exposure to the product. From my limited experience with Oracle Apps I agreed with him due to some of the differculties I experienced. I was fortunate that I could remove myself from the management of the apps system (which was an auxilliary system to our main product development) and concentrate on our core product which is based on the Oracle Server! I'm lucky I guess!! Glen Gary Weber wrote: >>Sometimes I think Apps DBA is shorthand for senior developer. I'd like to wholeheartedly disagree. Administering Financials fell onto my lap as "just another Oracle-based product". There is much more to knowing this package than meets the eye from DBA prospective. The technology stack alone, with database, forms, web server, code...arr In my humble opinion, a good Apps DBA is not only proficient in database administration, but is also aware of large ERP packages and their implications. Gary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: Temporary tablespaces
Hi Steve, Is there any disadvantage to using a tempfile tablespace for the TEMP tablespaces used by the application? Apart from the fact that they are non-recoverable. In the past I have created TEMP tablespaces with datafiles. I suppose the nature of the temp tablespace is that it contains temporary data and does not need to be recoverable. Thanks for the info. Glen Steve Adams wrote: Hi Glen, A tablespace created with the CREATE TEMPORARY TABLESPACE command uses tempfiles instead of datafiles, and as such is often called a "tempfile tablespace". A tempfile tablespace is equivalent to a locally managed datafile tablespace with temporary contents, except that tempfiles do not participate in recovery in anyway and thus do not need to be backed up. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- From: Glen Mitchell [mailto:[EMAIL PROTECTED]] Sent: Monday, 21 May 2001 11:15 To: Multiple recipients of list ORACLE-L Subject: Temporary Tablespaces I am interested to know what the difference between a tablespace that is "created as temporary" and a "temporary tablespace" is? -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Temporary Tablespaces
Greetings to All, I am interested to know what the difference between a tablespace that is "created as temporary" and a "temporary tablespace" is. I am using 8.1.6.3.0. There are two commands that can be used ... create tablespace .. temporary; and create temporary tablespace ; According to the Oracle documentation ... A tablespace that is created as temporary (ie. create tablespace ... temporary) is used to hold temporary objects eg. segments used by implicit sorts to handle order by clauses. Also if you specify temporary you cannot specify EXTENT MANAGEMENT LOCAL. Whereas a temporary tablespace (ie. create temporary tablespace ...) is used to contain schema objects for the duration of a session. And you can specify EXTENT MANAGEMENT LOCAL. Can anyone enlighten me as to whether these two constructs are the same thing! I am assuming they are the same and are used for storing temporary session objects and sort segments and the only difference is that you can only create a locally managed temporary tablespace with one of them. Or, is the "create tablespace ... temporary" there for backwards compatibility?? A the "create temporary tablespace" is the new way to do things?? TIA Glen -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: strange problem
When using sqlplus to do the select you are most probably using the privileges
that have been assigned to you in a role. Privileges assigned to
a user through a role are not used (or applied) inside PL/SQL blocks (procedures/functions).
You need to have the appropriate privilege explicitly granted to the user
who is executing the procedure/function. In your case you will need
to explicitly grant select on the v$session view (or base table, sys.v_$session)
to the user account that is executing the procedure.
Glen
Narender Akula wrote:
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in procedure it fails why.
SQL> select osuser from v$session where username = 'IMAGE_INDEX' and
rownum
= 1;
OSUSER
--
MLOBO
this is ok...
CREATE OR REPLACE PROCEDURE n2 IS
tmpVar varchar2(100);
BEGIN
select osuser into tmpvar from v$session where username = 'MLOBO'
and rownum = 1;
dbms_output.put_line ('name '||tmpvar);
EXCEPTION
WHEN NO_DATA_FOUND THEN
Null;
WHEN OTHERS THEN
Null;
END n2;
this is failing says sys.V_$session must be declared.
what could be reason ?
> narender.akula
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Narender Akula
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).
--
Glen Mitchell NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software Email: [EMAIL PROTECTED]
Re: Shared Memory Problem
Upanesh,
Steve Adams' book, Oracle 8i Internal Services, has a really good explanation
of the shared pool behaviour (and other SGA structures). The following
is a brief summary of what is happening in your case.
Approximately half of the shared pool size is reserved (as free memory)
when the instance is started up. As the utilisation of the shared
pool increases with time the free memory is released into the shared pool.
The ORA-4031 error occurs when all of the reserved free memory has been
allocated. Flushing the shared pool coalesces contiguous free memory
chunks, creating larger memory chunks which can be allocated thus avoiding
the 4031 error.
You could also pin large and frequently used objects into the shared
pool to help alleviate the problem (especially sequences if you are going
to flush the shared pool). Pinning helps to reduce fragmentation
of the shared pool. By doing this you will also gain a better understanding
of the optimum size that your shared pool should be.
The final option is to increase the shared pool size (if you have memory
resource available).
Glen
Upanesh Patel wrote:
Hello,
We're Running Oracle 8.1.6.2 on Sun 420R with solaris
7. We have a front-end Siebel 2000 Sales Package. We
have about 50 concurrent users and a lot of Siebel
Workflow Process (which basically just route the work
from one user to the next... so lot of sql it send to
the server...) and have an SGA of about 120M of which
60M is shared_Pool_size...
Problem:
ORA-04031: unable to allocate 4096 bytes of shared
memory ("shared pool","unknown object","PL/SQL
MPCODE","BAMIMA: Bam Buffer")
It looks like Siebel is using bind variables, so that
should not be a problem. Also, this erros occurs
after the database has been up for about 5 days.
Is there a bug or anything with Oracle 8.1.6.2?
TIA,
Upanesh
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Upanesh Patel
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).
--
Glen Mitchell NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software Email: [EMAIL PROTECTED]
Re: change filename case
> Hi DBAs
>
> I have a lof of file name like IDP2000.z for tuxedo servers. I need to
> changed name to idp2000.Z.
>
> Mitchell
>
I rewrite the script and failed again. Any idea how to user typeset -l and
tr command.
Mitchell
#!/usr/bin/ksh
# init_idp.ksh
# 2001-05-09 /Mitchell
#
ls -la IDP* | awk ' { print $9 } ' > tobechanged
#
while read file
do typeset -l
lfile=$file;
cat $lfile | tr lzl [Z] > $lfile
mv $file $lfile;
done < tobechanged
#
echo 'Job is done !'
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mitchell
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: change filename case
Hi DBAs
I have a lof of file name like IDP2000.z for tuxedo servers. I need to
changed name to idp2000.Z.
I write a following script but never change.
Some suggestion
Mitchell
# init_idp.ksh
# 2001-05-09 /Mitchell
#
ls -la IDP* | awk ' { print $9 } ' > tobechanged
#
while read i
do
cat $i | tr [A-Y] [a-y] > $(i)
done < tobechanged
echo job is donn
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mitchell
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: ??? object visibility
Actually thinking about it, I should have said ... "The table name that the synonym (or view) is referencing is probably not called associate or is not in your current schema, hence the non-existence error..." Glen Mitchell wrote: My guess would be that you are actually looking at a synonym (or view) called associate. The table name that the synonym (or view) is referencing is probably not called associate, hence the non-existence error when trying to truncate the table called associate. Run the following query to verify ... select synonym_name, table_name from user_synonyms where synonym_name like 'ASSOCIATE'; Glen Janet Linsy wrote: Hi all, I got a table, when I do desc, delete, it works, but when I do truncate, I got error "table or view does not exist". Any idea? SQL> desc associate --> can see the table SQL> select count(*) from associate; --> works 1 SQL> truncate table associate; --> got error below truncate table associate * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> delete associate; --> works SQL> Thanks Janet __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED] -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: ??? object visibility
My guess would be that you are actually looking at a synonym (or view) called associate. The table name that the synonym (or view) is referencing is probably not called associate, hence the non-existence error when trying to truncate the table called associate. Run the following query to verify ... select synonym_name, table_name from user_synonyms where synonym_name like 'ASSOCIATE'; Glen Janet Linsy wrote: Hi all, I got a table, when I do desc, delete, it works, but when I do truncate, I got error "table or view does not exist". Any idea? SQL> desc associate --> can see the table SQL> select count(*) from associate; --> works 1 SQL> truncate table associate; --> got error below truncate table associate * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> delete associate; --> works SQL> Thanks Janet __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: Rename Datafile
Dear DBAs Question about alter database rename file '/oldlocation/datafile1' to '/newlocation/datafile1'; This command ususal to move a datafile to a new location. In case of rename file, I mean here '/oldlocation/datafile1' to '/newlocation/newdatafilename'; or '/oldlocation/datafile1' to '/oldlocation/newdatafilename'; I have never seen anybook mention this I guess step is 1. shutdown database (normal or immediate) 2. cp /oldlocation/datafile1 /newlocation/newdatafilename or mv /oldlocation/datafile1 /oldlocation/newdatafilename 3. startup restirct mount; 3 alter database rename file '/oldlocation/datafile1' to '/newlocation/newdatafilename'; or '/oldlocation/datafile1' to '/oldlocation/newdatafilename'; 4. check status of v$datafile 5. restart database Any suggestiion? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Fwd: please help
8) 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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
redo size and log_checkpoint_interval
Dear DBA I have 130 gb database running on 7/24 basis. redo logfile size is 40mb and oracle create about most to 400 archivive log. that mean log switch happend at 3-4 min at peak time. As oracle suggest, it is better log switch between 30min. (Why, if so that need more recovery time?) If I will increase the size to 100mb and make time around 30 min. How about Log_checkpooint_interval. My currently setting is 2097152 (20mb). log_checkpoint_timeout = 0 As my understand, the interval based on volume. If setting is 100mb, mean 5 check point will occured at 20mb interval. I am right? Any suggest? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Confused with v$session and v$process
Hi DBAs what is impact if I change the host name on unix with oracle installed. Mitchell
Re: RE:compare date
I got the date select * from backups where date(backup_date) = '2001-01-01' Mitchell - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, March 12, 2001 5:20 AM > > > backup_date like '%01/01/2001%' that may work > > OK > > Cheers > Ganti > > > > --- > > The contents of this e-mail are confidential to the ordinary user > of the e-mail address to which it was addressed and may also be > privileged. If you are not the addressee of this e-mail you should > not copy, forward, disclose or otherwise use it or any part of it > in any form whatsoever. If you have received this e-mail in error > please notify us by telephone or e-mail the sender by replying to > this message, and then delete this e-mail and other copies of it > from your computer system. Thank you. > > We reserve the right to monitor all e-mail communications through > our network. > -- > 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: Mitchell 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).
compare date
Hi is there any ADSM guru here to give me some help?. I used rman and adsm to backup database and I want to check the archivelog by query command at ADSM server so I can compare it to my oracle server. Select count(*) from backups -- adsm version 3.1 for AIX where owner = 'rman' -- owner and ll_name like 'Archive_log_s%' -- our archive log and node name = 'SP1DB2' -- db name and backup_date = '01/01/2001' -- never work ??? I tried quite few ways. Note: backup_date is timestamp field. Thanks in Advacne Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Problems Killing Sessions
This is internal oracle process I think. Check used_ublk from v$transaction before killing or maybe big rollback will going to hang everything Mitchell - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, March 08, 2001 1:20 PM > > > > > Friends : > > We have a problem for kill a session : > > We did : > > select * from v$session and got the result bellow : > > USERNAME SIDSERIAL# STATUS SERVER > -- -- -- - > 1 1 ACTIVE DEDICATED > 2 1 ACTIVE DEDICATED > 3 1 ACTIVE DEDICATED > 4 1 ACTIVE DEDICATED > 5 1 ACTIVE DEDICATED > USER0135 55317 ACTIVE DEDICATED > > > We applyed the command : > > alter system kill session '35,55317'; > alter system kill session '35,55317' > * > ERROR at line 1: > ORA-00030: user session ID does not exist > > and also, by Instance Manager we finished with kill immediate > > but the session is showed in the Instance Manager and v$session .. > > Why ? > > > Eriovaldo do Carmo Andrietta > [EMAIL PROTECTED] > Limeira/SP - Brasil > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eriovaldo do Carmo Andrietta > 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: Mitchell 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: questions: security on the unix
Thanks Brian. It is very strang. I have two database on 2 nodes. db1, one instance all 640 for datafile. db2 2 databases. that I have change the test database for 640. the error message said the datafile premittion error. owner is oracle:dba Mitchell - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 2:26 PM > Mine are all 640. > > Check who owns the datafiles. > > > Brian L. Anderson > Flunky/SA/DBA > Darton College > [EMAIL PROTECTED] > > > > > > -Original Message- > > From: Mitchell [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 23, 2001 1:32 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: questions: security on the unix > > > > > > DBAs > > > > Whis is right security for oracle datafile. 640 or 777 or others. > > > > I found today in my AIX that some oracle datafile is 777 or > > some are 660. > > But when I chmod 644 for those 777 files. The user could not > > do update and I > > had to change back. what is wrong > > > > How about sys file. Mine is 666 currently. I think should be > > 640. Any idea? > > > > Mitchell > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mitchell > > 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: Anderson, Brian > 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: Mitchell 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: questions: security on the unix
DBAs Whis is right security for oracle datafile. 640 or 777 or others. I found today in my AIX that some oracle datafile is 777 or some are 660. But when I chmod 644 for those 777 files. The user could not do update and I had to change back. what is wrong How about sys file. Mine is 666 currently. I think should be 640. Any idea? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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).
v$waitstat
Hi DBAs I have follwoing v$waitstat output show contention on undo header. When I add some rollback segments. the count and time is up. How can reset the count? or I do something wrong. Mitchell Tue Feb 06 page1 Disk Balancing Report CLASS COUNT TIME -- -- -- data block72468806502280 sort block 0 0 save undo block 0 0 segment header736 4273 save undo header0 0 free list 0 0 extent map 9 7 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header1094872237121 undo block 73679 503486 14 rows selected. After add another 3 rollback segment. Tue Feb 06 page1 CLASS COUNT TIME -- -- -- data block72530126505054 sort block 0 0 save undo block 0 0 segment header736 4273 save undo header0 0 free list 0 0 extent map 9 7 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header1094942237123 undo block 73691 503498 14 rows selected. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: temp tablespace
Rafiq I think I means not 'PERMANENT' but 'TEMPORARY'. in my case. After I alter tablespace mytemptablespace coalesce; it is still the same. No any extent released. I am not sure I can take temp tablespace offline or should I add another one and off./on the old one since we operate at 7/24. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 11:45 AM > > Alex, > Yes you are right if temp tablespace is 'TEMPORARY'. The situation he has > described is pointing that temp tablespace is 'PERMANENT' and thats why > his extents were not released/coalesced. > > Besides , with temp TEMPORARY tablespace , there are problems that space is > not completely released even after bouncing database and you have to > offline and online temp tablespace to get release used space upto 99%. > I am talking about 7GB+ tempspace on 7.3.4.4(1999) NCR UNIX 3.02 and that > was my personal experience at that time. > > Regards > Rafiq > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Thu, 01 Feb 2001 14:12:31 -0800 > > I disagree. pctincrease should be 0, you do not need to coalesce tablespace > if it is temporary. Segments in temporary tablespace are not dropped after > SQL statement execution ends. But if you want to drop all segments from > temporary tablespace the easiest way is: > > alter tablespace pctincrease pctincrease> > > Alex Hillman > > -Original Message- > Sent: Thursday, February 01, 2001 2:12 PM > To: Multiple recipients of list ORACLE-L > > > To resolve it now: > alter tablespace temp coalesce; > > for all the time set pctincrease to 1 (if 0) of temp tablespace > > alter tablespace temp default storage(pctincrease 1); > > Regards > Rafiq > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Thu, 01 Feb 2001 08:07:48 -0800 > > Hi. > > I have my daily routine to check segmetn whose next extent will not fit in > the single largest free extent in the tablespace. > This morning I found the my temporary tablespace is on the list . > > We have 1624M assigned for the temp tablespace. As my understatd temp > tablespace will extend itself as necessary and drop itself when operation is > done. > > I just wonder I should increase the size or wait to see because we just > have our application updated. > > > Mitchell > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mitchell > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohammad Rafiq >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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohammad Rafiq > 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 > th
Re: temp tablespace
Hi. I have my daily routine to check segmetn whose next extent will not fit in the single largest free extent in the tablespace. This morning I found the my temporary tablespace is on the list . We have 1624M assigned for the temp tablespace. As my understatd temp tablespace will extend itself as necessary and drop itself when operation is done. I just wonder I should increase the size or wait to see because we just have our application updated. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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).
