| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | On Fri, 17 May 2013 11:01:09 +0100, Jonathan Lewis wrote:
Jonathan, what would that look like from the implementation perspective?
As far as I...
Mladen Gogala
|
Yesterday 09:24 PM
Justin Mungal | 6 | 7 |
|  | I was told last week that there was a method of ensuring ( via stored procedure ) that a specific sql_id can be seeded into awr.
Have scanned...
chris.brown@providentinsurance.co.uk
|
05-19-2013 11:29 PM
Justin Mungal | 5 | 18 |
|  | Jazz show on Youtube search paperthaga
Brian Thaga
|
05-19-2013 02:40 AM
Brian Thaga | 0 | 2 |
|  | I consider myself pretty decent with Postgres and MySQL. But I'm really struggling with Oracle, clearly because the administration model is really...
Guyren Howe
|
05-17-2013 12:45 PM
ddf | 10 | 23 |
|  | I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 95% full and keeps growing. I am however unable to find which file(s) are...
zigzagdna@yahoo.com
|
05-17-2013 01:48 AM
Mladen Gogala | 3 | 14 |
|  | Hi
Pleae see the code below. The grant statement causes the stored
procedure to fail to roll back when raise_application_error is...
neilsolent
|
05-16-2013 01:14 PM
ddf | 12 | 16 |
|  | VAM SYSTEMS is a Business Consulting, IT Solutions and Services
company with operations in UAE, Qatar, Bahrain, USA, Australia,
Singapore &...
vam
|
05-15-2013 02:48 AM
vam | 0 | 10 |
|  | Hi
Pleae see the code below. The grant statement causes the stored
procedure to fail to roll back when raise_application_error is...
neilsolent
|
05-14-2013 12:09 PM
neilsolent | 0 | 4 |
|  | I see that Egor Starostin's orasrp has not been updated for about a year.
I sent an email to Egor, no response. Does anyone know if that is...
Mladen Gogala
|
05-13-2013 06:07 PM
Mladen Gogala | 2 | 28 |
|  | I am converting a database from its current character set WE8ISO88591 to AL32UTF8
I am using NLS_LENGTH_SEMANTICS to CHAR so I do not have to...
zigzagdna@yahoo.com
|
05-13-2013 12:43 AM
Mladen Gogala | 10 | 37 |
|  | Hi
User SSF can see and execute procedure SP_GET_SERVER, and has granted
execute access to user SSF_ADMIN1. However (sqlplus session...
neilsolent
|
05-05-2013 03:02 AM
neilsolent | 5 | 23 |
|  | Hi,
I am using this query to sum data for each week in the month:
SELECT product_description, wk_start, wk_end, accepted, total
FROM (SELECT...
artmerar@gmail.com
|
05-03-2013 12:10 PM
jpbard@gmail.com | 4 | 32 |
|  | Full...
janette.pelletier@yahoo.com.au
|
05-02-2013 10:19 AM
Mladen Gogala | 1 | 25 |
|  | Hi,
In Oracle 11g, I analyzed an index and checked index_stats.
dba_segments indicates that the size of an index was about 420MB.
used_space in...
basis_consultant@hotmail.com
|
05-01-2013 01:52 PM
ddf | 3 | 19 |
|  | I have a requirement where I need to check the lower and higher
"range" for specific number
Example:
Range:
0.05
0.1
Pankaj
|
04-25-2013 07:56 AM
ddf | 4 | 26 |
|  | 11.2.0.3 Enterprise Edition
I've been asked to put together an application that will take a
query, run it in the back ground, and then make the...
Adrian
|
04-23-2013 01:16 PM
Adrian | 2 | 22 |
|  | Hi All,
I have been running fully patched 11G instances in my development and staging environments, MSWin2003, for over 2 years, never an issue....
1001111ab@gmail.com
|
04-20-2013 06:55 PM
John Hurley | 7 | 29 |
|  | Is it out yet? I can't find it.
--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Mladen Gogala
|
04-18-2013 09:18 PM
Mladen Gogala | 3 | 24 |
|  | 08 VAGAS CONSULTOR ORACLE HYPERION – RIO DE JANEIRO
Consultor Oracle Hyperion Pleno e Sênior
Quantidade de Vagas: 08
Local: Rio de Janeiro/RJ
Patricia de Souza Andreolli
|
04-18-2013 12:39 PM
joel garry | 3 | 21 |
|  | I am doing some testing of the backup and recovery of our databases.
I have a database which is in archive log mode.
I have added some records to a...
mjmstud@gmail.com
|
04-16-2013 05:13 PM
mjmstud@gmail.com | 3 | 21 |
|  | I would like to put together a batch that generates awr reports for all rac instances.
I have seen lots of examples of calling awrrpti.sql where...
chris.brown@providentinsurance.co.uk
|
04-16-2013 10:43 AM
chris.brown@providentinsurance.co.uk | 0 | 10 |
|  | I can not find that statement works well in oracle 11 sql :
select top 3 * from customers_5;
happy
|
04-13-2013 06:20 PM
Mladen Gogala | 8 | 28 |
|  | Database Database Database Database Software Cheap $20
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30...
scott93727@gmail.com
|
04-12-2013 11:14 AM
ddf | 2 | 14 |
|  | Environment 11.2.0.3 enterprise on windows 2008 r2
Here is what happened
* backed up oracle home
* applied patch 13 ( january )
* applied patch 17
chris.brown@providentinsurance.co.uk
|
04-12-2013 04:35 AM
chris.brown@providentinsurance.co.uk | 3 | 17 |
|  | =====================================================================================================================
================================...
testbanklist@gmail.com
|
04-08-2013 10:10 AM
Mladen Gogala | 2 | 16 |
|  | Hi
There's something I don't understand here with dates vs
NLS_DATE_FORMAT
I used ROUND() around SYSDATE, and in different databases I was
getting...
Syltrem
|
04-05-2013 04:58 PM
Syltrem | 4 | 25 |
|  | So... I was trying to look something up in the APEX OTN forum and noticed that no results were returned. And then someone answered my question:...
Matthias Hoys
|
04-04-2013 09:35 AM
Mladen Gogala | 8 | 21 |
|  | Hello ,
Oracle DBA consultant available with me as of now ready to take up new assignments on a Corp-to-Corp basis with your clients.
Shall be very...
Vasim Makandar
|
04-02-2013 04:58 PM
Mladen Gogala | 1 | 17 |
|  | Hello World,
Please post your oracle apps performance issues on below link.
http://oracleappsperf.blogspot.in/
Thanks,John
John R
|
03-30-2013 09:51 PM
ddf | 1 | 38 |
|  | On Mar 27, 6:03*pm, Patricia de Souza Andreolli <pa... (AT) uol (DOT)...
joel garry
|
03-28-2013 12:57 PM
joel garry | 0 | 24 |
|  | Top Business Intelligence predictions for 2013
Full...
janette.pelletier@yahoo.com.au
|
03-28-2013 12:23 AM
Mladen Gogala | 1 | 26 |
|  | I expected 12c to be announced today and they have announced the worlds
fastest CPU after P7. I must say that I'm a bit disappointed.
--
Mladen...
Mladen Gogala
|
03-27-2013 06:09 PM
Mladen Gogala | 2 | 18 |
|  | If I remember correctly Mladen thought that 11.2.0.4 would be out at
OOW 2012 ( before or just after ) ... I was more conservative and was
thinking...
John Hurley
|
03-25-2013 05:14 PM
Mladen Gogala | 3 | 22 |
|  | Simple test:
SQL> create table test1722(v varchar2(20));
Table created.
SQL> insert into test1722 values ('1');
1 row created.
vsevolod afanassiev
|
03-22-2013 10:51 AM
Kay Kanekowski | 10 | 45 |
|  | Hi, I have a code with this lines:
create or replace procedure update_potencia
IS CURSOR from_table
IS SELECT table_name
FROM user_tables
WHERE...
carlinodba@gmail.com
|
03-20-2013 09:30 AM
joel garry | 4 | 15 |
|  | We started getting intermittent ORA-01722 "invalid number" in Oracle 9.2.0.8 on AIX.
According to the application logs the error comes from PL/SQL...
vsevolod afanassiev
|
03-14-2013 02:57 PM
vsevolod afanassiev | 4 | 24 |
|  | On Wednesday, September 19, 2001 3:17:31 PM UTC-5, Richelle Hutchinson wrote:
You can to a to_char(Substr(PRJ.DESCRLONG,1,254)
SELECT DISTINCT...
larry.oltmanns@gmail.com
|
03-13-2013 05:10 PM
John Hurley | 3 | 14 |
|  | On Tuesday, March 12, 2013 6:24:24 PM UTC-6, csto... (AT) hawk (DOT) iit.edu wrote:
Anyone who would actually expect people to pay to cheat on...
ddf
|
03-13-2013 09:42 AM
joel garry | 1 | 15 |
|  | Hi, I'm new to Oracle and working a solution that having Oracle talks to anexternal application. The external application sends some sql queries to...
Yaq
|
03-07-2013 11:29 AM
Mark D Powell | 3 | 38 |
|  | Hi,
It's been years since I've posted but I'm really stumped on this one.
I have an Oracle BLOB column in a table with about 4.3 million rows. ...
Cliff
|
03-06-2013 05:20 AM
Cliff | 2 | 14 |
|  | Join our online community to learn about the Certification exams of
cisco, microsoft, adobe, juniper, hp, Dell and all others. post
questions and get...
CCNA Expert
|
03-04-2013 10:33 AM
Mladen Gogala | 2 | 24 |
|  | Hey Everyone!
If you are going to Write any Certification exam & you are not
satisfied about your Preparation, Then come and test your
certification...
CCNA Expert
|
02-28-2013 02:04 AM
CCNA Expert | 0 | 27 |
|  | It's useless, the download times out after few downloaded files. Is that
an accident or Oracle is providing an additional motivation to register?
If...
Mladen Gogala
|
02-27-2013 02:51 PM
Mladen Gogala | 0 | 19 |
|  | set pages 0
SELECT rpad(' ',length)||keyword
FROM ( SELECT length
, keyword
, ROW_NUMBER() OVER (PARTITION BY length ORDER BY
keyword) -1 AS...
joel garry
|
02-22-2013 03:31 PM
John Hurley | 5 | 30 |
|  | Hi,
This is Christy Melnick, Online Certification Exam Consultant like
Cisco, Apple, Microsoft, IBM, Oracle & Others.
You can Join...
CCNA Expert
|
02-21-2013 10:13 AM
Mladen Gogala | 7 | 33 |
|  | Quite recently, I learned that Oracle ASM is now supporting block
devices. The whole process is described...
Mladen Gogala
|
02-18-2013 01:05 PM
Mladen Gogala | 0 | 21 |
|  | Hi,
i am thinking to launch all Certs Demo Exam, if any one interested
please add me on facebook to get your copy.
FB
http://on.fb.me/15oHJ1Y
These...
CCNA Expert
|
02-18-2013 04:29 AM
CCNA Expert | 0 | 23 |
|  | oracle@oracle-test-04$ uname
Linux
oracle@oracle-test-04$ uname -r
2.6.18-6-amd64
oracle@oracle-test-04$ echo...
Ronny
|
02-15-2013 10:42 PM
Mladen Gogala | 26 | 233 |
|  | I just wanted to share this with the group
http://allthingsoracle.com/compression-oracle-basic-table-compression/
This is an excellent article,...
Mladen Gogala
|
02-14-2013 11:24 AM
Jonathan Lewis | 1 | 27 |
|  | Hello,
Running this (on 10g R2):
PLS-00386: type mismatch found at 'SELDUAL' between FETCH cursor and
INTO
on the "loop fetch selDual..." line......
Spendius
|
02-12-2013 03:58 PM
ddf | 1 | 40 |