RE: Free Java dba monitoring tool and Java source code
Andy any luck with installing the tool. I enclose word doc about the tool Any problems with installation, please dont hesitate to contact me. The initial setting up of a Java application is always tricky, but once youve done one, you can get a clear picture. Thanks Sam -Original Message- Sent: Tuesday, April 17, 2001 9:31 PM To: Multiple recipients of list ORACLE-L Hi Sam, As part of my masters dissertation I have developed an SQL monitoring tool using Java/JDBC/thin drivers that allows the DBA to see who is taking up the resources currently in a database. This is not at all a commercial venture, purely academic. Plus if you want to learn about Java/JDBC this can be an invaluable asset/starting point as you know the subject well and you can see how the tool has been built. I'd love to see your Java Oracle DBA Open Source tool, up on a public internet site somewhere for download! :-) Some other Java-Oracle type Open Source links you might want to look at, to help further your own work, are: Apache JServ = http://java.apache.org/jserv/index.html DB Prism, Java/Oracle servlet engine = http://www.plenix.com/dbprism/doc/Home.html Tomcat (replacement for JServ) = http://jakarta.apache.org/tomcat/index.html jDBA, another Java Oracle DBA tool = http://www.jdba.org ViennaSQL, Java/Oracle SQL tool = http://vienna.sourceforge.net jDBA may the one you're most interested in, but using Java as the programming language for Open source projects, including Oracle ones, is growing rapidly in popularity! :-) Hope this is of some use 8) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: jdbc thin client driver
Manas, Recheck your classpath and the versions of your classes file(i.e. correct jdk / classes compatibility). This error is clear, it can't find the JDBC drivers. Sam -Original Message- Sent: Friday, April 20, 2001 10:01 PM To: Multiple recipients of list ORACLE-L I am trying to test a jdbc application using Oracle' thin client driver from AIX. The database that I am trying to go against is 8.1.6 server on an NT box. I keep getting the following error on compile: OracleConn.java:10: Class oracle.jdbc.driver.OracleDriver not found in type declaration. DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); ^ The CLASSPATH does contain classes111.zip. I have also tried using classes12.zip in the CLASSPATH. Each time I get the same error. This is the piece of code I'm trying to compile: public OracleConn() { try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); } catch ( Exception e) { System.out.println("Error Loading driver"); e.printStackTrace(); } } public Connection getOracleConnection(String dbname, String userid, String pwd) { String url = "jdbc:oracle:[EMAIL PROTECTED]:1521:" + dbname; Connection myConn = null; try { myConn = DriverManager.getConnection(url, userid, pwd); System.out.println("Connection successful") ; } ... What am I doing wrong Thanks, Manas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manas Dasgupta 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: Legato Networker Module
We are thinking to use legato Networker module for 24x7 availability. Any body had any experience (good/bad) or can give any tips Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: Deployment of Oracle Client
The way we did it to 2000 users without a hitch. You dont need to install full client, only sqlnet or net8 (approx 28meg). We use Novell launcher. Take a snapshot on one machine, then novell automatically launches it to all clients.There should be similar products to this.(I think SMS by Microsoft). We have a constantly changing environment whereby the applications are updated,we use this method to update all local machines,and it works a dream. This is for now as we have a mixture of fat client and browser based. Sam -Original Message- Sent: Monday, March 12, 2001 10:27 PM To: Multiple recipients of list ORACLE-L How do most organizations deploy sqlnet client to a large user base? We've currently got hundreds, maybe thousands of users with various versions of the client installed on their desktop. We're also about to roll out Windows 2000 to a large percentage of these users. In testing we've determined that earlier desupported client versions (7.3.4 and such) seem to work on W2K with the apps currently deployed. I'm not happy with a "cross your fingers and hope" approach and have been pushing to get most users up to 8i as a client. Ideally I'd like to have something the users can download and install from the intranet. In searching technet downloads all I find is the entire bloated 200MB Oracle Client as a download - much too big for our remote users to download and install. All I want is the Net8 pieces I'd need for sqlworksheet, or TOAD, or an ODBC connection, so that the download and install time would be within reason. Anybody have suggestions? How are people on this list deploying Oracle apps to many users? Thanks. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Conboy 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: Oracle DB ODBC
Install the Oracle ODBC Drivers on the Oracle Client CD Run Microsoft ODBC Administrator piece of cake Sam -Original Message- Sent: Sunday, March 11, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Dear list ! How can i setup an ODBC connection for an Oracle database , please ? TIA . Andrey . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: EXPLAIN OUTPUT
When I say in their scripts - I mean within the SQL Block itself. Of course there should be comments in the program. Sam -Original Message- Sent: Tuesday, February 20, 2001 5:30 PM To: Multiple recipients of list ORACLE-L I dunno about _bad_ practice, but I tend to beat developers around the head and shoulders who DON'T put comments in there scripts. It makes it easier to follow what they think ther are doing and for others to later modify the script to change what it is doing. Terry "Sam P. Roberts (ZADCO ITIS)" wrote: Some of our developers put '--' i.e. comments in their SQL. This is painful when trying to extract the SQL to explain (screws dbartisan up as well) . Does anybody have an SQL Query that can help or point me to a manual or paper that says it is bad practice to put comments inside SQL blocks. Regards Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: memory usage
add in c.name to get the statistic name that the value corresponds to select a.username, c.name,b.value from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.STATISTIC# and a.username!='SYSTEM' -Original Message- Sent: Tuesday, February 20, 2001 7:56 PM To: Multiple recipients of list ORACLE-L Am I the only one who gets garbage out of this query? There's a mismatch on v$statname. Which statistic are you suggesting to display, uga or pga memory? -Original Message- Sent: Tuesday, February 20, 2001 5:15 AM To: Multiple recipients of list ORACLE-L solution : select a.username, b.value from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.STATISTIC# and a.username!='SYSTEM' - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2001 3:25 PM hello dba's ( again ) i'm looking for a way to do a manual "top-session" on a database. According to TopSession from Oracle, the information should be located in v$sessions. Anyone an idea how to read the memory usage out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage. thanks for any help Bjorn Naessens Roularta IT Solutions -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: EXPLAIN OUTPUT
Some of our developers put '--' i.e. comments in their SQL. This is painful when trying to extract the SQL to explain (screws dbartisan up as well) . Does anybody have an SQL Query that can help or point me to a manual or paper that says it is bad practice to put comments inside SQL blocks. Regards Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: Renaming a Column
What's wrong ? All Neena did was give another answer to the original question - she even said don't do it except in test. -Original Message- Sent: Wednesday, February 14, 2001 9:41 PM To: Multiple recipients of list ORACLE-L Boy, am I tired of people suggesting this kind of thing. What's the point, when there are SUPPORTED and SAFE ways of doing what you want? Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Wednesday, February 14, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Hi, The suggestion till yet provided are the correct ones and safest. But try this in your test database, get you table id from sys.obj$ table. Then get the columns details from sys.col$ table by giving the table id in where clause. Update the row which corresponds to the column which you want to modify. -- neena ??? wrote: from Oracle 8i you can drop columns with -- alter table table_name drop column column_name; and then your can add columns with the name to which you want to rename alter table table_name add(column_name type); -Original Message- ]On Behalf Of bipin sahani Sent: Wednesday, February 14, 2001 3:05 PM To: Multiple recipients of list ORACLE-L In Oracle It's not possible to rename a column.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen [EMAIL PROTECTED] wrote: Hi all, I need to rename some columns on my table. Any idea how to do that... Thanks in advance, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com http://www.hotmail.com . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Heikki Jantunen 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 an E-Mail 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). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= 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 an E-Mail 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).Wsz^r9,BmY(a 9c}vsV +r5pzqw9PY9tTsoe8z'EURs-'xs?'zoeq,-).+-: **.}sbf-)-+-jqj)fz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: TKPROF
YES THIS IS AN ORACLE FINANCIALS DATABASE - RULE BASED OPTIMIZER -IM CURIOUS ABOUT THIS, BECAUSE I DOUBT THE EXPLAIN (Please NOO!!) - Has anyone had rubbish back from EXPLAIN ? SAM -Original Message- Sent: Thursday, February 08, 2001 12:17 PM To: Multiple recipients of list ORACLE-L Hello, Do you have timed_statistics = true in your init file ? Regards Henrik Sam P. Roberts (ZADCO ITIS) wrote: This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.34 1.73 83385 0 7 --- -- -- -- -- -- -- total4 0.36 1.75 83385 0 7 Misses in library cache during parse: 1 Optimizer goal: RULE Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 36 (GL) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 0 NESTED LOOPS 0INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE) 0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_BALANCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- --- Henrik Ekenberg Anoto AB E-mail :[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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: STARTUP Force
Yeah, me too,, force the checkpoint,shutdown abort, startup,shutdown normal - (5 mins max) - you can then schedule legato or whatever backup. been working fine for 3 years on multiple instances. (famous last words) Sam -Original Message- Sent: Friday, February 09, 2001 2:51 AM To: Multiple recipients of list ORACLE-L Yeah right! I have six years of experience and I use shutdown abort all the time. Just force a checkpoint first to speed up hot recovery on the startup. The other forms of shutdown take too long, and may never complete if you have long running transactions that don't do frequent commits. Check out the following paper if you think I am wrong... http://www.wolfenet.com/~jeremiah/241.pdf Startup force, on the other hand, I would never use this unless I had a high level oracle support engineer holding my hand. -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 8:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: STARTUP Force One thing I would say Neena - ONLY use SHUTDOWN ABORT as an absolute LAST resort!! If you are shuting down the database normally, on 8, first do a SHUTDOWN TRANSACTIONAL, if you need to close the database quickly, try a SHUTDOWN IMMEDIATE, wait for 5 or so minutes, and if all else fails ONLY THEN issue a SHUTDOWN ABORT!! SHUTDOWN ABORT can cause corruption, and recovering is a bit of a pain the arse (as a list memeber found out recently).. You don't seem to have a lot of experience with Oracle, as Joe mentioned. Now I have around 3 years experience and STILL have NO experience with Backup and Recovery (fair enough it is not an issue for me). Grab hold of the Oracle docs from http://www.otn.oracle.com/ and start reading away. Regards Mark -Original Message- Testa Sent: Wednesday, February 07, 2001 12:30 To: Multiple recipients of list ORACLE-L Neena, after looking at your last 3 messages, you need to sit down and read the administrators guide, 90% of your questions are answered in that book and nowadays there is no excuse for not reading docs(unlike back in version 6 days when people used to hoard the books). joe TIL-TEC wrote: When do a DBA prefers to use STARTUP FORCE than SHUTDOWN ABORT+STARTUP NORMAL ? --Neena -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elliott, Patrick 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 an E-Mail 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
TKPROF
This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch2 0.34 1.73 83385 0 7 --- -- -- -- -- -- -- total4 0.36 1.75 83385 0 7 Misses in library cache during parse: 1 Optimizer goal: RULE Misses in library cache during parse: 1 Optimizer goal: RULE Parsing user id: 36 (GL) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: RULE 0 NESTED LOOPS 0INDEX GOAL: ANALYZED (RANGE SCAN) OF 'SAM1' (NON-UNIQUE) 0TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_BALANCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' My question - Why is the rows returned 7 in stats, yet the explain shows now Rows: Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) 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 an E-Mail 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).