RE: collecting statistics

U can user sqlrowcount. This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s),

Re: Rman ... what do YOU need

Hi I think it was mentioned already, But case studies with real working examples (maybe include the scripts for demo environment) usually make things a lot more clear than plain text and syntax diagrams. Jack

Re: Explain: In List Iterator

There are two odd features I would pursue: There is no join to the customer table and that is why (I guess) you have a cartesian merge join between CUSTOMER and everything else. The second thing is that despite the inlist iterator, Oracle thinks that the rest of the query will return

Duplicating a database using RMAN, but not ALL tablespaces. How?

Hi All, I have been reading about RMAN and tested most scenarios needed for our environment but one still needs to be tested but I can't find how. If I want to clone/duplicate a database using RMAN but don't want the say tools tablespace duplicated . How do I go about this Also, Anybody have

Experiences with 9iRAC (upgrading from 8.1.5OPS on Tru64)

We are considering an upgrade from 8.1.5OPS on Tru64 to 9iRAC for a mission-critical server in the next few months. I would like to know about any happy or painful experiences and if there are customers whom we can talk to directly. Hemant K Chitale Principal DBA Chartered Semiconductor

Re: Does index need rebuilding when table is truncated

Beg to differ. The data segment for an index does have an HWM - it's just that nobody talks about it very much. Nevertheless if you dump the segment header block you will see an entry for the highwater; and if you have an 'index fast full scan' access path occurring, then the scan goes up to

ORA-00600 Error

HI All, We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is that the server is going down very frequently (3 times a day). The error code on the Alert file shows : ORA-00600: with arguments : [17112], [3461574976], [], [], [], [], [], []. Oracle support did not give

Any idea what is SESSION REC ?

Hi guys, Do you have any idea what is SESSION REC (from dba_audit_trail.action_name) Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: ORA-00600 Error

Kamel, this will be down to Oracle to fix. The dump itself is caused by a memory corruption. It may be worth running some hardware diagnostics on the box itself to check out the RAM. Otherwise you need to push Oracle for an answer. The usual questions apply: Have you relinked anything? Have you

Re: ORA-00600 Error

HI * From Metalink Doc ID: Note:47411.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 26-SEP-1997 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This

oracle on windows xp

Has anyone installed Oracle 8i personal edition on WIN XP with success? thanks, dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RMAN with Tivoli Data Protection for Oracle

Yep, we use it. You need to install TDP on every target server and then relink Oracle to use Tivoli's libobk.so (or libobk.a). This applies to version 2.1, version 2.2 does not require the relink stage. Ade -Original Message-From: Yahoo [mailto:[EMAIL PROTECTED]]Sent: 09 April

RE: DBA_SOURCE question

AFAIK, it has always been like that, how else would Oracle report error at Line 15 Col 26 ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

Re: oracle on windows xp

Dave: I have a Dell 8200 with XP Professional and 9i running on it with no problems. So, I would think that 8i would also fly. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 7:28 AM Has anyone

RE: DBA_SOURCE question

Dave, I was always curious about that too. The only guess I came up with was wither to help with debugging when compiling, or maybe when a procedure fails during execution to supply you with what line number is was at when the error occurred. Gives you a clue about how things work. Tom

InitCap Software or script?

I have a fellow DBA that has to do some data cleansing. He is looking for some software that can properly init cap a last name, like McDonald. Obviously, Oracle has an initcap function... SQL select initcap('GRABOWY') from dual; INITCAP --- Grabowy Elapsed: 00:00:00.50 SQL select

RE: RE: DBA_SOURCE question

Not quite the good reason, since triggers and views are stored in LONGs and you can get this type of message too... Remember that procedures were introduced with Oracle 6, and there were no CLOBs then. It was either a LONG (already used to store view text) or lines of varchars, which I think

Replication Question

Hi All, I have recently been handed the task of setting up master-master replication on our existing production environment (yes, I am in test to start!). Because this is an established site with a lot of historical data, we would like to use Offline Instantiation as detailed in Note 68657.1.

Re: DBA_SOURCE question

I believe that the reason was to avoid the use of LONGs... ...wise choice, too... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 8:38 AM Dave, I was always curious about that too. The only guess I came up with was

RE: InitCap Software or script?

Here's one way: SQL DEF val = Donald SQL SQL SELECT 2CASE WHEN LOWER(SUBSTR('val', 1, 2)) = 'mc' THEN 'Mc' || INITCAP(SUBSTR('val', 3)) 3 WHEN LOWER(SUBSTR('val', 1, 3)) = 'mac' THEN 'Mac' || INITCAP(SUBSTR('val', 4)) 4 ELSE INITCAP('val' ) END

MetaLink problems

FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization Required This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand

Re:MetaLink problems

Patrice, I just logged in with no problems. Does look like it's at your end. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 4/10/2002 7:23 AM FYI, I just went to MetaLink and clicked on the Login to MetaLink

Re: Favourite Urban Myth

On Tuesday 09 April 2002 20:03, Deshpande, Kirti wrote: Well Kirti, if you're going to morph this thread into stupid DBA tricks... We had one young fellow working for us that was new to unix. He had just discovered that he could run a job in the background via '' at about the same time he was

Re: Parameters Question

Context Jojo, context! Are you talking about PL/SQL, Oracle RDBMS init files, something else? Sounds like PL/SQL to me, but that would be Named parameter and Positional Parameter. Jared On Tuesday 09 April 2002 20:23, JoJo Zawawi wrote: Hi again, folks! Can someone please define: Named

RE: dedicated server

Hamid, What they mean by that is - assuming Unix here - set your ORACLE_SID, ORACLE_HOME, and ORACLE_BASE to the database you want to connect to. Then just issue svrmgrl or sqlplus. When you connect, you are connecting to the database specified in your ORACLE_SID variable. The same goes for

disk subsystem performance question

Hi all, We are running both a Hitachi 7700E and a 9960 disk subsystem here and we are getting ready to move our production DBs from the old(7700E) to the new(9960) Hitachi. We have had trouble in the past on the 7700E due to disk contention and layout, i.e. we weren't striped across the

Re: MetaLink problems

Worked for me. Maybe you're not holding your mouth right? Jared On Wednesday 10 April 2002 08:23, Boivin, Patrice J wrote: FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization Required This server could not verify that you are authorized

Re: Explain: In List Iterator

It appears that there are no join conditions on it. Can you say 'cartesian'? :) Jared On Tuesday 09 April 2002 15:13, Freeman, Robert wrote: Uh I'm just wondering about the customer table there... anything look odd about the use of that table in this query or am I missing something

Re: Experiences with 9iRAC (upgrading from 8.1.5OPS on Tru64)

My experience with 9i RAC was limited to a proof-of-concept installation and testing on a Sun Cluster; for what it's worth, the installation and testing went smoothly. Sun Professional Services was there with us, to set up the cluster and provide support during the test. You probably know this

RE: Differences between Oracle JDBC thin and thick drivers

But it's a very important difference. The thin driver, basically just the classes12.zip file, is slower than the OCI. The advantage for me is that I don't need an Oracle supported platform (mine is Linux on Alpha) to run the thin driver. For our upcoming JDBC stuff here at work, I can't

Re: MetaLink problems

I was able to logon after supplying my username and password. Did you double click by mistake and go right by the box to enter username and password, or did you try to check the box which says 'save this password in your password list'? You can't do that. Just a couple of ideas from having

Re: MetaLink problems

I have tried and entered to metalink too. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its

Re: MetaLink problems

Yep. Tested it and metalink works. Yechiel Adar, Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:23 PM FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization

Instance fails to start

Hi All! I have encounterd an interesting problem after attempting to make a change in my parameter file. I made a minor change in the date format, and upon shutting down (normal) and starting up, an error in the format was reported. I changed the format back to it's original form so that there

Re: MetaLink problems

I'm on metallink since 7:30 this morning (3 hours) Stéphane --- Boivin, Patrice J [EMAIL PROTECTED] a écrit : FYI, I just went to MetaLink and clicked on the Login to MetaLink link, and got this: Authorization Required This server could not verify that you are authorized to access

RE: MetaLink problems

Title: RE: MetaLink problems Logged in with no problems. Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 11:24 AM To: Multiple

RE: disk subsystem performance question

John - I haven't experienced the Hitachi disks. To me the key question is how much battery-backed cache the subsystem has. I believe there tends to be a gap in knowledge between DBAs and the disk people. The two don't always understand each other or speak the same language. The Oracle books tend

RE: MetaLink problems

Patrice - I got in fine. I noticed a message from Oracle saying that accounts are expired after 6 months of non-use. Maybe that's your problem ;-) Yeah, like that is likely to happen to any of us. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday,

RE: Fairly Boring News Article on Oracle

Continuing... they mentioned Web Services at the MS trial recently, apparently within Sun the meaning is not clear: http://www.wired.com/news/antitrust/0,1551,51674,00.html Could just be confusion at the management level though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA)

RE: MetaLink problems

Thanks everyone who responded - it has to be my workstation. I thought it might have been a memory problem, so I shut down the Oracle database on my desktop. No change. Reboot time... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et

Re: Instance fails to start

Comment out the date format in the init file and try it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 11:48 AM Hi All! I have encounterd an interesting problem after attempting to make a change in my

RE: MetaLink problems

Hmmm...this might explain it (join the two lines in the link). And of course, this link is on MetaClink... http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NEWp_id=1339352.999 Rich Jesse System/Database Administrator [EMAIL

RE: Favourite Urban Myth

Well let me be the first to show a little humility and admit to my own mistake. I wanted to write a command that would kill all of the processes that I owned. I called the script killall (I think that was it), well guess what, killall already exists! I couldn't figure out how my script which

Re: Replication Question

Hello John We are doing master to master replication. Both are 8.1.6 on NT. When we need to rebuild we delete and create both databases and import the data into both. Then we run a script that dynamically generate the proper procedure calls for all the tables in the schema and run them. I

RE: Differences between Oracle JDBC thin and thick drivers

In Java Programming with Oracle JDBC, Don Bales actually benchmarks the differences. The copy here in our group seems to have taken legs, so recalling from memory, I recall that under some circumstances the thin is faster and other times the thick is faster. The differences weren't great, and

Re: disk subsystem performance question

John, We have the Hitachi 5800 series with RAID 5. The sales guys also said their system is s fast we need not worry about such minor details. Don't believe them!!! Write speed is SLOW. After we added bare drives for redo log files, archive logs, conrtol files it made a dramatic difference

Re: Favourite Urban Myth

Well to continue the thread (as per Jared request) one newbe in our company started to learn the commands for the CICS (central terminal server on mainframe). going through the manual he got to the command shutdown immediate and tested it on production system. suprize : It worked :-))) Yechiel

Re: Parameters Question

Jared, I'm trying to read the Oracle documentation on Forms. (It's a 1,300-page PDF file... I'm on page 20, which, after the table of contents, is really about page 1 or 2.) So PL/SQL, I guess. Thanks, JoJo - Original Message - To: [EMAIL PROTECTED]; JoJo Zawawi [EMAIL PROTECTED]

RE: Instance fails to start

Bill, Check whether u have any hung shared memory segments by issuing the command : $ ipcs -mobs Look for an oracle:dba user having NTTACH = 0. If it exists, remove it using the command : $ ipcrm -m semaphore id Attempt to restart. Regards, Samir Samir Sarkar Oracle DBA SchlumbergerSema

Re: disk subsystem performance question

Short answer - NO! Nobody's disk subsystem is so fast that no intelligence is required in the layout. This is common vendor blather and one of the most popular myths. I have been hearing it for at least six years - and it still isn't true. Layout still makes a huge difference. RAID levels

RE: Instance fails to start

No luck with that. However, after editting the file to begin with, I reverted back to the original copy... Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell) I guess the

RE: Parameters Question

create or replace my_demo_proc (param_1 in varchar2, param_2 in number) is begin null; end; Now param_1 and param_2 are named parameters but begin my_demo_proc('ABC', 20); end; / The ABC and 20 are actual parameters. Named parameters are also known as formal parameters.

RE: Instance fails to start

Thanks, this is what I get from ipc status: IPC status from running system as of Wed Apr 10 11:34:18 CDT 2002 T ID KEYMODEOWNERGROUP NATTCH SEGSZ Shared Memory: m 0 0xf002b74 --rw-rw-rw- erl erl 5 131072 m 1 0x10002b74

RE: Instance fails to start

Could you please let me know, what is the significance of NTTACH=0 and why only this one needs to be removed. Srini -Original Message- Sent: Wednesday, April 10, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Bill, Check whether u have any hung shared memory segments by

PX Deq: Table Q qref

All What does this wait event mean? I have a process that connects to the database through ODBC and this process is waiting on this event and SQL*Net message from client. Often this process waits for an unreasonable amout of time (4 seconds or more) on SQL*Net MEssage from client and

Re: disk subsystem performance question

James Howerton wrote: John, We have the Hitachi 5800 series with RAID 5. The sales guys also said their system is s fast we need not worry about such minor details. Don't believe them!!! Write speed is SLOW. After we added bare drives for redo log files, archive logs, conrtol

Re: Favourite Urban Myth

Do Unix admin fiascoes count? I once had an SA do # chmod -R 700 /dev because he thought someone was inappropriately dinging something there. Can you imagine how many things break when /dev/null is unwritable and unreadable? And when /dev/vx/rdsk/... (with a database on raw devices) are not

Re: oracle on windows xp (only 9i is supported)

8i is not supported, only 9i is - http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=161546.1p_database_id=NOT Brian P. MacLean Oracle DBA, OCP8i

Re: DBA_SOURCE question

...and god bless them for it. It's much easier that trying to manipulate than the long column on dba_triggers, and finding what line is the line that errored in a trigger can be a PITA. Brian P. MacLean Oracle DBA, OCP8i

RE: MetaLink problems

I figured it out, IE on my machine was set to autologon as anonymous. Of course MetaLink didn't approve. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, April 10, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Subject:

Re: Differences between Oracle JDBC thin and thick drivers

I don't know about performance, but thick and OCI add one important element - TAF. I am working now on converting an exclusive Oracle8i system to 9i RAC, but the front end is thin client (i.e. no TAF). Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of

RE: Instance fails to start

The version is 8.1.7, and the original (and current) date format is nls_date_format = -MM-DD HH24:MI:SS The init file is exactly as it was pre-edit! Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell)

Installing Discoverer4i with Oracle9iAS

Hi, I am having trouble with this install. First a warning. If you are installing this on Solaris get the 9iAS 1.0.2.2.2 version as the 1.0.2.2.1 version would not even start up the Discoverer install for me (and I did have PsuedoColor set on my emulator as it uses the old installer in motif

Re: ORA-00600 Error

Hi, Analyzing ORA-600 trace files for the heap corruptions doesn't make sense. Because, this corruption errors are thrown if someone tries to work on this corrupted memory region. So, the information in trace files doesn't come from the corrupter. You should catch the corrupter. There are

RE: Explain: In List Iterator

Yup. -Original Message- Sent: Wednesday, April 10, 2002 11:48 AM To: Multiple recipients of list ORACLE-L It appears that there are no join conditions on it. Can you say 'cartesian'? :) Jared On Tuesday 09 April 2002 15:13, Freeman, Robert wrote: Uh I'm just wondering

cache buffer chains contention

Title: cache buffer chains contention Ok, some guru please explain this to me. process is waiting for 'latch free' according to v$session_wait and the value of P2 = 26 which is the cache buffer chains latch. (while holding the HW enqueue, with a bunch of processes waiting on HW) State

ADD datafile to standby database

Hi all, I am somewhat new to standby databases and I need to add a datafile. What exactly do I need to do or point me to some sources that clearly explains this. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

RE: PX Deq: Table Q qref

Looks like you have PQ enabled. These waits are considered idle. The PQ slave processes arewaiting for work to do. - Kirti -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 10, 2002 12:51 PMTo: Multiple recipients of list

Selecting a variable similar to a column

I am using Oracle EE 8.1.7 Is there a way to select a variable similar to selecting a normal column of a table? Or do I have to user dbms_output.put_line. For example, can this: declare lv_FirstName varchar2(20); lv_LastName varchar2(20); begin lv_FirstName := 'rick';

RE: disk subsystem performance question

John, We use 7700E. Most all EMC is going out and being replaced by HDS RAID-5. (What it costs is more important that what it does). Everything we have is on RAID-5 these days. HDS Techies and our Capacity Planners (who do the disk assignments to Servers) told me the following: The 18GB drives

Re: Favourite Urban Myth

?? rm -i $* I'm having a hard time understanding why this would spawn more than one process. Jared Don Granaman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/10/02 11:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Favourite Urban Myth

kill -9 -1 will do that also. Or as root: su - USER -c kill -9 -1 Very fast, very effective. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/10/02 09:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Instance fails to start

FYI, I discovered the problem here... I reduced the number of processes in my init file by half, and I was able to start my instance. Apparently there was enough resources to start both instances at boot time, but not after the system has been running for awhile -- we have a few other services

Re: ADD datafile to standby database

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbym.htm#27175 Brian P. MacLean Oracle DBA, OCP8i

Re: PX Deq: Table Q qref

Thats what I thought. But here is more details on the issue.. I am running a SQL*PLus session with a massive query that returns about 2.5g of data, i am spooling the data to file - that is something similar to what the essbase application is trying to do. that session spooled the data in

RE: Selecting a variable similar to a column

Hi Rick, in pl/sql any time there is a select statement outside of a cursor, it expects you to select it into a variable of some sort. You can pass refcursors or pl/sql tables back and forth and buzz through the values like a cursor. Here's an example from some of my living code: The

Re: Favourite Urban Myth

Recursion - it called itself endlessly. $HOME/bin (where it lived) was the leading element of $PATH. After a minute or less, it was thousands of processes deep. After changing it to /bin/rm -i $* it worked as intended. Don Granaman [certifiable OraSaurus] - Original Message - To:

RE: PX Deq: Table Q qref

Babu - Are you running this session in the background? On my system (Compaq Tru64), when I run a SQL*Plus script in the background, I have to put the EXIT command as the last command of the script. Otherwise the script just sits there and echos the prompt into the spool file until it fills up the

Re: cache buffer chains contention

seconds_in_wait increments every three seconds, so if State is anything other than WAITING the column tells you how much time has passed since the last wait completed. (Contrary to the urban legend that says the value is meaningless). There are various anomalies and oddities about wait

Re: disk subsystem performance question

Much of the supposed 'speed' may come from onboard caching on the controller. There is the minor risk that a crash could come after Oracle commits the data and before it is actually written to disk. --- [EMAIL PROTECTED] wrote: Hi all, We are running both a Hitachi 7700E and a 9960 disk

Re: PX Deq: Table Q qref

No. i am running it from the foreground... babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:48 PM Babu - Are you running this session in the background? On my system (Compaq Tru64), when I run a SQL*Plus script in

RE: standby database problem ???

I got this error when I first set up my standby database. If you generate a log switch, and then recover again you will not see the problem. If I recall correctly, the issue arises when the redo log that was active when you created your standby control file has not been archived. If you issue

insert performance

Greetings! I am trying to diagnose a performance difference between two databases running the same test. They are similarly configured (same SGA size, etc.), and the servers are identical except for the number of CPUs (server A has 4, server B has 6). On database A, INSERT performance is about

Re: disk subsystem performance question

Thanks for all the replies. We are determined to lay out the data as well as we can across the disks we are about to purchase - with the goal of striping across array groups and smaller, faster drives. The real argument for us is 18GB vs. 73GB disk drives and how we can stripe. The

Re: insert performance

Follow-up question: can someone explain exactly why buffer busy waits can be due to heavy insert activity when there are insufficient freelists? I suspect that this may figure into my problem with insert performance. Thanks! Paul Baumgartel __

Re: insert performance

aul, BBW due to not enough freelists is caused by multiple processes waiting on the head of the freelist to check if there is space in the block. problems can get worse by doing array inserts .. So by having enough freelists, different processes will check on different heads of freelsits.

Re: disk subsystem performance question

I believe RAID-1+0 has more cost than benefit. I want to see measure total I/O's to each spindle. While RAID-1 has higher cost to maintain, it gives me maximum flexibility to evenly distribute I/O loads. I contend that with proper table partitioning I can achieve sustain higher I/O rates with

TKPROF?

What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Nemeth

Re: package in sqlarea

You need to check the SQL in the procedure. I have the same situation. I run Tim Gornman's temp_top_stmt2.sql script to identify the SQL within the procedure. Statspack also identifies the high resource consuming SQL. IXORA also provides scripts to identify them. Shakir --- Big Planet

RE: disk subsystem performance question

John, I agree with the 18GB drives implementation and pushing for more 'parity groups'. That's what we did. Now, HDS was back to sell more disk and backup soultions to us. I am not sure what we have agreed to purchase. A cache of 10GB for the 400GB database is nothing. I bet you will have tables

RE: TKPROF?

Transient Kernel Profile. - Kirti -Original Message- Sent: Wednesday, April 10, 2002 8:38 PM To: Multiple recipients of list ORACLE-L What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center

Re: TKPROF?

Tool Kernel PROFiler Anjo. David Nemeth wrote: What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official

RE: TKPROF?

Anjo: I always thought it Trace Kernel PROFile? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, April 10, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Tool Kernel PROFiler Anjo. David Nemeth wrote: What does it stand for? Tool Kit

HELP HELP HELP HELP !!!!!!

I faced with following error. ORA-01033: Oracle startup or shutdown in progress What is the problem. I restart server again and again but problem is not solved. Please HELP ME.