Oracle
in [SQL]
|
Significant discrepancy in V$OSSTAT since upgrading to 10.2.0.5 I used V$OSSTAT for monitoring in 10.2.0.4 and it was much more accurate than is the case with 10.2.0.5. Look at this: SQL> column stat_name format a20 SQL> select stat_name,value from v$osstat 2 where stat_name like '%TIME'; STAT_NAME VALUE -------------------- ---------- IDLE_TIME 80163480 B... 21 Jul 2010 18:00
Simple Hack To Get $2500 To Your PayPal Account. Simple Hack To Get $2500 To Your PayPal Account At http://100bestvideos.co.cc Due to high security risks, i have hidden the PayPal Form link in an image. in that website On Top Side Above search box , click on image and enter your PayPal id And Your name. please don,t tell to any One. ... 21 Jul 2010 02:40
Multiple SAP CRM requirements for Direct client Hi, Please find the all open SAP requirements and let me know on which you are interested and fit. In case you are not available please forward this requirement to your friend or colleague that you think might be interested. Location: Greensboro, NC o Role: SAP CRM Functional Lead consultant 1. Stron... 20 Jul 2010 12:25
Simple Hack TO Get $1500 To Your PayPal Account. Simple Hack To Get $1500 To Your PayPal Account At http://1001videos.co.cc Due to high security risks, i have hidden the PayPal Form link in an image. in that website On Top Side Above search box , click on image and enter your PayPal id And Your name. please don,t tell to any One. ... 20 Jul 2010 03:44
Oracle Shell Script I know how to use a shell variable in a query from shell. Can anyone help? This works fine ---------------------- data_rec=`sqlplus -s $user/${password} << "EOF" set heading off feedback off verify off timing off SELECT owner||':'||name FROM replicated_tables WHERE obj_type = '$type'; exit EOF` ... 20 Jul 2010 17:57
convert XIDUSN,XIDSLOT,XIDSQN to start_scn for old transaction to find first archived redo log file for logminer session Hi, (Oracle 10gR2 10.2.0.4 AIX6) Stuck in a Streams apply process. I now the XIDUSN,XIDSLOT,XIDSQN. Want to convert this to start_scn to find the first archived log for this transaction. The transaction is not any longer in v$transaction so cannot use that to get start_scn. Want to use start_scn to do this: ... 17 Jul 2010 14:07
Oracle 11.2.0.1 does it contain 11.1.0.7. I am on HP UNIX 11i. I am looking into whether I should use Oracle 11.1.0.7.1 or Oracle 11.2.0.1. I will not be using any new features of 11.2.0.1; but one concern I have is 11.2 may not have all the bugs fixed up to 11.1.0.7.1 because Oracle has started development Of 11.2 sometime ago and they may not have sy... 16 Jul 2010 22:02
Solution from the space monitoring scripts For years, I had my own scripts that were calculating the available free space from dba_free_space and dba_data_files. I just discovered the DBA_TABLESPACE_USAGE_METRICS table which has the necessary information, presented in an easily usable way: desc DBA_TABLESPACE_USAGE_METRICS Name Null? Type ... 16 Jul 2010 16:33
Another annoying delay Tom Kyte's book "Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition" was supposed to be released yesterday and it isn't yet available on the Amazon. What is he doing? Can Oracle Corp. clone him? We need more than a single Tom Kyte. Things w... 19 Jul 2010 14:38
MAKE UPTO $5000 MONTHLY! $2000 INYOUR FIRST 30 DAYS! MAKE UPTO $5000 MONTHLY! $2000 INYOUR FIRST 30 DAYS! Generate $50 to $100 whenever you have a couple of hours free time to spare. You could make $50 or more in the next 2 hours. Starting right Now!Today! Earn from your free website Awesome earnings get paid for your honest work Join as a free member and get pa... 16 Jul 2010 03:23 |