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).
Free Java dba monitoring tool and Java source code
Dear List To quote Jared recently 'And if you are wondering 'Should I learn Java?', the answer is 'definitely', as it is capable of many things that PL/SQL is not.' I have to totally agree with him and I think DBA's can enhance their profile by becoming competent in the technology. 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. The default is physical reads but any statistic can be selected. It displays like Instance manager but gives added functionality that it will extract the SQL that is running currently and allow you to Explain it online. You can sort the session data, kill sessions, etc.. It is a good tool especially if you suddenly get a dip in performance and need to quickly find which process is taking up all the resources. It is also good for ad-hoc monitoring. I know there are better/professional tools out there but not all companies can afford them,this is free and has been built in limited time. I work for an oil company and we have no monitoring tools, we had to rely on our own scripts. Most importantly I will give the source code to all that give me comments on the tool. 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. The tool is thin client - i.e. no oracle client installation necessary All you need to do is download Java 1.3 from Sun. If you e-mail me offline I will send you my website address where you can download (396kb-takes no time). There is also a link to the sun site for Java 2 download (this takes a little longer as its ABOUT 30MB).But it has all the latest swing classes and is the latest version. As an ex Cobol programmer in the 80's, Java is a wonderfully elegant language to learn and once studied is not as difficult as imagined (I imagined anyway). Sam -Original Message- Sent: Tuesday, March 27, 2001 12:21 AM To: Multiple recipients of list ORACLE-L Oracle has repeatedly stated that PL/SQL is not going away. One good reason for this is that PL/SQL is highly optimized for DML in the database. Java is not, and will not likely ever be as efficient PL/SQL for manipulating large amounts of data. At least IMO. OOP has many benefits, but large scale DML is not one of them, at least not yet. PL/SQL will be around for awhile yet. And if you are wondering 'Should I learn Java?', the answer is 'definitely', as it is capable of many things that PL/SQL is not. Jared On Thu, 22 Mar 2001, Jeff Cox wrote: > Dear List, > > I haven't really seen a question on this list regarding SQLJ, and it makes > me wonder how many people on this list actually use SQLJ. A DBA friend of > mine told me that eventually SQLJ will replace PL/SQL in preference, and I > wanted to know the truth regarding his statement - so who better to ask than > the experts of this list? > > What have you heard, or better yet, what is your opinion of SQLJ? Is SQLJ > the future? Will PL/SQL die a slow death? Can you do everything in SQLJ > that you can do in PL/SQL? > > > Cheers, > > Jeff Cox > IPS-Sendero > Scottsdale, AZ > -- 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-- 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: *.dbf, *.ctl, redo*.log access rite
.dbf = -rw-r--r-- .ctl = -rw-r- .log = -rw-r- sam -Original Message- Sent: Monday, April 02, 2001 8:05 AM To: Multiple recipients of list ORACLE-L Hi guys, Can you tell me what is your access rite for those files in unix solaris 7 oracle 8.1.6, my current access rite are: rwxrwxr-x for all of them. 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) 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: Data exchange between ORACLE & SYBASE
Im not sure Ive got the correct question Mark, But it is very easy to link access to oracle via ODBC. If this is question , I can explain Sam, -Original Message- Sent: Friday, March 30, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Do you have any further details on this? Links to a web site perhaps? I Would be interested in getting an Access to Oracle link set up so that I can quickly generate some test data. Anybody else know a quick and (if it has to be) dirty way of getting Access data through to Oracle? At the moment I am doing this with export/import. Is the transfer easy? Does it use ODBC connectivity? Tell me more :) Mark -Original Message- Moriano Sent: Friday, March 30, 2001 10:10 To: Multiple recipients of list ORACLE-L tapas dutta wrote: > Dear all, > > Could anybody suggest how to data transfer from Sybase to ORACLE > apart from converting to a text file and then use loader, without any > extra cost. > You can try wiht Infomaker application, wich have an element called PIPELINES. I´ve onle used it to transfer data from oracle to oracle, excel to oracle, and acces to oracle, but i suppose that posibility (Sybase->Oracle), would be possible. I hope this helps you. > > regards, > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: tapas dutta > 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: Sergio Boix Moriano 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: 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: Parallel Queries and CPU usage high
Find out which of the 10 users is running a massive Query If not that, speak to Sys Admin - Sam -Original Message- Sent: Friday, March 30, 2001 3:16 AM To: Multiple recipients of list ORACLE-L Hi, all! - Solaris 2.8 w. 4GB RAM - Oracle 8.1.6.3.0 Enterprise Edition With 10 Concorrent users, I'm getting 100% CPU usage. Any suggestions? TIA, Zhong It's another beautiful day! -- 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: Single Code Table or Separate Code tables dilemma
STAR Queries would perform better with multiple smaller tables (known as Dimension Tables). STAR QUERIES are designed specifically for Decision Support Systems where multiple cartesian products are created on the smaller (dimension) tables and then joined with the LARGE fact table. Sam -Original Message- Sent: Thursday, March 22, 2001 4:36 AM To: Multiple recipients of list ORACLE-L Guys, We r working on a Datawarehouse solution. Our Duhvelopers want to merge all code tables into a single table by adding a codetype column. with reference to this, i came across this article from Steve's site http://www.ixora.com.au/tips/design/meta-data.htm i want to put them into different individual code tables instead of a single table, for the foll reasons. 1. specific attributes for a particular code type is logically and physically seperated from other code types. 2. a table lock affects only the concerned code table 3. granular control over the individual code table i am short of arguments wld be grateful, if ull can advise me which would be better from performance perspective. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Ghosalkar 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: 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: Oracle DBA evolution path - please share your opinion
) 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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
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: 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).>Ws±ëzØ^¡÷âr&¥9,BÅm¶YÿÃ(§Ú©Ê&ëa¢² 9c±ý}v·s>Þ´V +r5ëp¢¹z»âqë<çÎwó9ÔPóY9ßÎtçTsoe8z'EURs-'è®xs>æå?Â'µêçzÖoeqë,üÆ¢-)à.+-±: Ã**.®Ç¥}úèsØb²f¢-)à-+-±éÝ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: 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
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).
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).
RE: OT RE: Async I/O on Windows
employers, though I'm sure they agree :^) -Original Message- Sent: Friday, February 02, 2001 07:00 To: Multiple recipients of list ORACLE-L Oracle on NT runs as ONE PROCESS with MULTIPLE THREADS for performance reasons (no more need for shared memorycontext switches are a LOT less expensive, etc.) -Original Message- Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Hi, Mark, Async I/O is available on Windows, at least NT. It's not an easy topic. If you think you already know enough about operating systems in general, I suggest you read David Solomon's "Inside WindowsNT". For a lab test, launch Performance Monitor on your NT box and look at the counters for Cache. I'm not sure by "single thread management" whether you mean NT can't have multiple processes or Oracle on NT runs as one thread. The former is obviously wrong. The latter is a design issue inside Oracle Corporation and the question as to why was asked on this forum before without an answer (without an answer I can remember, that is). Yong Huang [EMAIL PROTECTED] you wrote: Asynch I/O on a Windowze box? supresses a snigger... To the best of my knowledge there are no Windows based system that can take advantage of this, single thread management can be enough a problem sometimes.. But, I may be wrong.. List? __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ <http://personal.mail.yahoo.com/> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: yong huang 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: Analyze Question -- How CBO uses column statistics for non-in
They most definitely non indexed will have influence on the CBO - there is the ANALYZE FOR ALL COLUMNS option anyhow, that is there for that reason. I think also likely used in conjunction with histograms on fields - DSS / Data Warehouse : Regards Sam -Original Message- Sent: Saturday, February 03, 2001 6:47 PM To: Multiple recipients of list ORACLE-L non-in Sam, You had the right topic. The original questions was "In what way do statistics (or lack thereof) on non-indexed columns influence the CBO?". I was having trouble thinking of a scenario where this would make a difference, hence my posing the question to the list. I finally thought of a scenario and threw it out to the list. That's the email you responded to. Anyway, I eventually had a chance to test the scenario. Created 2 tables, A and B, each containing 50,000 rows. Each have a indexed column containing consecutive integer values from 1 to 50,000 and a one to one relationship between the tables on this column. Each table also has a second *non-indexed* column. For table A, the second column contains 25,000 distinct values with each individual value occurring 2 times. For table B, the second column contains only 2 distinct values, 0 and 1, with each value occurring 25,000 times. So, I have an index on the tables to support a join between the 2 tables, and, no indexes on the second column in each table. I did a generic analyze compute which would include generating stats on the non-indexed columns. And yes, the CBO would use the stats on the non-indexed column on table A to decide whether to join to table B using an indexed NLJ, or, an FTS and HJ (and in some cases an FTS and SMJ). After deleting the stats and re-analyzing so that stats on the non-indexed columns were not generated, the CBO always chose, at least on my test cases, to do an FTS on each and use an HJ. Anyway, as you mentioned, there might be other situations as well. Besides looking at the plans themselves, I also used information from Steve Adams' site, http://www.ixora.com.au/home.htm, for info on setting event 10053 and interpreting it's output so that I could "look" into the CBO's head and see how it evaluated and made it's decisions. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- Roberts (ZADCO ITIS) Sent: Friday, February 02, 2001 11:45 PM To: Multiple recipients of list ORACLE-L non-in I missed out on original e-mail regarding this subject so I hope I'm on the right track, but I assume that the CBO will use non-indexed columns in its algorithms. I know DB2 would use non-indexed columns, maybe because DB2 is a more advanced optimizer(only because IBM have been doing it a lot longer than Oracle). I can see one use for the optimizer to use column stats - when a non leading column of a composite index is used in a where.okay yes it is still part of the index but it would probably use the info from analyze in tab_column. There is probably plenty more with the new features like star joins where the optimizer builds tables on the fly. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: larry elkins 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: Urgent: Number of Cursors Open Error
no of cursors per session - can be way high like 7500, affects nothing -Original Message- Sent: Saturday, February 03, 2001 7:50 AM To: Multiple recipients of list ORACLE-L I believe this refers to the number of cursors that can be opened during one transaction. Not sure how to determine the number of cursors currently open. Bryan - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 12:12 PM > > My database is 8.1.6. and I would like to know how to verify the number of > cursors that are currently open? > This database's default open cursors = 50. Does this value mean that this > is the maximum > number of cursors opened per connection or maximum number of cursors opened > per instance? > > Can this value be changed while the database is opened, if so, how? > > Thank you in advance. > > Larry > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Taylor > 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: Bryan Sirtosky 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: ORA-00200 (control file creation error)
reuse -Original Message- Sent: Friday, February 02, 2001 6:51 PM To: Multiple recipients of list ORACLE-L I am trying to create a new database OPS database/instance. While running the script using SVRMGRL get the following messages.. ORA-01501: CREATE DATABASE failed ORA-00200: controlfile could not be created ORA-00202: controlfile: '/dev/disk/dsk19a' ORA-27038: skgfrcre: file exists Any ideas, the sys ops say everything is OK. Regards, Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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: Analyze Question -- How CBO uses column statistics for non-in
I missed out on original e-mail regarding this subject so I hope I'm on the right track, but I assume that the CBO will use non-indexed columns in its algorithms. I know DB2 would use non-indexed columns, maybe because DB2 is a more advanced optimizer(only because IBM have been doing it a lot longer than Oracle). I can see one use for the optimizer to use column stats - when a non leading column of a composite index is used in a where.okay yes it is still part of the index but it would probably use the info from analyze in tab_column. There is probably plenty more with the new features like star joins where the optimizer builds tables on the fly. Sam p.s. if I missed the boat on this topic ,please ignore -Original Message- Sent: Friday, February 02, 2001 5:51 PM To: Multiple recipients of list ORACLE-L non-indexed columns Steve, Thanks for taking the time to reply. My initial thought was that the stats would be of no use, but, the thing that still makes me wonder is why would a simple "analyze table compute statistics" gather statistics on *all* columns. For this to be the default behavior, there could be a reason. That's why I threw the question out to the list, trying to see if I was overlooking something obvious. I see your answer below, but, one scenario hit me this morning and I thought I would run it by you and the list and let people take shots at it. Assume I have an SQL query joining two tables equal in size and the CBO views the cost of an FTS against either as being the same, and, there is an index supporting joining the tables. In addition to the join criteria, criteria against *non-indexed* columns in each of the two tables are specified. No *indexed* columns criteria, other than the join itself, is specified. So, the CBO needs to choose one of the tables as the "driving" table, doing an FTS, and, needs to decide whether to use an NL, MJ, or HJ between the two. Does it make sense, in this case, that the column stats for the non-indexed column could influence the choice of the driving table and/or the join method, that a generalized selectivity would be construed based on the number of distinct values captured for the columns? Sure, an FTS on at least one table would still be required, but, stats on the non-indexed columns could influence which table to drive by and which join method to use? My "gut" feeling is that in a case such as the one just described, stats on non-indexed columns could influence the access path and join method determined by the CBO. I picked up info on event 10053 from your site. I'll play around with that this weekend. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 01, 2001 9:48 PM To: larry elkins; Multiple recipients of list ORACLE-L Hi Larry, I think that the answer is that the statistics are of no use to the CBO until an index is created. @ Regards, @ Steve Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: larry elkins 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: V$log Status
This is happening because you are flooding the cpu with requests, the queues are growing, the knee of the curve on the CPU has gone asymptotic. Schedule this job for an off peak time, or split it somehow. Sam -Original Message- Sent: Friday, February 02, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Hi All, I am doing a batch update which updates around 100,000 rows. While this updating is in progress, the system slows down all in a sudden for few minutes before it continue to work normally. The archive log is enabled and I have 5 online groups with each 10 MB size. If I check the V$log while updation in progress, I find the status is in ACTIVE even after the archive file written for that log. This sequence continues until all the log files except current one in ACTIVE state. After couple of minutes all the ACTIVE status getting changed to INACTIVE. Any Idea what could be the reason for this? I got 8.1.6 undex solaris. TIA Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).