How to Compile Pro*c

Hi Everybody !! Pl. help me out from this problem !!! My Boss had asked me to Compile a Pro*C after making some very simple Changes. This was a running program. I had tried to comiple with $make -f proc.mk petrol Make: Don't know how to make petrol. Stop. Environment is 1.digital unix 2. O

Re: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Dictionary managed tspaces are practically obsolete...Go with locally managed - they are the default in 9i and as of 9i.2, *all* tablespaces will default to locallly managed (including system) hth connor --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi DBAs, > > I would like to know on what basi

RE: oracle not available ???

A Cold Backup is always a Full backup --- all datafiles (and, highly recommended, all control files and redo log files). Did you shutdown the database twice but only backup 6 files each time ? How many log switches occurred between the first backup and the second ? If the transactions are still i

RE: How to Compile Pro*c

I would assume that the source code file either isn't there or is not called petrol.pc HTH Lee -Original Message- Sent: 02 January 2002 09:05 To: Multiple recipients of list ORACLE-L Hi Everybody !! Pl. help me out from this problem !!! My Boss had asked me to Compile a Pro*C after

Re: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Connor McDonald wrote: > > Dictionary managed tspaces are practically > obsolete...Go with locally managed - they are the > default in 9i and as of 9i.2, *all* tablespaces will > default to locallly managed (including system) > > hth > connor > > --- Arul kumar <[EMAIL PROTECTED]> wrote: > Hi

Re: Becoming a DBA questions

I've tested OCP... and it's not that it is totally valueless (if nothing else it can show that someone is willing to learn) but that WHAT OCP teaches you does not tend to apply in the real world. I won't reject a resume out-of-hand if they have OCP on it, but they'd better have something else tha

AHA!!! Re: ORA-00904 on a valid view when using count(*)

hahaha! i found it! i found the answer to my problem the part that causes the error was the order by clause using an alias... i tried to change the sql for the view using the whole exp (((sq.last_trade_price - sq.previous)/sq.previous) * 100) in the order by clause instead of the "perc_change

educate yourself

Nice stuff : http://www.intelinfo.com/newly_researched_free_training.html http://www.intelinfo.com/free_it_training_materials_and_books.html http://w3.softlookup.com/ http://www.intelinfo.com/cat1.html http://www.intelinfo.com/cat2.html -- Please see the official ORACLE-L FAQ: http://www.orafa

Problem Granting Roles

I granted myself roles via SYS. I have another user on our server (W2000 / 8.1.7) and I have gone through the same process of granting the new user roles via SYS. However, when she connects to the DB she gets the message that the objects don't exist. The owner of the DB is me. What am I doing

RE: Becoming a DBA questions

Did you mean... "MS SQL Server is a relational database" and not MS Access?   Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message-From: Edward Lock [mailto:[E

RE: Problem Granting Roles

Title: RE: Problem Granting Roles What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created. get the user to select from the full table name sys.x and see what happens. -Original Message- F

OTN Download Hanging

I am trying to download the three .zip for 9i to my laptop (W2000). The download goes OK until it gets to 99%. Then I look at Task Mgr. and it says 99% complete Not Responding. Why is it hanging? This has happened to me three times in a row. Thanks, Ken -- Please see the official ORACLE-L FA

Re: Problem Granting Roles

Hi You own the objects, and the other user can't see them? Try creating synonyms or add the schemaname in front of the object. ---select * from owner.table; what roles did you grant (connect resource dba. or something you created yourself)? A little more info would help in resolving pro

Re:How to Compile Pro*c

I assume we're talking Unix here, therefore the command line is: $make -f proc.mk build EXE=petrol OBJS=petrol.o Or if your using shared libraries: $make -f proc.mk build_shared EXE=petrol OBJS=petrol.o Dick Goulet Reply Separator Author: [EMAIL PROTECT

RE: Becoming a DBA questions

No, Access *IS* a relational database!   I almost want to add ;P to the end of that, but it's true! It's just a "compact" relational database, that resides in one file. It is still SQL based, and geared around objects such as tables, indexes etc.   A poor man's RDBMS.. That does the trick

RE: OTN Download Hanging

Get Download Accelerator Plus, it downloads things in parallel and re-downloads corrupted segments. It won't work with all the Oracle download files (e.g. doesn't work with 11i patchset), but it works for most of them. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin

stupid oracle on windoze question

ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file.   Is there such a thing in the windoze world.  a registry entry maybe?   thanks, joe  

RE: OTN Download Hanging

Ken, Your system is most probably running through the last stage of the download, where it copies the file to the download destination from your temporary directory, once the download is complete and verified.. Depending on your system, and connection this could take a little while to do as each

RE: stupid oracle on windoze question

Joe:    The Environment variable TNS_ADMIN can direct the location to another position.  It can be stored within the registry or as a environment variable in windows.   Thank You   Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct:  (248) 865-435

RE: stupid oracle on windoze question

Joe,   You can set TNS_ADMIN as an environment variable or registry variable in HKLM/Software/Oracle and use it.   I prefer to use a variable instead of registry variable.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot

VLDB backup policy

Dear list ! I'm reposting this , since got no replies yet. I need to design a backup policy for a VLDB sized some 10TB, running as close to 24X7 as possible. I need 2 versions of the policy: One is the "best case" , i.e. money does not matter, the company can aquire any software / hardware , th

Re: stupid oracle on windoze question

HI Joe, >From the documentation: TNS_ADMIN Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If you installed software into the default Oracle home, then any software running from that Oracle home will look in HKEY_LO

RE: stupid oracle on windoze question

RE: stupid oracle on windoze question

Damn, why don't people use the manuals.  TNS_ADMIN.  Actually, you can set the puppy on Unix as well. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, January 02, 2002 6:15 AMTo: Multiple recipients of list ORACLE-LS

RE: OTN Download Hanging

I just thought of something... do you have enough disk space for your TEMP directory. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, January 02, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Subject:RE: OTN Downlo

A DBA's career development

Dear list ! Having been an Oracle DBA on UNIX & win platforms for past several years, i feel like i'd like to change something. Don't get me wrong , i like what i'm doing , but i think it's time to expand my horizons. I wouldn't like to completely quit the filed of Oracle/DBAing , but i'd like to

RE: stupid oracle on windoze question

Ah ha! Revenge of the RTFM! ;P Original Message- Sent: 02 January 2002 14:45 To: Multiple recipients of list ORACLE-L HI Joe, >From the documentation: TNS_ADMIN Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If

RE: Problem Granting Roles

Is the role set as her default role? Having the role is not enough. You can have a role assigned to you but its not necessarily 'active' at the time. -Original Message- Sent: Wednesday, January 02, 2002 4:30 AM To: Multiple recipients of list ORACLE-L I granted myself roles via SYS.

RE: Determining Striping

Not sure if you can show striping with a command. Using the DF command usually shows all disks in the disk farm. Alternatively, there is an admin tool for disk maintenance, but I don't remember the name. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (2

Stupid windoze question

better work around was to have a modified version of tnsnames.ora file in a bin directory that we execute our batch files from.   Since this is an rexec and we execute from different directories based on the userid, we can use the same alias DSS to point to different db based on the login, de

RE: VLDB backup policy

You could split off a mirror and backup the mirror however, I have never done that so I am not going to get into it. I know there are others in the list who have done it for their backup strategy. Keep in mind that if you are running in archive log mode you need not backup every data file at the

Determining Striping

Is there a UNIX command to determine what, if any, striping was used when setting up a server and it's disk? Sun Solaris 6, 7 and 8 are what I'm specifically interested in. TIA, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ:

RE: stupid oracle on windoze question

Not to mention that this is something that you also need to know for the OCP exam;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly SmithSent: Wednesday, January 02, 2002 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: s

RE: Becoming a DBA questions

Somewhat different, but my son's taking his CCNA (Cisco Certified Networking Associate) this p.m. He realizes that it's not going to guarantee him a job, but he hopes it will help him get his foot in the door. He's 19, and just finished the Cisco networking academy. He took the first year at hi

Re: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Generally, if you are on a version of Oracle that has a bug free implementation of LMT's, then use them. 8.1.7.1 or 8.1.7.2 I believe. There's no reason not to use them otherwise. Jared

Re: VLDB backup policy

best case, unlimited funds, you need something like EMC's SRDF or IBM's HACMP which are remote mirrored solutions. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear list ! > I'm reposting this , since got no replies yet. > > I need to design a backup policy for a VLDB sized some 10TB, runni

RE: Determining Striping

If memory serves on Solaris it is called Solaris Online Disksuite or something like that -Original Message- Sent: 02 January 2002 15:30 To: Multiple recipients of list ORACLE-L Not sure if you can show striping with a command. Using the DF command usually shows all disks in the disk fa

RE: oracle not available ???

If the database was shutdown cleanly, the online logs are not required or desired. If the database was not shutdown cleanly, you will not be able to open the database without them. Jared

RE: stupid oracle on windoze question

well the thing is, he wasn't looking for TNS_ADMIN since that just re-sets the directory Oracle looks at but wanted something that worked more like how login.sql works -- where if you have the file in your local working directory, it is used and overrides any other file. In Unix, if you have a .t

RE: Becoming a DBA questions

Judy, Of course they are. After all, that's what they sell. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Peddycoart, Judy [SMTP:[EMAIL PROTECTED]] > I don't yet have my OCP, but my boss is encouraging me to g

RE: VLDB backup policy

thanks a lot Kimberly ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 5:35 PM To: Multiple recipients of list ORACLE-L You could split off a mirror and backup the mirror however, I have never done that so I am not

RE: stupid oracle on windoze question

Not only is it not in the flaming manuals, I don't think you can even do that on Windoze. Sure, you can set the TNS_ADMIN var in ControlPanel->System->EnvVars, but that is rather broad in scope and does not offer the granularity available on unix. Jared

RE: stupid oracle on windoze question

In my research the TNS_ADMIN does not actually "re-set" the directory where Oracle looks. The presence of a TNS_ADMIN env var is checked first, if found then this path is used to locate the tnsnames.ora and sqlnet.ora. If it is not found, Oracle looks at the ORACLE_HOME env var, if found then it

Re: stupid oracle on windoze question

[EMAIL PROTECTED] wrote: >well the thing is, he wasn't looking for TNS_ADMIN since that just >re-sets the directory Oracle looks at but wanted something that worked >more like how login.sql works -- where if you have the file in your >local working directory, it is used and overrides any other fi

RE: VLDB backup policy

Andrey, I think that you are looking at this problem from the wrong end. Rather than come up with backup scenarious first and reporting back to management, I think you need to get managment to declare to you their "Mean Time to Recovery". By this I mean that they need to tell you how long they

RE: Becoming a DBA questions

You're right - it keeps me gainfully employed! :) -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Judy, Of course they are. After all, that's what they sell. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED]

Re: VLDB backup policy

I would also suggest (in a world somewhere between ideal and 'cheapest') using Veritas NetBackup with the Block-Level Incremental extension for Oracle. This is really nice for saving on tape costs and backup time - it performs incremental backups of your datafiles on a block level (thus the name)

RE: Ora-1555

Note, I have been able to find many Oracle white papers using google.com... -Original Message- Sent: Monday, December 17, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Thanks a bunch, Gopalakrishnan Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTE

(Fwd) Forms (v5) Developer Supported on Windows2000Pro?

--- Forwarded message follows --- Will Forms 5 work on Windows2000Pro? Is it (or was it) officially "supported" by Oracle? thanks, ep --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTE

RE: Determining Striping

Typically vxprint if you're using Veritas, or metastat (or cat /etc/opt/SUNWmd/md.cf) for Disksuite. hth connor --- Robertson Lee - lerobe <[EMAIL PROTECTED]> wrote: > If memory serves on Solaris it is called Solaris > Online Disksuite or > something like that > > -Original Message- >

RE: A DBA's career development

Title: RE: A DBA's career development Try learning other databases.  That way when you go into a new project, you can decide which may be a better one to use for the job. i.e.  Having oracle for a small in-house database to track your timecards would be serious overkill and costly.  Even a fr

Re: Determining Striping

vxprint -ht will print it out in nicer format than just vxprint, explicitly listing the stripe width/colums for each plex. i.e.: v index01 fsgenENABLED ACTIVE 97179648 SELECTindex01-01 pl index01-01 index01 ENABLED ACTIVE 97180800 STRIPE5/64 RW sd index-a-01 i

RE: VLDB backup policy

Thanks a lot to all who replied ! Tom , thanks , i forgot to mention , the DB is expected to get recovered in something like 1-3 hours. Another correction , the DB size will be around 1TB for the beginning and is expected to grow to 10TB within a couple of years. HAPPY NEW YEAR ALL ! DBAndre

Re: stupid oracle on windoze question

Hi Jared, Sorry,  I misunderstood the question. Environment variables can, however be set locally instead of at the system level tns_admin= inside of a .bat or a .cmd script,  maybe even perl :-) John [EMAIL PROTECTED] wrote: Not only is it not in the flaming manuals, I don't think you

iFS

Title: RE: A DBA's career development Out of curiosity, is anyone using iFS in a production environment?   Regards, Patrice Boivin Systems Analyst (Oracle DBA) Acting Head, System Admin & Operations Bedford Institute of Oceanography Fisheries and Oceans Canada subscribing).

RE: stupid oracle on windoze question

nope, it doesn't. in unix, Oracle will check the same path with this exception: it first looks for a ".tnsnames.ora" file in the $HOME directory of the logged in user. If the file is there, it is used, if not, Oracle continues to check TNS_ADMIN and then network/admin --- eric harrington <[EMAI

RE: stupid oracle on windoze question

ah but you can do something similar, at least according to Joe -- he found it on a thread on MetaLink. You put a tnsnames.ora file in your local directory (I would suppose without setting TNS_ADMIN) and then it will use the local one interesting, veddy interesting --- [EMAIL PROTECTED] wrote:

RE: VLDB backup policy

The problem is, most business users say "5 minutes" (and btw, the emc srdf option is actually faster than a hot standby, since a hot standby might need log files to be applied while the mirroring does not -- check out Lawrence To's papers) so you go ahead and figure out what a "5 minutes" scenari

RE: VLDB backup policy

Title: RE: VLDB backup policy What type of application is it (OLTP, DSS, mixed, etc.)?  Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)? -Original Message- From: Andrey Bronfin [mailto:[EMAIL PROTECTED

Re: VLDB backup policy

One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete backup plan in and of itself. George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002

local partitioning question

Esteem members of the list. I hope this new year finds you and your's healthy and prosperous. I have a question on partitioning and the changing of the values assigned to the partition during creation. The tablespace was created with AUTOEXTEND ON next 2 M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2

Re: stupid oracle on windoze question

HI All,   It is in that useless documentation, from the Net8  Administrators Guide Ensure that the client machine has the tnsnames.ora and the sqlnet.ora files in $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms. The search order f

Re: VLDB backup policy

absolutely true -- but if they want "instant" recovery, then this will handle hardware failure --- George Schlossnagle <[EMAIL PROTECTED]> wrote: > One problem with SRDF though is that it doesn't protect against block > corruption. SRDF is really really cool, but is not a complete backup > plan

Shared pool wait for library cache pin

We are seeing a lot of shared pool waits (for libary cache pin) on our 8.1.5 web-based application. We are seeing this via Precise/Indepth SQL monitoring tool. I haven't been able to find much documentation on shared pool waits or library cache pins. Can anyone tell me what might be causing th

RE: VLDB backup policy

It works really well for a DR site though!! Greg -Original Message- Sent: Wednesday, January 02, 2002 2:20 PM To: Multiple recipients of list ORACLE-L One problem with SRDF though is that it doesn't protect against block corruption. SRDF is really really cool, but is not a complete ba

RE: A DBA's career development

Andrey, Valid questions: And the answer? "It depends" :) It depends on some factors such as the size of your shop and their plans (in case you want to stay with them), the time (and $$) that you can invest on learning, your own background, likes and dislike, etc., as well as possible prediction

RE: Table MONITORING

In one version (I think is was 8.1.6.x.x) analyze stale didn't work right.  In 8.1.7 (releases the we've tried, .0 and .2), it didn't work for partitioned tables.  The monitor piece appears to work, so one of the other dba's here wrote a script using all_tab_modifications and dynamic sql to

Re: Shared pool wait for library cache pin

Do any of your queries have a high version_count (visible through v$sqlarea)? George - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 3:20 PM > > We are seeing a lot of shared pool waits (for libary cache pin) on > ou

Re: stupid oracle on windoze question

learn something new every day. --- orantdba <[EMAIL PROTECTED]> wrote: > HI All, > > It is in that useless documentation, from the Net8 Administrators > Guide > >1. Ensure that the client machine has the tnsnames.ora and the > sqlnet.ora files in $ORACLE_HOME/network/admin on

RE: VLDB backup policy

Title: RE: VLDB backup policy check out SharePlex for Oracle. The target system is completely open and available while it is applying the changes from the source.  If you are expecting < 25 GB of redo generation per day, it will usually be under 15 seconds latency.  And it's a LOT cheaper than

Problem Setting Up User

I am having a problem setting up a user on my DB (W2000 / 8.1.7). I have my self as user KENNETH and the new user is KIMV. She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus TABLE_NAME. Here is what I have (I am grantee KENNETH and the user I am setting up is KIMV):

Re: Shared pool wait for library cache pin

Yes, there are a handful with more than 400. I'm not sure what high is? Cherie "George

RE: Problem Setting Up User

Create a synonym for KENNETH.TABLE_NAME coz if she(KIMV) doesn't own it she will have to prefix the owner before the table_name. HTH Shailesh -Original Message- Sent: Wednesday, January 02, 2002 4:05 PM To: Multiple recipients of list ORACLE-L I am having a problem setting up a user on

Re: Problem Setting Up User

Have you created synonyms? At 01:05 PM 1/2/02 -0800, you wrote: >I am having a problem setting up a user on my DB (W2000 / 8.1.7). > >I have my self as user KENNETH and the new user is KIMV. > >She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus >TABLE_NAME. > >Here is what

Re: Problem Setting Up User

Hi Ken, You have to fully specify all of the roles that you want to be default in one alter statement alter user kimv default role connect,db,resource; should turn all to YES. You may also need to make sure that your synonyms are public. Hope this helps, John [EMAIL PROTECTED] wrote: >I a

Re: Shared pool wait for library cache pin

Cherie, What constitutes 'a lot of shared pool waits (for libary cache pin)'? Does it represent a significant percentage of total waits, or is it just crossing some predetermined threshold? Is it causing a performance problem? ( as seen by users, not by a monitoring tool ) Jared

Install 8.1.7 release 3 Enterprise Edition

I installed on NT 4.0 server. Taking the default install it installes all and begins to initialize the default database and gives the message ora-03113(End of file on communications channel) after about 90% installation. Have tried it from multiple machines with the same results. It worked fine fo

RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Arul - I would recommend reading "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an Oracle white paper. I was going to provide a link to it, but Oracle's website search function doesn't seem to work for me right now. Dennis Williams DBA Li

Re: Problem Setting Up User

Ken, Take a look at 'create synonym' in the docs. There are two kinds: public and private. For a private synonyms, the user KIMV would need to execute the statement 'create synonym TABLE_NAME for KENNETH.TABLE_NAME'; For a public synonym, a user with the 'create any synonym privilege' would

RE: A DBA's career development

Andrey - You may also want to consider positioning yourself toward being a system architect. How are your data modeling skills? Skills at building a group consensus? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 02, 2002 9:15 AM To: Mu

RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Google to the rescue... just one of the many links: http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm -Joe At 02:10 PM 1/2/02 -0800, you wrote: >Arul - I would recommend reading "How to Stop Defragmenting and Start >Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an >O

RE: A DBA's career development

I'd like to be rich and retire now. Spend more time with my family and kids. Also spend more time in playing Tennis. When this happens, I do not want to see Oracle:)- But can't! -Original Message- Sent: Wednesday, January 02, 2002 10:15 AM To: Multiple recipients of list ORACLE-L De

Re: Install 8.1.7 release 3 Enterprise Edition

Just skip the default database. If you really want it, just have the installer generate scripts then run the scripts manually. Jared "Gordon, Emery

Re: A DBA's career development

"Khedr, Waleed" wrote: > I'd like to be rich and retire now. Spend more time with my family and kids. >... > When this happens, I do not want to see Oracle:)- Ooohkay...but you still going to stick with us sorry lot that still have to fight the brain-frying, mutant-cyber pokemon-beast, right ???.

RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Happy New Year! Agreed! I like so much with locally managed tablespace because every extent size is uniform, therefore no fragmentation; you don't have to worry about the number of extents at the table level. I even make the temporary tablespace to be LMT. What is the acceptable extent size if

Perl Script to get DDL from Indexfile - Part1

I've always wanted an easy way to extract DDL info from an import indexfile so I wrote a little perl script that will extract create table ddl from an indexfile. Seems to work and is a lot faster than hand editing. Would appreciate any feedback/criticism or ways to improve the script. #!/usr

Perl Script to get DDL from Indexfile - Part2

For indexes, use this: #!/usr/local/bin/perl -w # Extract CREATE UNIQUE|BITMAP INDEX statements # By: MKB Jan 02 2002 # Inputs: Location of log file and file output # Outputs: Writes to file output # Modification History: # use strict; my ($infile, $outfile); m

Perl Script to get DDL from Indexfile - Part3

Finally, to get the ALTER statements from the indexfile: #!/usr/local/bin/perl -w # Extract ALTER TABLE statements # By: MKB Jan 02 2002 # Inputs: Location of log file and file output # Outputs: Writes to file output # Modification History: # use strict; my ($i

RE: Becoming a DBA questions

You know, I did not intend to leave the Fujitsu account either. But come the end of March I will be. -Original Message- Judy Sent: Wednesday, January 02, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Somewhat different, but my son's taking his CCNA (Cisco Certified Networking A

Re: Problem Setting Up User

Ken, First a question - what did you do for Oracle when you worked there? second... KIMV needs a synonym for the table to be able to refer to it with an owner qualifier third, you can only have ONE default role. Think about it. If you really want the user to have the privs of several roles at

Re: Shared pool wait for library cache pin

Have u tried disabling the timed_statistics=false in 8.1.5 there is a bug I am not sure. But try this out, When you are saying u are seeing very high version_count,then I have a feeling it pointing to that bug. Try disabling the timed_statistics and see. >From: [EMAIL PROTECTED] >Reply-To: [E

Re: A DBA's career development

Dear Andrey and other Fellow DBA's, For quite some time I have been wondering about the same fact that Andrey has thought. I started my career Oracle 7 DBA and moved on. When 8 was released, we quickly did not upgrade the db. Now when 9i is released, with so many things in it, I asked myself wh

Re: Shared pool wait for library cache pin

Hi, Queries with high version counts can cause library cache latch contention, as the query must hold that latch during soft parse and has to go through the entire list of query versions in the data dictionary. High version_count's are often caused by a high number of invalidations on the query.