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

Re: Set processes at init.ora

, 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

RE: Oracle pricing ain't going down

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

Re: SGA

. 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

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

Re: SGA

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

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

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

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

Re: 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

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

Re: Set Email alert at NT

Alert: ORA_error !!!" [EMAIL PROTECTED] $HOME/alert_mefi Thanks in advance. Mitchell

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

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

RE: ORA-28030: Server encountered problems accessing LDAP directory service

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 accou

RE: ORA-28030: Server encountered problems accessing LDAP directory service

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

ORA-28030: Server encountered problems accessing LDAP directory service

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

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

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

Re: connect as internal

. 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

Re: table size.

,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

Re: table size.

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

Re: table size.

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

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

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

looking at notes in METALINK

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

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

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

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

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

Veritas Software

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

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

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

Re: Bitmap Indexes

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

Re: Pin object into shared pool

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

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

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

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

Re: RECOMPILE INVALID OBJECTS

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

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

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

exp/imp unable to create unix index

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

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

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

Re: invalid object after imp

. 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

Re: Result of Analyze

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

. 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

NUMBER Datatype

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

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

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

Re: Oracle 32bit / 64bit

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

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

DBMS_JOB

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

Re: Ora-1654 Unable to extend index on tablespace

with setting init 1024k and next 1024k. I got confused now thatfor 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

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

Re: Locks

RACLE-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: How to size db_block_size?

er 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:

LOB Storage Characteristics

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

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

Re: Oracle DBA vs. Oracle Apps DBA - Different? and how?

o: [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 Ene

Re: Temporary tablespaces

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 Mitche

Temporary Tablespaces

" 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

formation (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

: [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 Energ

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

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

Re: ??? object visibility

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: ??? 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

Re: Rename Datafile

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

redo size and log_checkpoint_interval

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

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

Re: questions: security on the unix

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

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

Re: temp tablespace

. 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