Re: Too many db calls

Cary M., Connor M., Thanks very much. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Too many db calls

n SQL statement in a PL/SQL loop, which > could be rewritten as a single SQL statement. But is this the single, > commonly seen cause for this problem, or are there other common ways > this > inefficiency is introduced? > >

Oracle World was great

that surrounded their booth ... which turned out to be a piece of string. :-) For people that attended the entire event, does anyone have a favorite paper that was presented? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat

Re: RE: RE: CONSISTANT GETS

> Hold the press. NOT IN better than NOT EXISTS? > If so is there any supporting evidence out there? I think you're joking, but if not there's a nice comparison chart of several tests in Harrison, p. 268. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

Too many db calls

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Theory v Practice

27;) 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:

Re: bioinformatics

LE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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

Re: Performance monitoring

is to have the manager pull the users into a meeting and get them to identify the ten business transactions that are most important to them. Find out if any are too slow. Find out if anything is too slow. Monitor that. Tune that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

Re: Index - To use OR Not ?

Title: process size limitation on HP-UX >> Qs. How is the Number of Block Visitations to be Found for Both the Index Scan & Full Table Scan ?   You could use Autotrace.  That will show blocks read, indicating logical and physical reads.  You could also use TKPROF. - Original Message --

Re: Houston, do I have a problem?

RACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE y

Re: Larry Ellison in Playboy

as his current goal, the main big goal he's working on, says they are making progress, that right now they are "in the middle of it." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: data modeling question - child table with multiple parents

rep_id, cust_code, EMP has manager_id, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

OT - IBM buys Price

ter, for executing that strategy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acce

Re: Foxbase to Oracle

amed users." The topic generated quite a bit of discussion and comparison of the two databases. I -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Di

Re: Index performance

FAQ: http://www.orafaq.com -- Author: Greg Moore 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

Re: Index questions

bles) an alternate solution is to code two SQL's in PL/SQL using an IF statement ... IF :x = 'N' then ... execute the SQL that's hinted to not use the index, ELSE execute the SQL that's hinted to use the index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.

Re: Index questions

What's CBT? > If we have a column of 'Y','N' values, the index will > not help with CBT(usually most of the values are 'N'). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City N

Re: Re: Buffer busy waits are 10.96% of non-idle waits

"data block" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

Re: How to learn XML ?

steve meunch wrote an xml book -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: performance

Nalla, Is your database currently using a single RAID 5 device only? Or what? How many separate disk devices does your database use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Questionable V$SQLAREA Statistics

What version of Oracle? > 1) I have a 400,000 row table table which is cached. How has the table been cached? Alter table XXX cache? Or with a KEEP buffer? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Netw

Re: the ora certified masters cert, yet again

Rachel, Of all the people who attend the conference, do you happen to know how many actually go to the trouble of voting for best presentation? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Sql query

2 versions of SQL + TKPROF excerpts   8.1.6,  Solaris   SQL version #1   select count(*)   from customers c , sales s  where c.customer_id = s.customer_id(+)    and s.customer_id is null          count  cpu elapsed disk  query

Re: Deleting large table and the correct log buffer size

icial ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

Re: Log file synch / direct path writes

e. Then SELECT from the test table, doing a group by and count(*), so you can see which files are involved with these waits. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 5

Re: Management Reports

e, in which you suggest ideas, report successes, or beg for more disk drives. ;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Nologging index tablespaces?

creating the index. There's a chapter on direct loads in the Concepts manual that has a specific list of operations that are not logged if you invoke nologging. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network

Re: Correct way to determine freelists and freelists groups

> I try to use table_access_path.sql but got > stoped at @save_sqlplus_setting On the page where you downloaded the script, click on and read "Prerequisites." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED]

Re: Correct way to determine freelists and freelists groups

>> Are there any scripts table_access_paths.sql from www.ixora.com.au will suggest number of freelists for a table -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (85

Re: Adding processor to Oracle server

There are reports of an additional CPU slowing the system down in certain cases. Paper, Performance Management Myths and Facts, Cary Millsap, www.hotsos.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network

Re: "snapshot too old" error - strange

error problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: "snapshot too old" error - strange

-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo

Re: Diagnose Slow System

e official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMO

Re: Diagnose Slow System

es. Would I not also investigate on my own? No. I know my > apps, he doesn't unless he's come onsite. But oraperf can give me some > generic guidelines and places to start looking > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET:

Re: Diagnose Slow System

> the YAPP analyzer at www.oraperf.com anyways.. The last part of the oraperf report has suggestions for items to investigate and tune. Is oraperf really good at spotting the key tuning opportunities? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Mo

Re: Diagnose Slow System

eers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

Re: I/O EVENTS

seeing these two totals? Thanks. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Re: I/O EVENTS

onCallsAvg > -- -- -- > SQL*Net message from client 984.01s 49.6% 95,161 0.010340s Cary, To me it looks like the average wait is about one hundredth of a second. I must be missing something. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Mo

Re: I/O EVENTS

27;t allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. These little hints, and half sentences that end with an ellipsis, are getting on my nerves! ;-) - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq

Re: I/O EVENTS

fficial ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: I/O EVENTS

> Can I assume a i/o bottleneck from the following > > select * from v$system_event > order by TIME_WAITED; No. Wait events may only make up a small amount of processing that Oracle is doing for you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg

Re: Deadlock ORA-60

esults. Go figure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acce

Re: Basic Database Question

Title: Strange problem with charactersets emp has 20 rows dept has 0 rows   select ename   from emp e  where not exists ( select 'x'    from dept d   where e.deptno = d.deptno    );   This one too will return rows even though dept has no rows. So what i'm ask

Re: Improving Oracle Performance

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: Response time analysis and TKPROF

ad on whether wait events are significantly affecting this particular SQL statement. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Response time analysis and TKPROF

> But this is all on the server side, so in Oracle .. to get what I apparently want it would be most accurate to use v$sesstat and v$session_wait ? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Netw

Response time analysis and TKPROF

minus total CPU time? Is this formula perfect, a very good and workable approximation, or way off? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Ca

Re: Curious question about flushing the Pool

benefit to me, where all of our code is VB, and the developers refuse to use bind variables. My sql area is .5 GB and is 95% garbage. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Why wait?

> clearly defined art than using CHRs! > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve > Mercy - NOT getting something we deserve > > Click on 'http://www.needhim.org' for Grace an

Re: Why wait?

Anjo,   You wrote:   The problem in Oracle is that wait events are not broken down per SQL statement (only on the instance and session level). There are products that out there that do this for you, but that would be completely different post ;-)   I'll bite.  Which products do this?   Do t

Re: Any scripts to check the health of the database

www.evdbt.com/library.htm has a health check script -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: good value for optimizer_index_cost_adj

*. And other examples elsewhere, where "db file scattered read" is found to be associated with reads from an index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: Why wait?

d reads" and "db file sequential reads"? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

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 r

Re: Re:Oracle licensing

riginal Message - > Humm, Can you say 'AW Sh&t!!!' > > Dick Goulet > > http://www.sacbee.com/content/politics/story/2219532p-2613285c.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network S

Re: ioug-a question

aq.com -- Author: Greg Moore 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, s

Re: RBS question

There is a section on Reducing Contention for Rollback Segments that tells how to identify this type of contention and remedy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Long running SQL Problem?

58) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTEC

Re: Ticket tracking system

ssage > 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: Do programmers tune SQL?

ans they have to come to grips with DBA topics, and that's not a reasonable thing to ask. He should take a subset of his book (perhaps a third) and call it SQL Tuning For Developers, and give the current book an accurate title ... SQL Tuning for DBA's. -- Please see the official ORACLE-L

Re: Do programmers tune SQL?

In my experience it's about 10%, so most SQL tuning is done by DBA's. Is > that about right? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore > INET: [EMAIL PROTECT

Do programmers tune SQL?

What percent of developers know how to explain and trace SQL, interpret these reports and tune? In my experience it's about 10%, so most SQL tuning is done by DBA's. Is that about right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore IN

Re: odd explain plan

il 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 subscribin

Re: Tools for Scurity and Access to the Server?

Title: Tools for Scurity and Access to the Server? >>  Management would like to know if there is a tool that can monitor who accesses the server, what tool do they use and what they do.  Also is there a tool that can prevent users from accessing Oracle via any other tool other than the Appli

Re: More info on sql query running slow

additional index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces

Re: More info on sql query running slow

> weigh cost of adding a extra index. Maybe you can add this column to an existing index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor

Re: Cost vs Rule

y flipping the switch to RBO? RBO isn't part of the ANSI standard, so I don't think you're allowed to use it either. ;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: Cost vs Rule

th RBO. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Fav. Urban Legend...

Oracle started using another and this helped performance. So it seemed like the max of 5 was true. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Re: Hash Anti Join Requirements

_ANTI_JOIN is set to MERGE or HASH, or a MERGE_AJ or HASH_AJ hint is in the subquery" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Identifying Long Running SQL's

gt; also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inte

Re: Where does a DBA go from here?

al ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yours

Re: Unix Book

... forget the beginner books. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

Re: Hot backup and TEMP tablespace

cument this too in a DBA notebook -- if you leave, a new DBA who has to recover the database may be puzzled to find the backup is "incomplete," they may not know how to create a temp tablespace quickly, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gre

Re: Costs in explain plan

ee 100%. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

Re: Index Question

r larger values, you don't have much of a choice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

Re: Re: ACM SIGMOD-papers of interest #1

>> Where can I get a copy of >> " Scaling Oracle 8i" please It's a book. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

What?! Re: How to Drop a Table

Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

What?! Re: How to Drop a Table

Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: SQL Tuning

ng 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: Greg Moore INET: [EMAIL PROTECTED]

What?! Re: How to Drop a Table

Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Another Oracle DBA gets "The Bullet"

ww.orafaq.com -- Author: Greg Moore 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

Re: Messy Messy SQL

ildcard character, and as you mention this would allow use of the index. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public In

Re: Synonyms can be VERY bad for performance

can read all about it in Note ZZZ. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

v$sql and v$sqlarea

I want to understand the difference between v$sql and v$sqlarea. Apparently they are both views of the same x$ table. Does anyone know where I can view the code that creates these two views? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET

Re: Classes

would be if your company decided not to pay for his service. Craig's classes focus on his toolset, which is available free. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: Why does ittake long time?

Title: RE: Why does ittake long time? Also, there's no WHERE clause condition that joins the two tables.  So you're getting a Cartesian product.  Is that what you want?  It might be the reason the query is taking so long - Original Message - From: Nirmal Kumar Muthu Ku

Re: Move tablespace with no downtime?

Rachel and Jeremiah, Thanks very much. What about creating a new tablespace on the new disk device and then: alter table scott.emp move tablespace ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services

Move tablespace with no downtime?

Can I move a tablespace and all it's associated datafiles to a new disk device with no downtime? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Statspack Question

> so long as you look at the wait events, you will > be looking at your database's bottlenecks, and in the > world of Oracle Performance Tuning, that is all that > counts. What about v$sql? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moo

Re: Bind Variables

se hints to force the bind variable version to use the same fast plan that was used by the literal version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505

Re: Books or Websites that discuss RMAN?

ll and configure. But if you do have these requirements, then RMAN may be the only viable solution for you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Die

Re: distribution of the sleeps on the library cache latches

An excerpt from   PIRANHAS IN THE POOL,SQL PERFORMANCE KILLERSInvestigating the effects of literal SQL on Oracle performance   John BeresniewiczPrecise Software Solutio -- Effect of CURSOR_SHARINGA primary purpose of the 8.1.6 testing was to assess the impact the new CURSOR_S

Re: RE:

ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REM

Re: Meaning of V$WAITSTAT statistics

ious wait events might be high on your system and low on mine simply because of the way they're used, so no one really has any idea what to focus on at any given time? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Netw

Re:

27;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 O

Re: Meaning of V$WAITSTAT statistics

> From the performance perspective, you can safely > ignore the "save undo" statistics. Anyone know where I can find a list of the v$sysstat, v$system_event and v$session_wait items I can safely ignore? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

Re: How to tune treewalk sql statement

uthor: Greg Moore 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

Re: ORACLE VS. SYBASE

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

Re: Sqlplus tunning

t scrolling the rest will be there for them. Guess it depends on what your definition of fast is. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

  1   2   >