18/11/2017 11:47
I've been doing a lot of parallel updates lately, and monitoring themin DbArtisan, which is a third party tool. I am seeing that thesqlplus session which spawns the update becomes blocked, while theparallel slaves are processing. In some cases, SMON and QMN0 becomeblocked as well, and the database seems to come to a screeching halt. I've tried running sqlplus queries to determine who is blocking who,but that too becomes blocked and doesn't come back, so I've not hadany luck wit.... read more

2 answersclick here to view

16/11/2017 11:47
Hi, This is Mandar Purandare , I have two preapproved labor each in EB2and EB3 category Our terms are simple , you need to take care of legal charges and joinus , and that's all Kindly forward your resume in word format to mandar707@gmail.com orcall me for more details on 402 408 3687 or 402 408 6601.
Thanks & Regards, MandarContact - 402 408 6601/ 402 408 3687Email - mandar707@gmail.com

2 answersclick here to view

15/11/2017 11:47
http://news.bbc.co.uk/2/hi/business/4071909.stm IBM or CIA is successfully enter in China and hiring Red ArmyProfessionals as IBM consultants to achieve the ultimate aim ofbreaking of China.
In last 3 years, IBM hired over 30,000 Chinese to get the insideknowledge of China. In New York City, few Chinese from Chinatown are openly told about it.
B

3 answersclick here to view

14/11/2017 11:47
Per the subject line, this drives me bonkers. I have a particularerror message for which I am searching a solution. All I end up withare hits for some moron that wrote...
i=1;while [ $i -le 30000]; do oerr ora $i i=$(($i + 1))done ...and uploaded the output on the internet.
There...now I feel better :)

1 answersclick here to view

13/11/2017 11:47
Hi all, When I generate table scripts with TOAD, the script declares thevarchar2 column size with: varchar2(10 byte) instead of varchar2(10).
The latter is what I'm used to.
Also this script won't run on every (version of the?) database.
Can someone tell me the difference between the 2? thanks Guyon Mor=E9e

4 answersclick here to view

12/11/2017 11:47
I'm using 'make' to rebuild and populate a database that needs a user and password. In the Makefile I've got a line something like: cat data.sql > mysql database --user='fred' --password='secret' ..... Bat I don't want the password to be in plain text and visible in the Makefile. I've tried just saying --password= expecting 'make' to pause while mysql prompts for the password, but it doesn't work.
I'd welcome any suggestions, please.
.... read more

2 answersclick here to view

11/11/2017 11:47
hi all: Recently cursor:pin S wait on X wait event troubles me.
I have two DB Server for a website. Everynight, Server A pushnew data to Server B by one way. Because some security reason, ServerB can not pull data from Server. So, I using following query toinsert data to Server B: insert into table_a@ServerB select * from table_on_server_a; That is: I create a db link on Server A for Server B .
I running this query on Server A without any problem.... read more

3 answersclick here to view

10/11/2017 11:47
I've been charged with taking hot backups of our database. It's Oracle8.1.7 on Solaris 8 (sparc).
I've come up with a RMAN script, but I'm not sure where to tell Oracle toarchive log current. Below is the current script.
run { allocate channel tape1 type 'sbt_tape'; backup format '%d_%u_%s_%p_%t' (database); sql 'alter system archive log current'; backup format '%d_%u_%s_%p_%t' (archivelog all del.... read more

2 answersclick here to view

09/11/2017 11:47
Hi, i have a performance problem for distributing selected data toparallel pipelined functions. The worker-threads are started with hugedelay, because *all* data from base 'select' are fetched first, thenthey are distributed (delayed) to the worker-threads. I want the datato be pumped to the worker-thread right away - while the base 'select'is still busy.
The problem is due to a trailing 'order by column_x' in the base'select'. The reason for that again is, that i.... read more

2 answersclick here to view

08/11/2017 11:47
A newbie's question. How oracle add an index on nested table. F.g.
Table Student: sid sname classes_registed{class_id, class_name} 01 marry {{c1, classA}, {c2,classB},{c3,classC}} Can Oracle add index between sid and class_id, so that if a query givec1, c2, or c3, I can locat 01's whole tuple?? Thanks a lot.

1 answersclick here to view

07/11/2017 11:47
Hi,I need to migrate 500 GB Oracle 9.2.database from one platform (SunSPARC Solaris) to another (Sun x86 Solaris) with minimal outage. Theplan is: 1. Create empty database on the new server.
2. Shutdown application.
3. Run Export on the old server4. Run Import on the new server5. Start application and connect to the new database.
It works fine, just takes too long, even with direct export, importingmultiple schemas in parallel, etc.
Would it be possible to use fast refresheable snapshots (Materi.... read more

3 answersclick here to view

06/11/2017 11:47
db version 9205 We are using rman to do level 0 and level 1 backups through out the month. RMAN also does the archivelog backups a couple of times a day. Is there a report I can run in RMAN which will tell me if I am missing any needed archivelogs to perform a full recovery from the last level 0?

1 answersclick here to view

05/11/2017 11:47
Hi there, I am currently running a mysql 4.0.18 installation on a production server. Now I would like to update the version to catch up with security fixes. On the MySQL site it made the impression to me that 5.0 is ready for pruduction use. But what benefits does it do for me instead relying on a 4.0, 4.1 installation? I fear that my webapp might brake in some points. Is 5.0 significantly faster, or more secure? Thank you for any hints, Merlin

1 answersclick here to view

04/11/2017 11:47
I'm creating a copy of a production database on a different machine from an online backup and am missing something simple here (I think the combo of doing this over dial-up and screaming kids in the background is getting to me) I created the directory structures on the target machine, edited the init.ora to reflect any changes, copied datafiles from latest online backup and controlfile copies from the current controlfile backup (not trace) to the target machine etc., created the service wi.... read more

5 answersclick here to view

03/11/2017 11:47
Poll: How fast is YOUR database in rows per second, on a full boretable scan??? This is for those who like Tom Kyte's work, and empirically get theirmetrics.
Quoting: ftp://ftp.software.ibm.com/eserver/benchmarks/FDC_BC_CompAnalysis_Dec2004.pdf, The 8-node completion time for the test was 24 minutes. To put thisin perspective, returning this query in 24 minutes means Oracle9i RACscanned and sorted roughly87,000 rows per secondper CPU or 1.4 million rows per second clusterwide. This makes.... read more

6 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS