Re: Memory?

Hello Clinton, Here is script for calculating memory requirements (shared pool requirements). Tuesday, April 23, 2002, 5:38:33 PM, you wrote: CN Hi all. CN Does anyone have any idea how to calculate the amount of memory each user CN uses during a session? CN This needs to be done to

Re: OT - Linux question

[EMAIL PROTECTED] http://www.linuxmanagers.org On Tuesday 23 April 2002 19:53, you wrote: Dave, feel free to send any questions my way. I'd be glad help you out. joe Farnsworth, Dave wrote: I am going to start playing with RedHat Linux on a spare PC I have at home. Does anyone know

Re:

Can't you figure this out yourself with OS system level tools such as top in Unix or NT Task Manager in NT? ltiu On Tue, 2002-04-23 at 03:43, Clinton Naude wrote: How much memory is allocated to each login to Oracle? Is it not 20-30mb? I have heard people mention of 300mb? Surely this would

Re: Re: Oracle invents time machine - optimizer now faster than l

So that's how they implement flashback queries in 10i. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ

Re: Is sqlplus too slow to unload data?

Bruce, SQLPlus: set pages 0; set lines 1; set termout off; set trimspool on; set trimout on; set echo off; set feedback off; set verify off; set recsep off; set arraysize 2000; PDQOut is 3rd party product I test. I also test the PL/SQL from Thomas Kyte's book. I call it from sqlplus, and

Standby Database-No space on Disk

Title: Standby Database-No space on Disk Hello All Oracle 8.1.7, WINNT4. On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no

Re: Clob indexes

It would make sense, I would expect Oracle to take a shortcut with LOB Indexes, simply hard-coding the fact that access to the LOB should always be via the LOB index. Consequently there would be no point in thinking about them You could run SQL_TRACE prior to the dbms_stats call, and see if

Re: Currval and buffer gets

Problem solved but the mystery continue. I tried the describe in TOAD and got 'object x$dual not found'. The describe works in sqlplus. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 8:23 PM Hi

Partitioned oracle tables

Hi all, We have two partitioned tables, T1 and T2. T1 belongs to one user and has 8 partitions, 3 users have a table called T2 with 8 partitions. We are trying to : 1) Alter tables (T1,T2) drop all partitions 2) Take tablespaces holding the partitions offline 3) Drop tablespaces 4) drop users

Re: LOG_BUFFER Parameter Question

Yep, wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *physical blocksize> Anjo. Denham Eva wrote: Hello, I have been wondering about how to work out what the optimal LOG_BUFFER parameter, compared to the physical size of the REDOLOG file, for the best optimization and writes from

Re: LOG_BUFFER Parameter Question

log buffer gets written a) every 3 seconds b) every commit (more or less) c) 1/3 full d) 1M full thus its unrelated to redo log file size, and in most cases unlikely that anything above 512k-1m is going to give benefits. Check for 'log buffer waits' in your statspack data. hth connor ---

RE: Currval and buffer gets

Concurrency test from 1 = 10 on Solaris 8.1.7.3 revealed no crashes - using #!/bin/ksh for i in 1 2 3 4 ... do sqlplus u/p @the_test.sql done hth connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: as simultaneously as I could make it on W2K, 9.0.1.2 (which means the first one was

Re: Partitioned oracle tables

If you want to drop ALL the partitions, then just drop the table (with the normal 'drop table xxx'). hth connor --- Simon Waibale [EMAIL PROTECTED] wrote: Hi all, We have two partitioned tables, T1 and T2. T1 belongs to one user and has 8 partitions, 3 users have a table called T2 with 8

Re: Standby Database-No space on Disk

If you are using a tempfile for tempoary tablespace on the primary, then you don't need this at all on the standby (whilst its recovering) hth connor --- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote: Hello All Oracle 8.1.7, WINNT4. On our standby Database box, we have run out of space on

TOAD schema browser

Hello ORACLE-L, I'm connecting to oracle using TOAD under sys account - all works well. I can select from sys' tables and views, but when I start schema browser it shows schema for another user (not sys). Is it TOAD bug? How to fix the problem? -- Best regards, Sergey

RE: Design question: EFFECTIVE_?_DATE in a RATE table...

Chris, The only issue I see with the modified table is that when you wish to obtain history from your child table based on two dates, to determine which rate to apply you need to base your SQL on two records. However if you store starting and ending dates it will be easy to identify the

Drop Database Link

Hi folks! I tried following SQL SQL DROP DATABASE LINK SOFTEK.US.ORACLE.COM; DROP DATABASE LINK SOFTEK.US.ORACLE.COM * ERROR at line 1: ORA-02082: a loopback database link must have a connection qualifier Why such error is coming and how can i drop this

Re: Materilized view?

Hello I think that this line will cause the job to run every minute: start with sysdate next sysdate+ 1/(24*60). Change it to: start with sysdate next sysdate+ 1/(24) IMHO Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Re: Is sqlplus too slow to unload data?

As somebody who has insider's knowledge of pdqout and a decent understanding of exp and SQL*Plus, I think that you must have a good number of numbers and dates in your data. Both types (as opposed to strings) require conversion. Which is why exp, which dumps bytes 'as is', can be so fast -

RE: RE: Design question: EFFECTIVE_?_DATE in a RATE table...

My first move was to say that I fully agree with Aleem, but on second thoughts I think that the problem for current and historical values is more or less the same. Basically you can store either start and end dates, which may look a bit redundant since the end date of a row is likely to be,

Best way to drop and recreate and instance?

Hi All, I have *finally* got time to drop one of our test instances and recreate it (tomorrow), and wanted some feedback from all of you as to the best way to go around this? The current instance is 8.1.7. on a Win2K machine.. The reason that I'm dropping/recreating (some of you may remember

Re: TOAD schema browser

Hello, You should change the schema name from the list box, which is just under the toolbar. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] Sergey V Dolgov [EMAIL PROTECTED] pptus.oilnet.ru

RE: Is sqlplus too slow to unload data?

If you have PRO*C and a c-compiler, you can follow this link (you need both lines) to download a basic sqlunldr tool. It is almost as fast as exp. http://asktom.oracle.com/pls/ask/f?p=4950:8:646297::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:459020243348,%7BSQLDA%7D Caver -Original

Constraints

Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot validate (PBK.IDX_ROLLSON) - primary key violated what can I do to solve this? Please help me. Wouldnt it be enough to have unique values

Materialized View

I tried following SQL SQL create materialized view mat_dept 2 refresh fast with rowid 3 start with sysdate next sysdate+ 1/(24*60) 4 as (select * from dept@softek1); as (select * from dept@softek1) * ERROR at line 4: ORA-01435: user does not exist ORA-06512: at

RE: Constraints

Likely that your data in the table violates the constraint. Export the table, truncate table, add constraint and try importing to it -watch for violation of constraint during import. Ciao 'n best of luck. --- CSW -Original Message- Sent: Wednesday, April 24, 2002 3:09 PM To: Multiple

RE: Constraints

you must ensure uniquness and not null of each value in cells of column BUTIKS_NR -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT

Why wait?

There's something I don't understand. Why use the wait interface to investigate "db file scattered read" or "db file sequential read"? The end result is finding an SQL statement that does a lot of reads. There's no guarantee it's a poorly tuned SQL statement, just that it does a lot of

column level grants

Dear gurus ! Is there a way to give column level privileges in 8.1.7 , i.e. i have a table MYTAB (with more than 2 columns) , owned by AAA. I want to grant user BBB the following priveleges : select on AAA.MYTAB.COL1 update on AAA.MYTAB.COL2 is it possible at all in 8.1.7? thanks. --

RE: Best way to drop and recreate and instance?

Something to do with SYS.DUC$? Have you tried to delete all objects first (ie tables (with CASCADE CONSTRAINTS), views, types, packages, sequences, functions, procedures and synonyms - indexes, triggers and package bodies will go anyway) then to DROP USER without CASCADE ? Otherwise if your

Re: Constraints

hi roland ... it seems your table already had a data redundant data ...for a BUTIKS_NR column and when you try to add a new constraints it produced an error message try to remove redundant data ... or empty your table first... then add a constraint ... regards kang bedjo I'd

RE: Best way to drop and recreate and instance?

Never mind all - I cheated and used the Database Configuration Assistant to drop and create a new one.. ;P -Original Message- Sent: 24 April 2002 12:53 To: Multiple recipients of list ORACLE-L Hi All, I have *finally* got time to drop one of our test instances and recreate it

RE: Constraints

it should not contain any null values too other than being unique. Kranti -Original Message- Sent: Wednesday, April 24, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY

Re: TOAD schema browser

It doesn't work as it shows no items in the list box ..I face the same problem. Thanks and Regards Amit Nagar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/24/02 04:53 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Best way to drop and recreate and instance?

Hi Witold, Thanks for the reply.. I had already dropped all of scott's objects (although this does actually occur with *any* user that I tried it against), then connected as SYS as shown below, and still got the same error. I also re-ran catalog.sql and catproc.sql.. There were no other

RE: Best way to drop and recreate and instance?

Mark, to remove an instance on NT (not the software, just the instance) do the following: Use ORADIM -sid {sid} -delete to remove the NT services for the instance. then, simply remove all file structures for the database. That's all there is to it. The database is gone. On a side note - I

Re: Best way to drop and recreate and instance?

The db config assistanct has a 'delete db' option that works quite well. even if it cannot connect to the db, it will still get rid of the registry and services bits for the db hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, I have *finally* got time to drop one of our test

Re: Why wait?

Thats fine for expensive sql...but waits can be a whole lot more than that... (Trivial example) session 1: delete from blah where x = 1; session 2: delete from blah where x = 1; session 3: delete from blah where x = 1; etc The wait stats will quickly show up the problem here... hth connor

RE: Currval and buffer gets

For this script I get following results on 8161 on DGUX SQL 1 run time using view x_$dual in centiseconds=1400 run time using table dual in centiseconds=2600 - On 9012 on AIX I get SQL 1 run time using view x_$dual in centiseconds=600 run time using table dual in

Re: Drop Database Link

It looks, like you are specifying HOST (SOFTEK.US.ORACLE.COM) not DB_LINK. Do select from dba_db_links, and use the contents of DB_LINK column in your drop ... statement (not HOST column). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list

Re: Constraints

what can I do to solve this? RTFM about primary keys. They need to be unique and not null. [EMAIL PROTECTED] wrote: Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot

Re: column level grants

Do it indirectly, creating a view with col1 and col2 and granting BBB user privileges to select/update the view. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 8:53 AM Dear

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

Mogens, I bet Oracle would call it OWIi. As Micro$oft is appending XP to everything, Oracle puts an i to everything. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

Re: Partitioned oracle tables

Obviously, partitioned table needs to have at least one partition. Why don't you just try to drop the table, and then recreate it as non-partitioned (if that's, what you want). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: Memory?

Sergey, Attachments are not going through on this list. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 2:58 AM Hello Clinton, Here is script for calculating memory requirements

RE: Why wait?

I personally believe that monitoring the SQLArea for any poor performing SQL should also be done on a regular basis (*as well as monitoring the OWI (:P)*).. The end result should be to build as complete a picture as possible as to what is running through the system, where users are waiting, and

Re: Constraints

Hi Yes that would be enough however there may be null values and they are not allowed in a primary key (try unique key instead) There is also an exception clause I believe that will put the exceptions in a table for you to fix them (I don't know if this valid for creation though) jack

RE: column level grants

Andrey, Having difficulty getting access to the 8i docs just now but the below is an excerpt from the Oracle 7 docs. To grant BLAKE the REFERENCES privilege on the EMPNO column and the UPDATE privilege on the EMPNO, SAL, and COMM columns of the EMP table in the schema SCOTT, issue the following

Column level grants

I deleted the original mail, but You can find this topic in Oracle8i SQL Reference Release 3 (8.1.7) Part Number A85397-01 SQL statement GRANT look under section syntax grant_object_privileges_clause image Although there is a note column Specify the table or view column on which privileges

Re: Best way to drop and recreate and instance?

Mark, Shame on you. Ignoring good old ORADIM? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 9:03 AM Never mind all - I cheated and used the Database Configuration Assistant to

RE: Best way to drop and recreate and instance?

Hi Mark, Regarding your problem with dropping a user, I've seen something like that before - this was 817 on Solaris, and the DBA there was getting a ORA-00942 at recursive SQL when trying any CTAS. I ran a trace on the statement and found that Oracle was looking for a sys.snap$ table which

ORA-02074: cannot Rollback in a distributed transaction

Hello, I have this error 'ORA-02074: cannot Rollback in a distributed transaction' in a stored procedure of PL/SQL. In a FOR LOOP, when I have an error, I make a Rollback in the EXCEPTION and I get this error. I had looed up in the Server Messages but was not helpful. I would like to add that I

Re: Materialized View

I would start with checking what database links are vissible. Do a select * from all_db_links. A database link in the invoking schema should take precedence over a public one. Whatever link is being used, verify that you can connect to the remote database using it's connection symantics. You can

Number of File systems to use.

All, Although this has been discussed many times. My boss wants other opinions on this. We EMC storage whcih uses 9 gig disks. We also use veritas volume manager. We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have

Re: Is sqlplus too slow to unload data?

It's SQL*Plus. Love it to pieces, but it just dawdles when used as an unloader. It must spend a tremendous amount of processing just formatting or something... Never bother blaming the network or Net8 unless you are just trying to get someone off your back to delay for time. DBAs will say it

RE: Constraints

Roland have you tried a select butiks_nr, count(*) from pbk.k1 group by butiks_nr having count(*) 1 to check there really are no duplicates -Original Message- Sent: Wednesday, April 24, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hallo, I am trying to run this script,

good value for optimizer_index_cost_adj

Hi, Oracle 817/Solaris 8. Users are doing select joining using the PKs of 2 partitionned tables. Partitionned key and the primary key are the same. The access plan is a nested loop with a full table scan on the first table which hold 700 000 rows. The block size is 16K, I assume that's why

Re: LOG_BUFFER Parameter Question

Title: LOG_BUFFER Parameter Question Are you seeing any significant times from wait-events related to redo log buffering? - Original Message - From: Denham Eva To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 23, 2002 11:58 PM Subject: LOG_BUFFER

Cronjob

Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland -- 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

RE: column level grants

Yes , thanks. But , can i grant select on one column and update on another one using views ? I'm not aware of such a way. I also almost sure that there is no straight-forward way to do it, but are there any workarounds for this ? cheers. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL

Re: Clob indexes

I also think that since those indexes are created by Oracle, Oracle knows them. I'll trace the dbms_stats and I'll look for the 'bitand(flag,)' --- Jonathan Lewis [EMAIL PROTECTED] a écrit : It would make sense, I would expect Oracle to take a shortcut with LOB Indexes, simply

RE: Currval and buffer gets

All, I think the issue of using SYS.DUAL vs. X$DUAL is much beyond just response time. It is more related to easing a potential bottleneck in your database, in a production environment supporting multiple sessions. Given that it takes 5 LIOs (upto Oracle8i) and 3 LIOs (in Oracle9i for every

RE: column level grants

You need to determine the list of columns that you need to grant select on. Create a view tat returns these columns. Then you can: grant select, update ( col1, col2, etc) on view to your-user. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 10:38 AM To: Multiple

Re: Memory?

I have an idea .. PGA = UGA(user_session_data + cursor state)+stack space So Will it be enough or do I have to add sort_area_size to the value below? select * FROM v$SESSTAT a ,v$STATNAME b WHERE a.statistic#=b.statistic# and name like 'session pga memory' ; Bunyamin K. Karadeniz

Re: Why wait?

On Wed, Apr 24, 2002 at 05:33:25AM -0800, Connor McDonald wrote: Thats fine for expensive sql...but waits can be a whole lot more than that... (Trivial example) session 1: delete from blah where x = 1; session 2: delete from blah where x = 1; session 3: delete from blah where x = 1;

RE: Constraints Lookup

This will give all the tables whose constraints reference a given table /* All the tables that reference a given table in their constraints. */ SELECT a1.table_name Target Table ,a1.constraint_name Target Constraint ,d1.column_name Target Column ,b1.table_name Referencing Table

Zope usage

List, Has anyone heard of or used a product called Zope www.zope.org to build a web interface to the database? I found the reference to it in the DBA's guide to databases on Linux from Global Knowledge and I would like to be able to access the database throught the web until we get 9iAS

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens,

What is all of this talk about an OWL. Are they on the endangered list like Larry's DBA's? ROR mª¿ªm [EMAIL PROTECTED] 04/24/02 09:43AM Mogens, I bet Oracle would call it OWIi. As Micro$oft is appending XP to everything, Oracle puts an i to everything. Raj

RE: Column level grants - THANKS

thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wed, April 24, 2002 4:24 PM To: Multiple recipients of list ORACLE-L I deleted the original mail, but You can find this topic in Oracle8i SQL Reference

Re: Cronjob

[EMAIL PROTECTED] wrote: Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland man crontab -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED]

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

it was also mentioned at the Oracle of Oracles closing session, in the top 10 things I learned in San Diego :) --- Cary Millsap [EMAIL PROTECTED] wrote: Might have been Dave too, but I mentioned it in my Misunderstandings About Oracle Internals talk at IOUG on Tuesday...   Cary Millsap

RE: ORA-02074: cannot Rollback in a distributed transaction

I don't know if this is related to what we are going through here, apparently Oracle treats transactions via db link as 2-phase commit transactions unless SET TRANSACTION READ ONLY is used. Check dba_2pc_pending to see if you have hung 2-phase commit transactions. If you do, do a search

RE: Currval and buffer gets

Title: RE: Currval and buffer gets Waleed, Kevin, Jonathan, Alexander 8.1.7.0 on Windows 2000 run time using view x$dual in centiseconds=494run time using table dual in centiseconds=896run time using direct := in centiseconds=1007 Ramon -Original Message-From: [EMAIL PROTECTED]

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

Ok...ok...ok...enough talk... can somebody PLEASE publish a reference location of this script? Thanks, Mike -Original Message- Sent: Wednesday, April 24, 2002 8:39 AM To: Multiple recipients of list ORACLE-L please n it was also mentioned at the Oracle of Oracles closing session, in

RE: Currval and buffer gets

Gaja is correct. I had big problems recently with a highly concurrent application selecting from DUAL too many times, resulting in an extremely hot DUAL table. I wish I had knew this trick a few weeks ago. As it was, an bit of application tuning sorted it out. Jim -Original Message-

Re: ORA-02074: cannot Rollback in a distributed transaction

Let the outer-most calling process handle COMMITs and ROLLBACKs. Astoredprocedure should concentrate only on passing back error conditions appropriately. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, April

Re: Currval and buffer gets

I think there is a completely different level at which to view this issue. If your application is using dual like there is no tomorrow then there is almost certainly something wrong with your application design or code which is a much more significant threat to performance - both through

SQL question

How do I list all user accounts created in a database? And how do I list all user table indexes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: SQL question

-How do I list all user accounts created in a database? SELECT * FROM DBA_USERS -And how do I list all user table indexes? SELECT INDEX_NAME FROM DBA_INDEXES WHERE OWNER = 'MY_LUSER' Dave -Original Message- Sent: Wednesday, April 24, 2002 11:24 AM To: Multiple recipients of list

RE: SQL question

David, Look at DBA_USERS, DBA_TABLES, DBA_INDEXES and all other DBA_* views. All the info you are asking about is provided in these views. User: Select username from dba_users; Indexes: select table_name,index_name from dba_indexes where owner not in ('SYS','SYSTEM') Hope this helps. Tom

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

So, do you remember the other top 10 items?? Robert -Original Message- Sent: Wednesday, April 24, 2002 11:39 AM To: Multiple recipients of list ORACLE-L please n it was also mentioned at the Oracle of Oracles closing session, in the top 10 things I learned in San Diego :) --- Cary

Re: SQL question

David, Basic sqlplus as the dba. Select username from dba_users; select owner,index_name from dba_indexes there owner not in ('SYS',SYSTEM'); Brush up on your reading skills. ROR mô¿ôm [EMAIL PROTECTED] 04/24/02 12:23PM How do I list all user accounts created in a database? And how do I list

Re: good value for optimizer_index_cost_adj

Based on documentation, OPTIMIZER_INDEX_COST_ADJ seems to provide additional comparison information for the CBO in terms of the relative cost of different types of I/O. To make a long story short, I believe that guidance can come from examining timing statistics from the wait-events db file

Re: Cronjob

crontab -e On Wed, 24 Apr 2002, bill thater wrote: [EMAIL PROTECTED] wrote: Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland man crontab -- -- Bill Shrek Thater ORACLE DBA [EMAIL

access another user's data in a stored procedure - BECOME USER pr

I'm writing a stored procedure to be run by the dba. I want to provide the ability to manipulate data from a schema specified at runtime. I have the schema owner as an input variable, but I see three possible way to do this: 1) have the dba verify that all necessary DML privs on that

Re: Currval and buffer gets

Hello Gaja I checked the report from YAPP and library cache load lock accounts only to 0.75% of the wait time. 28 seconds during 6100 seconds between snaps. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 24,

Re: good value for optimizer_index_cost_adj

Best place to look is probably Tim Gorman's paper titled something like 'The search for intelligent life'. To be found on www.evdbt.com His argument, which I think is very sound, is that the most correct value for the parameter is the relative cost of a single block read compared to a multi

RE: Currval and buffer gets

Do you know of any reason that keeps Oracle implementing dual the way they have now and its effect on all the other PL/SQL functions? Also I saw something on the Metalink where some one inserted many records in dual and when selecting count(*) from dual it returns the right count but when

Re: TOAD schema browser

Hello What version of toad are you using. I downloaded version 7.2 a few days ago. Connected as sys, activated schema browser and got all sys tables in the list. I also got all the users in the drop list to select user. Yechiel Adar Mehish - Original Message - From: [EMAIL

Major Security Canyon in 9i!!!!!!

This was posted on Quest/Revealnets DBA Pipeline (by Andrew Simkovsky)... Sounds like a major security issue. I have tested this on 9.0.1.2 and it is a real issue: Someone recently sent me some information regarding a possible security flaw with Oracle's ANSI-compliant outer join syntax in

AW: SQL question

Select * from all_users Volker Schoen INPLAN RUHR E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Nguyen, David M [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. April 2002 18:24 An: Multiple recipients of list ORACLE-L Betreff: SQL question

RE: SQL question

Here's one that answers both questions in one query: SELECT u.username, i.table_name, i.index_namd FROM dba_users u, dba_indexes i WHERE u.username = i.owner (+) AND u.username not like 'SYS%' This will show all users and IF they have a table with an index, it will display these as well.

Alter command.Need urgent help.

Hi, I've worked on loading data into the database. By mistake, I havea typo intable attribute that needs to be fixed. Please help me how to write an sqlplus to correct my misspelled word or delete the generl_description attribute not the whole table. Here is an example of my table PART Part_id

RE: Major Security Canyon in 9i!!!!!!

I may be mistaken, but I think this is a few days old already. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique

Re: Currval and buffer gets

The acess path knows about DUAL and that it will return only 1 row. Create any dual table under another user and you will see that it returns all rows. Anjo. Khedr, Waleed wrote: Do you know of any reason that keeps Oracle implementing dual the way they have now and its effect on all the

RE: LOG_BUFFER Parameter Question

Alternatively, you size it until redo_log_space_wait goes away from v$system_events. -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 4:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: LOG_BUFFER Parameter QuestionYep,

Re: Number of File systems to use.

My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why would you software stripe it if you are using EMC? - Original Message - From: Johnson Poovathummoottil [EMAIL PROTECTED] To: LazyDBA.com Discussion

Re: LOG_BUFFER Parameter Question

On Wed, Apr 24, 2002 at 10:12:22AM -0800, Gogala, Mladen wrote: Alternatively, you size it until redo_log_space_wait goes away from v$system_events. it is v$system_event -Original Message- Sent: Wednesday, April 24, 2002 4:59 AM To: Multiple recipients of list ORACLE-L

RE: Number of File systems to use.

Now they have hardware striping. Regards, Waleed -Original Message- Sent: Wednesday, April 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L My understanding was that EMC does not stripe its disks. they just have mirror and RAID S. --- Sr DBA [EMAIL PROTECTED] wrote: Why

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

One I know was bring a coat to San Diego for those of you not at IOUG, San Diego, a city that is supposedly warm was COLD and everyone was freezing there they added a zero -- when you go to Tijuana, don't drink the water I don't remember the rest --- Freeman, Robert [EMAIL PROTECTED] wrote:

  1   2   >