Re: Hello

This looks like the Novarg worm What say people ? If yes, then thank you Listguru for filtering out the binaries [EMAIL PROTECTED] is a mass-mailing worm. The worm will arrive as an attachment with a file extension of .bat, .cmd, .exe, .pif, .scr, or .zip. When the machine gets infected, the

linux

Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- Please see the official

Re: another OCP question -- help me guys

Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . Don't apologize Prem, who else are you gonna call, ghostbusters? :)

Re: OCP question from Boson practice tests

Prem , OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and humbly, play by its rules. Right now if your are serious about giving OCP exams then please enable suspension of disbelief , don't ask why and just mug up the

Merge

Hello list I am using Oracle 9.2.0.1.0 , Consider the merge command : merge into table1 using on (column matching condition) then update set . when not matched then insert values ...; Is there a restriction that the column specified in 'column matching

Hi list

List, thanks to all of you I finally completed my OCP exams (thought they would never end) Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: order by

List can you please explain to me why select empno from emp order by empno ; is the same as select empno from emp order by sqrt(3.14); but not the same as select empno from emp order by dbms_random.value; What does sort by a random value do ? and why isn't dbms_random.value in the

sequence

Hello list and a happy new year to everyone, why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start

Re: order by

I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves totally different. Any ideas ? Also could you please tell me what does it mean when someone says order by non integer some_constant . An integer

Re: sequence

Joe you are absolutely right From the sql reference : Where to use currval and nextval If any of these locations contains references to both CURRVAL and NEXTVAL, then Oracle increments the sequence and returns the same value for both CURRVAL and NEXTVAL. Sorry for the rtfm question. I

Re: order by

Thanks Justin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 02, 2004 00:39 At 10:44 AM 1/1/2004, you wrote: I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a

order by

Hello list, Can someone please explain to me why the following order by clauses are valid and yield the same results : select empno, deptno from emp order by sqrt (1) ; and select empno, deptno from emp order by sqrt ( 3.14234 ) ; The docs say that in the order by clause you could specify only

merge

Hello list I am using Oracle 9.2.0.1.0 , Consider the merge command : merge into table1 using on (column matching condition) then update set . when not matched then insert values ...; Is there a restriction that the column specified in 'column matching

Fw: guidance

Hi tanel , thanks for the prompt reply. I was not able to understand your answer. What do you mean by new software installation ? What happens when you specify nls_lang in your test database ? are your messages in the specified language or do they remain in english ? - Original

Re: exam

Can you tell me if the same happens to you when you specify nls_lang in 9i release 2, or is it just me ? - Original Message - To: Jamadagni, Rajendra [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 02:17 Thanks anyway merry xmas - Original Message - From:

List please help

List , sorry to keep troubling you all but even if you are not interested in helping could someone just let me know if this happens by default in 9i release 2 or am I doing something wrong. I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify

Ignore: List please help

List, I did a reinstall and got the french language support back when I specified the languages during the reinstall. Thanks Merry xmas and happy new year :) - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, December 25, 2003 06:39 List , sorry to keep troubling you all but

seq

Hello list , why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle

specify nls_lang

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus

messages

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus

messages

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus

nls_lang

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus

create table as select

List , I am using Oracle 9.2.0.1.0 enterprise edn on windows. I have a table with a long datatype column. Is there any way of duplicating this table using the create table ... as select command ? or do I have to use the copy command ? Is the copy command present in 10g ? desc s_warehouse Name

grouping sets

List , I am using Oracle enterprise edition 9.2.0.1.0 on windows. I was trying to write the equivalent for a rollup , using grouping sets. This works : select dept_id, title, sum ( salary ) from s_emp where dept_id 35 group by grouping sets ( (dept_id , title ) ); This also works : select

dual

List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L

Re: dual

Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 23:49 It's because we designed it that way. In earlier releases (can't remember the specific version we brought this in with), you could put more than one row in

Re: What happened to Howard Rogers ?

Thanks lisa - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 20:54 His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To:

Re: Find CPU clock speed on HP-UX 11

Hi In solaris use prtconf command In HPUX Use the following script to determine the clock speed: HPUX=/stand/vmunix # 10.x C=`echo itick_per_tick/D | adb $HPUX /dev/kmem | tail -1 \ | awk '{print $2/1}'` echo Clock speed of `hostname` is: $C Mhz. - Original Message - To:

Re: Passed Net8 OCP Exam

Congrats dennis - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 17, 2003 00:54 I just passed the Net8 Administration OCP exam. This was my last exam, so I suppose I am now an OCP for Oracle8i. Thanks to everyone for their

Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows

Use the 'search and replace' functionality of ultraedit with 'regular expressions' enabled. First select 'replace all' for replacing % with ' Then select 'replace all' for replacing $ with ' - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday,

Homework

List, anyone finished the exercises in cary's book ? or at least chapter 5 ? . I tried www.oreilly.com/catalog/optoraclep. Hey maybe I can get you guys to write my term paper too :) Professor Milsap is a real stickler for assignments and will probably flunk me for copying. But seriously, Cary

Fw: encrypt traffic across internet?

List, so ssh forwarding will not work with windows ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 17:40 Hmm I wonder what the Metalink Technicians would have to say on this. Patrice. -Original Message-

Fw: encrypt traffic across internet?

I have a question about using the port forwarding feature of ssh. The initial connection to the listener gets tunneled thru by ssh. But what happens if the os is windows and bequeathing the connection is not possible and a redirect must take place ? Listener sends a redirect message back to

Re: How to copy recursive files in Windows? like unix cp -r

xcopy /e /h source destn - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 00:29 Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do

Re: Help with a scripting problem

c:\progra~1\RESOUR~1\robocopy - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 03:04 I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me

Re: encrypt traffic across internet?

Richard , I have a question about using the port forwarding feature of ssh. The initial connection to the listener gets tunneled thru by ssh. But what happens if the os is windows and bequeathing the connection is not possible and a redirect must take place ? Listener sends a redirect message

alter session

List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Re: 'shared pool'

Mladen , thanks for replying . Please tell me why does one get a difference between the values returned from v$sgastat and the shared pool size set in the parameter file ? Please , explain this to me . Arup explained that the memory required to manage the buffer cache is also allocated from the

Fw: 'shared pool'

Mladen ,is all this documented anywhere or is it all very common knowledge ? I can't believe that all you expert dbas would let Oracle take away tens of mbs of memory without telling you. - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 04:11 Mladen ,

'shared pool'

List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size.

Re: shared_Pool_size

Arup , wow I am so glad that you answered . You always come up with the real mccoy answers. However I have a few questions stemming from what you said: 1. I tried running select * from v$sgastat where pool = 'shared pool' order by 3; on my 9.2.0.1.0 enterprise edition. I was unable to get

contents of shared pool

List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size.

exam

Thanks Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that studying for an exam is different from studying. This principle doesn't seem to apply so much to backup and recovery , adminstration fundamentals

Re: exam

Congratulations. Thanks Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that studying for an exam is different from studying. This principle doesn't seem to apply so much to backup and recovery ,

Re: exam

The exam was well made. They were very keen on 1. the exact values of the various hit ratios 2. deadlocks. All in all I would say that the preparation for this exam is a lot more tougher than the exam itself. Performance tuning course is VAST. But I could be wrong about the exam, because

exam

List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: shared_Pool

I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003

Re: v$sort_usage

Please , do tell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 02:34 Yes. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL

v$sort_usage

List, I am unable to find v$sort_usage in the 9i docs, though this synonym exists. Any idea why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

shared_Pool

List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried

shared pool size

List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried

Re: guidance

Tanel , good you drew that smiley . I am so worried about this exam that for a minute there I was noting down what you wrote. Thanks for cheering me up though. Here is a question for you Which two statements about row migration are true? (Choose two) A. Row migration is caused by a PCTREE value

Re: guidance

Thanks O'mladen one. No really, thanks , good advice. I am really going hyper about performance tuning exam. The course is so vast, and the exam so expensive. Honestly how can you test a newbie in performance tuning ? shouldn't it be a part of ocm ? Instead of putting that riduculous condition

Re: shared server connections

Mladen, aren't you talking about connection multiplexing and not connection pooling ? Isn't pooling is supposed to carried out by the dispatchers themselves. Let me know if I should rtfm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday,

Re: 10g: SQL Plus

In nt cmd shell , you could make copy pasting easy by going into properties and selecting 'quick edit mode' . In fact you could make this behaviour the default by choosing 'save properties for future windows with same title'. Then you need not select mark and copy , etc . Just use the right and

Re: Hiding passwords

In ntfs you can set permissions on a file . But that wouldn't stop a member of the adminstrator group. What you need to do is to aditionally encrypt the file or folder as well. Then no one else can even list the contents of the folder, not even another administrator. In xp its as easy as right

guidance

List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL

shared server connections

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and

Re: 10g: SQL Plus

They were supposed to get rid of sqlplusw - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 22, 2003 23:09 Hej Jay Yes it stil there :-) Jay Wade wrote: Hello: Was watching Larry Ellison's key note and he mentioned

query rewrite system privilege

List, I finally got an answer to the problem I was facing with materialized views and the 'query rewrite' system privilege . Thanks for all your help especially mladen and thomas. - Original Message - To: [EMAIL PROTECTED] Sent: Saturday, September 20, 2003 00:42 Hello, The answer

pct_direct_access for a secondary index on an iot

Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Can someone help me by telling me what I need to do. I have done the following : --First create the iot with a

Re: 'query rewrite' system privg

So then a user without query rewrite system privg, would be able to create a materialized view with enable query rewrite clause, but not enable query rewrite for himself. But this user without query rewrite system privg, would still be able to sucessfully execute : alter session set

Re: SQL help needed

Hey there kirti , good to have you back. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 19:09 Hello All, Thanks for your wonderful ideas. I just forwarded those to my dear Developer (my wife, that is :) After

Re: 'query rewrite' system privg

Mladen , so what you are saying is that even if a user doesn't have 'query rewrite' privg but has create materialized view privg he can create a materialized view with query rewrite enabled and sucessfully execute 'alter session set query_rewrite_enabled=true;' but even then query rewrite

'query rewrite' system privg

Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user

Fw: pct_direct_access for a secondary index on an iot

Resending , didn't seem to have reached the list the first time. Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Can someone help me by telling me what I need to do.

db_file_multiblock_read_count

Hello list, seeking your personal opinions and experiences about db_file_multiblock_read_count. What do you all set your db_block_size and db_file_multiblock_read_count to? How did you all come to decide that those values would suit your systems ? Any windoze user here who can tell me how can

ORA-03113 on using create_stored_outlines

Hello list I need your help with a problem I am having whenever I start using outlines. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED]

Resynchronizing the stored outline definition

Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from

Re: alter system reset

You are correct arup The parameter originally existed as *.parameter=value After running alter system set parameter=value sid='lahiri' ; it now exists as lahiri.parameter=value So either I specify the sid name while setting the parameters or I should use the following to reset the parameters

Re: Privileges associated with Role

dba_sys_privs role_sys_privs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:44 Hi List How to look for all the privileges associated with particular Role(for example R1)? -- Please see the official ORACLE-L

Re: Resynchronizing the stored outline definition

Duh,oh Thanks But Jared , the problem was that the FM itself told me to type : CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1; Ref : Oracle 9i Database Performance Tuning Guide and Reference a96533.pdf page 7-9 , Chapter 7 : Using Plan Stability to Preserve Execution Plans, Section : Example

Re: alter system reset

Yes , opened up spfile in a text editor and undo_suppress_errors exists. But I get the error , no matter which parameter I try to reset. ex: undo_management, undo_tablespace, undo_retention, pga_aggregate_target, workarea_size_policy, shared_pool_size, sort...etc, etc However when I open the

Re: alter system reset

Mladen , you seem to be correct, I checked the spfile and the parameters I try to modify exist there, but reseting them takes one extra step Say for example I find that undo_suppress_errors=false in the spfile. Now if I try SQL alter system reset undo_suppress_errors scope=spfile sid='lahiri' ;

Re: How can I measure my DB performance.

I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 06:04 Start by installing and

Re: How to find the session holding the library cache pin.

run catblock.sql to create dba_blockers and dba_waiters @?\rdbms\admin\catblock.sql - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 01:54 dba_blockers this doesnt install by default. i cant remember which script runs it.

book

Hello list any recommendations about buying a book on oracle internal working , oracle kernel ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

Fw: book

Sorry to repost but forgot to mention, that I needed a book for Oracle 9i Hello list any recommendations about buying a book on oracle internal working , oracle kernel ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]

alter system reset

Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE

V$cache

Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys .

Fw: V$cache

Sorry for the trouble list. found out need to run ?\rdbms\admin\catclust.sql thanks - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 13:46 Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist'

Re: Hey Jared

Sobig -F does carry out spoofing , but Jared here is a question : either which way (spoofed or not) wouldn't list-guru remove all attached binaries ? Anyway I am not going to open any such mails. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday,

Killing jobs

Hello list Q1. How can a dba remove the a job scheduled by another user ? DBMS_JOB does not allow a user to touch any jobs except their own. Q2. Every time I schedule a job using dbms_job it doesn't show up properly in dba_jobs or all_jobs or user_jobs until I logoff and log on again . Let me

Re: Problem with Autotrace ?

I don't know much about Oracle, Is there a spelling mistake in the command you gave ? SQL set autot trace - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 28, 2003 09:19 Guys, when i try the same from a different machine,i get the

session_cached_cursors

Hello list , Performance tuning docs say that : To enable the caching of session cursors you must set the initialization parameter set session_cached_cursors. You can also enable it dynamically with alter session set But neither of the following works on 9.2.0.1.0 enterprise edition (win32)

Re: Advice needed on dbms_shared_pool value

Hi Tanel , I was preparing for the 9i performance tuning exam , that is why I was dealing with stuff like DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD. I know its even below the last possible thing you would want to tune in real life, but theoretical stuff seems to be a favourite with ocp sometimes.

dbms_job

Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was

DBMS_SHARED_POOL

Hello list, 1. Can the following statement be executed sucessfully only by the sysdba ? EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD (25165824 ) ; 2. ?\rdbms\admin\dbmspool.sql creates dbms_shared_pool . And it explicitly grants execute on dbms_shared_pool to execute_catalog_role.

Re: dbms_job

Thanks pete - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 02:44 Hi The package dbms_system is now private, the body and header are both created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file

Advice needed on dbms_shared_pool value

Hello list I needed your advice on the following : 1. What value do you all specify in DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) ? (1.a.) Should it be set equal to the shared_pool_size ? (1.b.) Should it be greater than shared_pool_size ? (But wouldn't that be impossible. The free

Re: dbms_job

Thanks chris. Let me know if you find out anything more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 23:39 It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a

Exam

Hi list, I am going to give my Oracle 9i dba fundamentals II ( backup, recovery , networking) exam tomorrow (7th july) . Any last minute advice ? Really nervous about it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat

Re: controlfile backup obsolete above 2 days

Thanks chip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:10 : MetaLink Bug 2458246 (fixed in 9.2.0.2) : : DENNIS WILLIAMS wrote: : : Offhand it sounds to me like you may have uncovered an error. I would search :

sql loader question

Hello list I have a doubt regarding the following question : ** SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes.

Re: Drop Tablespace

OMF ? What was the name of the file ? You can tell from that whether its omf or not. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 02:05 : Hi List, : : Today I have dropped a big tablespace(4 Gig) as soon as I dropped it

exam

Hello list, I am planning to appear for my Oracle 9i database fundamentals II exam ( 1z0-032 ) on the 7th . I would be grateful for any advice , pointers ,etc. Bit nervous cause it looks tougher than 1z0-031 ( dba fundamentals 1 ) thanks ... -- Please see the official ORACLE-L FAQ:

Re: RMAN Recovery Question: Restore with loss of control files and no catalo database

Hi Timothy , I am guessing about the following answers, and I work on 9.2.0.1.0 but anyway here goes : (1) How do I recover from a RMAN backup to disk if I have lost all the original database files (control files, data files and redo logs) In nomount First run SET DBID SET UNTIL SEQUENCE number

Re: What are the restrictions in naming an Oracle SID/Database?

DB_NAME specifies a database identifier of up to 8 characters. The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. Oracle removes double quotation marks before processing the database

TSPITR or PITR

Hello list I came across the following question in the TMH exam guide for 1z0-032: Chris, a DBA, while performing maintenance tasks accidentally drops a very important table. What is the best method available for Chris to recover this table if he is aware of the time when the table was dropped?

Advice

Hello list , I am planning to appear for my Oracle 9i database fundamentals II exam ( 1z0-032 ) on the 7th . I would be grateful for any advice , pointers ,etc. Bit nervous cause it looks tougher than 1z0-031 ( dba fundamentals 1 ) thanks ... -- Please see the official ORACLE-L FAQ:

  1   2   >