Very Large Databases

Oracle 9i Query Time

What would be an expected time to run a query that will extract 1.4 million records?There are two tables involved. Customer and Address.And No Condition.

View Answer   |  May 6 2005   11:45 AM GMT   |  asked by jummadaay
Database issues, Database Management Systems, Very Large Databases

Oracle 8i/9i Database Access

In the past, many privileges were granted to the PUBLIC pseudo-role in a couple of our databases with a large number of users. We created a role named XPUBLIC and moved all of the privileges to it and are now attempting to limit users to privileges they actually need. Does anyone know of a way to...

View Answer   |  Feb 25 2005   3:26 PM GMT   |  asked by stevewaltz
Very Large Databases

Oracle DataBase Connectivity

Hi, Gurus,I am a Oracle Db Administrator managing about 5 Gb DB on windows NT. There are approx 100 user connecting concurently from clients on Win 9x,XP And Win NT Ws.Last Day What happened one Xp Client Hung causing all to hung. The client machine was hard booted.After that any one trying to...

View Answer   |  Feb 12 2005   7:16 AM GMT   |  asked by kanhaiyababu2002
Database issues, Very Large Databases

Starting isql*plus

Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like:http://localhost:<port_number>/isqlplusProblem is, how do you determine the localhost and port number?Second, how can i use Enterprise manager to create reports about my tables in the Oracle...

View Answer   |  Sep 27 2004   6:48 PM GMT   |  asked by wanaug
Database issues, Database Management Systems, Very Large Databases

Oracle 9i Designer

Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns:Database generationReverse engineeringAccurately representing every detail of a databaseSpeedUse for different DB platformsThanks for any comments.

View Answer   |  May 12 2004   3:29 PM GMT   |  asked by pegasusdba
Availability, Modeling, Security