Programming :: Understanding Oracle Execution Plans?
Mar 30, 2010
As part of my job I often have to write queries in Oracle (10g) and I am experienced enough to see where I should be using an index where possible etc. Most of the time I just let the CBO come up with the best plan however sometimes it obviously doesn't!Now, I know in general that full scans of large tables aren't good however I don't fully understand an execution plan - ie, I could not look at a complex piece of code, look at it's plan and say "oh, the reason that is performing badly there is because the SBO has chosen to use nested loops rather than a hash join, so if I hint it then it will run quicker!" - this ultimately is where I'm trying to get to
View 2 Replies
ADVERTISEMENT
Apr 19, 2011
For this code:
Code:
class B1
{
[code]....
View 11 Replies
View Related
Dec 3, 2010
var param = function() { <whatever> } ;What exactly does the above MEAN, and why have they included this in the language this way?
View 6 Replies
View Related
Jun 20, 2011
2 Questions:
1) Is there a dedicated forum on the net for people writing Linux drivers?
2) I've been reading over how Linux drivers are put together and even made my own dummy driver. However, before I begin writing the "real" driver I set out to write, I would like someone with some driver writing experience to verify that my knowledge is correct.
The driver I intend to write is for a PCI card. The very first thing I need is to know is the vendor ID and device ID of the card. After having that information, I can then use the pci_register_driver command to open a connection to the card. At this point, I need to use the pci_*_config_* commands (an example of a pci_*_config_* command is pci_read_config_byte) to figure out where the device is mapped in memory and what I/O ports I need. Now, the pci_* breed of commands take a parameter integer (which is an address) as there second argument. The address(es) which I will use and what they accomplish is device dependent. At this point, after having otained the I/O ports I need, I can then begin writing to them via the inb, outb, etc commands. Writing to X port will have Y result but this is vendor specific.
View 2 Replies
View Related
Nov 20, 2010
I have been reading some books about device driver development etc.I made a char driver of bond (dummy) device. My book says that PCI devices contain three addressable regions,configuration space,IO ports,and device memory,the book talks about a file include/linux/pci_ids.h and PCI addressing etc.I read about following functions
1) pci_read_config_
2) pci_write_config_ some thing known as offset is defined to be passed on as an argument to above functions
3) IRQ number assigned to a card function pci_read_config_byte_,configuration register offsets
4) pci_request_region I want to write a pci driver for my own understanding and I am reading some books about it.
[Code]...
View 2 Replies
View Related
Jan 6, 2011
I'm reading "Understanding the Linux Kernel" and came upon this assembly instruction:
movl $(__KERNEL_CS << 16), %eax
I am curious as to what "<<" means/does. I tried to gooogle, but google doesn't search for "<<".
View 7 Replies
View Related
Mar 28, 2011
I have been doing programming since the last 5 years. however, i have used to cut and paste the template without knowing in depth since i am chasing the time to finish a certain project. The title above seems easy if we read the manual, its just that im kinda confuse just for a second. Hope you guys can help me to give a better understanding for me so that i can upgrade my knowledge.Well, during my normal practice cut and paste, i try to understand this code below :-
Code: pid_t pid;
pid=fork();
if (pid < 0) {perror("Erro spawning process : "); exit(EXIT_FAILURE);}
[code]....
View 4 Replies
View Related
Mar 30, 2010
I have a file named "test.txt". It contains the following:
Hello $USER1
Your boss is $ADMIN1
Now, I want to do something like this:
export USER1="World"
export ADMIN1="Me"
cat test.txt > test2.txt
And achieve something like this when I view the contents of test2.txt:
Hello World
Your boss is Me
The problem is, it's not that easy to achieve. I don't want to do the "echo Hello $USER1 >> test2.txt" because I'm planning to implement this on a MB-sized text file.
View 5 Replies
View Related
Aug 7, 2015
I'm trying to save the output of the script I wanna run but for some reason I cant manage to do it with "script.sh > Output_4.txt"
The thing is that the script was already run and it extracted some directories so when I try to run it again (to save the log to a Output_4.txt) bash says (see screen-capture) and of course the log's empty!!!!
View 2 Replies
View Related
Jan 3, 2011
I went to an interview last week and there was this guy who asked a simple question that i have been trying to solve for a couple of days. I tried google but i just cant get the search keywords right. The result were just useless. Well, the question is : "How can we allocate a limited memory to a process before we start its execution" well, the question is related to an X11 system so may be some flags must be set to limit its memory.
View 9 Replies
View Related
May 3, 2011
In gui validation if user enters string in integer requiring field, a dialog box pops out. So on clicking the button i want to stop the program execution and return to the previous jframe(either the same one or newly created object of it).
How can i handle this in java.
I tried calling main(); but it doesn't work.
Also System.exit(0); doensn't work.
View 1 Replies
View Related
Mar 15, 2011
I have a bash script which is composed of different functions.I want to able to select which functions to be executed when i run the script, for that i thought about using a flag in the function. but i dont know how to skip the function whose flag is set to zero.
Code:
myfunc1(){
local flag=1
commands
{
[code]....
View 2 Replies
View Related
Apr 27, 2010
Do you know how to write a shell script that executes say 4 instances of the same program in different directories at the same time, and once ONE instance completes it executes a new instance of that program in a new directoryd so on, until 100 instances have been executed, each in their own directory
View 5 Replies
View Related
Jul 13, 2010
I have a test framework written in tcl which i run for 5-6 hours.Now i want to retrieve the pid of the process (execution using framework) as first few line of the script and do some processing.
How this PID retrieval is possible in tcl?
View 1 Replies
View Related
Aug 28, 2010
I'm trying to figure out how to continue execution of a Python program while a background task is going on.
In bash, it is adding "&" to the end as in:
Code:
#! /bin/bash
find / -iname "*.py" > /tmp/all_pys &
echo "looking for all python scripts and putting them in /tmp/all_pys"
(yes, I know I could just put the echo BEFORE the find but I just use it for example)
Say I do that in python (not necessarily running the shell, but perhaps using scriptutil.ffind or something similar), but want to allow the user to be doing something else while running that search in the background, how would I thread, fork, subprocess (not to be confused with the module and Popen) [or whatever I should call it] that?
View 14 Replies
View Related
Jul 11, 2010
are there plans to make ubuntu work with different devices - tuners, printers, scanners, local net etc?
nothing of mine isn't working - there are no drivers.
no for lexmark z35
no for scanner mustek bearpaw 1200 cu plus
no for tv tuner aver media 507
no local net with sharedfolders (I don't no how install it - in windows xp local net appeared itself i have only connected my wi-fi router and gave names to the local net and pc) it is sad - I should use Windows to have everything work good Manual searching and installing such drivers are so terribly difficult ubuntu or other linux OS is good idea to have alternative OS but it's no chance to use it for most of people - it is too difficult no make it good
View 1 Replies
View Related
Nov 27, 2010
I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??
View 2 Replies
View Related
Jul 24, 2011
I've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.
1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb
2) Then I ran
sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.
I ran the following command-
--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client
Then I again ran the following command to install oracle-xe
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
See below what I got as the output-
rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)
[code]....
Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.
View 1 Replies
View Related
Oct 12, 2010
I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle
The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:
PHP Code:
Code:
How to troubleshoot.
View 2 Replies
View Related
Jul 11, 2011
I'm having some trouble this morning to send a SQL query to our Oracle DB server in PHP. When I try to pass my value "OF/110246801A01" as variable it tell's me "Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number"
PHP Code:
$ociO ='OF/110246801A01';
$selectAllFieldsFromOf=oci_parse($conn,"SELECT*FROMMFGOPEWHEREMFGNUM_0LIKE':ociOf' ");
oci_bind_by_name($selectAllFieldsFromOf,":ociOf",$ociOf,15);
$resultQuery =oci_execute($selectAllFieldsFromOf);
if(!$resultQuery){
$e = oci_error($selectAllFieldsFromOf);
return trigger_error(htmlentities($e['message'],ENT_QUOTES),E_USER_ERROR);
[Code]....
View 1 Replies
View Related
Apr 7, 2011
creating the below unix script to run in oracle database .I need a script which should do the following things.
1. The script should insert row count of a table from one database(A) into table (AB) in another database(B).
2. The script should update tow count of the similar table and tablespace from database (B) in to a table AB.
3. The script should update the status column of the table AB as: 'Y' if the rowcount of the table@A and rowcount of the table@B matching. or else it should update 'N'
View 4 Replies
View Related
Jan 27, 2010
How to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
View 4 Replies
View Related
Mar 8, 2010
I setup linux script to delete my backups older than few days:
RBRDAN=`date �date=�3 days ago� +%w`
rm /u02/oracle/backup/rman/$RBRDAN/*
But, I got error:
[code]...
View 2 Replies
View Related
Jul 19, 2010
I am writing shell script for executing oracle procedure. Shell script need to take 3 parameters from one data file rest of the parameters need to pass in command line it self. Total 7 parameters are need to pass for shell script.1st,3rd,5th parameters need to take from dat file and rest of 4 parameters from command line.
Below is one oracle procedure:
EXEC CIM_MGMT_INSTALL.addFlow('$1','1.0','$1','Settings','$2','ECCD2',NULL,1);
$1is 1st and 3rd both places need to pass same parameter.$1,$2 need to take from data file as earlier says.
View 2 Replies
View Related
Aug 17, 2009
I have installed Oracle 11g on 5.3. Now, I am trying to START and STOP oracle automatically on system startup and shutdown. I am following this link To have this effect, I have created /etc/init.d/dbora
Code:
#!/bin/sh
# chkconfig: 345 99 10
ORA_HOME=/oracle/app/oracle/product/11.1.0/db_1
[code]....
View 4 Replies
View Related
Jun 21, 2011
Which FOSS software would you recommend to create spatial plans? Specifically I am doing some tree gardening. The first phase is a survey of the house outline and existing trees by tape measure so I will end up with a matrix of points and distances between them. The site is essentially flat so this is 2D work.
AFAIK neither of the drawing packages I know slightly (OOo Draw and Gimp) are well suited.
View 3 Replies
View Related
Sep 8, 2010
Recently upgraded to Centos 5.5 and was suprised to see that the distro still is running php 5.1.6.Anyone know when Centos RH plans on upgrading php in future distros?
View 4 Replies
View Related
Nov 12, 2010
I am learning how to use DD for creating images across networks and locally but needed some clarification.
1 - When creating an image, I noticed that there is no verbose to show you the progress, How can I accomplish this?
2 - When I run this on a 8G usbstick it takes a long time to image. How can I speed up this process?
PHP Code:
dd if=/dev/sdb of=/home/test/images/image.dd
3 - When an image is restored like
PHP Code:
dd if=/home/test/images/image.dd of=/dev/sdb
will that give me a working bootable usbstick? For example if I imaged a working usbstick with Ubuntu on it using DD and restored it like the example above on a different usbstick, will this give me a booting new usbstick? I hope that came across ok?
View 1 Replies
View Related
Aug 1, 2011
I have an application that uses port 8080 all the time. One time, for some reason, it was taken by I didn't know what.
View 2 Replies
View Related
Aug 21, 2010
I don't quite understand how pipes work in bash. I know that it takes an output from one command as the input in another command. What an output is I can get because it's what the command prints out to the screen. But how do I know what input a command will take? Here is an example I thought would work:
Which gem | rm
Unfortunately it didn't.
Which gem prints out "/usr/bin/gem" so that must be the output right? I thought that was given to rm so it would be "rm /usr/bin/gem" but I was wrong. How do I know what input a command takes?
View 4 Replies
View Related
