DBA Blogs

Dataguard in SE edition

Tom Kyte - Sun, 2016-07-03 13:46
I know that oracle 11g SE edition does not support any data guard. so Is it possible to create a physical standby database with RMAN on SE edition? help
Categories: DBA Blogs

why ref cursor is inefficient that regular cursor

Tom Kyte - Sun, 2016-07-03 13:46
I have seen many posts and observed that Ref Cursors are inefficient when compared to Regular cursors. it would be great if you explain me what happens internally and why ref cursors are inefficient than regular cursors.
Categories: DBA Blogs

OOW

Tom Kyte - Sun, 2016-07-03 13:46
Hello Sir, Can we have your presentation from OOW 2010? Thanks & Regards
Categories: DBA Blogs

Getting values dynamically

Tom Kyte - Sat, 2016-07-02 19:26
Hi, I will pass table_name tabl1 and its primary key value pk=(some value). My requirement is suppose there is table1, its has primary key pk1 and also it has unique keys ak1,ak2 , And its one of unique keys is foreign key to table2, now i require...
Categories: DBA Blogs

Links for 2016-07-01 [del.icio.us]

Categories: DBA Blogs

Count months 15 days record.

Tom Kyte - Sat, 2016-07-02 01:06
Hi, I want to count records from my database table on every month's 15 days count in respect any group by Id. Like : GroupBy_Id Count statDate EndDate 5 15 01-Mar-2016 15-Mar-2016 5 2 16-M...
Categories: DBA Blogs

How to schedule a script in sql developer

Tom Kyte - Sat, 2016-07-02 01:06
Hi; I have tried many ways to schdule an a script using sql developer;But for these scripts those are failed.But those can nicely run using built in oracle sql-plus.i can use the script by using @ sign and with the file name (eg : @filename) Here...
Categories: DBA Blogs

SQL Server 2016 TCO

Tom Kyte - Fri, 2016-07-01 07:06
Team, i was going through this link. https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Comparing the cost of SQL Server 2016 with Oracle 12c, Oracle cost 12x more. We know Ora...
Categories: DBA Blogs

Block user account to PRIMARY production server and move them to the REPORTING STANDBY Db.

Tom Kyte - Fri, 2016-07-01 07:06
We are planning to all our Business users to use our read only Active data guard standby database and restrict them using the Primary production database using logon trigger. But as part of security, users have to change their passwords every 60 ...
Categories: DBA Blogs

How to validate the XML data exists in the XML table

Tom Kyte - Fri, 2016-07-01 07:06
Hi Tom, Can you please help me on how to validate the XML data available in the XML table. I have one XML table as: CREATE TABLE TEST_XML OF XMLTYPE XMLTYPE STORE AS SECUREFILE BINARY XML; And the data as: INSERT INTO TEST_XM...
Categories: DBA Blogs

Would there be a better way of improving the performance?

Tom Kyte - Fri, 2016-07-01 07:06
I have a code as shown. Objective of this piece of code is to give a report on counts for student enrollments, student absences and percentage present in the district starting from the first day of school up until the last day (i.e. a total of 18...
Categories: DBA Blogs

Number filtering from Oracle with Decimal

Tom Kyte - Fri, 2016-07-01 07:06
Hi Team, We had a situation where the customer is pulling a report from a table. This table has a number format as number (5,2) . They have a value 9 and also its updating another value as 9.00 while selecting it from the table if we use to_char(n,9...
Categories: DBA Blogs

ORA-27125: unable to create shared memory segment

Tom Kyte - Fri, 2016-07-01 07:06
Have an error when trying to start DB - ORA-27125: unable to create shared memory segment SVR4 Error: 22: Invalid argument
Categories: DBA Blogs

PLSQL profiling and auditing

Tom Kyte - Fri, 2016-07-01 07:06
1)In 100 lines of plsql program I have raised performance issue how to find which line occur the performance issues. 2)Is there any way in which i can find out when a stored procedure was last executed in oracle. NOT only a procedure am looki...
Categories: DBA Blogs

tuning array join

Tom Kyte - Fri, 2016-07-01 07:06
hi, i write relating the 71th statment of the following link. https://livesql.oracle.com/apex/livesql/s/dif16pb1eyri6hmzxxr1wg1zb i've to speed up this cursor: <code> cursor v3(c1 redd_tbTotali, c2 redd_tbPatrim) is select a1.prod...
Categories: DBA Blogs

SQL query running longer

Tom Kyte - Fri, 2016-07-01 07:06
I have three tables T1, T2 & T3. T1 has about 29 million rows T2 has 25 million rows T3 has about 9 million rows The below query takes more than an hour to run. I have tried indexes on the join columns, temp tables, hints but nothing helps. is...
Categories: DBA Blogs

Partition By and Group By

Tom Kyte - Fri, 2016-07-01 07:06
Hi Tom, I know the purpose of Partition by is to divide the data into groups and Group By is to retrieve result of some aggregate functions. What is the main difference between partition by and group by?
Categories: DBA Blogs

Date Function Filter

Tom Kyte - Thu, 2016-06-30 12:46
I have table having date with two different formats in the same column. When I'm querying like <b>extract(year from to_timestamp(colmnname, 'DD/MM/YYYY hh24:mi'))</b> its giving me as<b> date format picture ends before converting entire input string<...
Categories: DBA Blogs

Query/Disk aggregated figures not matching execution plan in SQL trace for a single SQL statement.

Tom Kyte - Thu, 2016-06-30 12:46
Hi Tom, My question is, not sure I'm hitting some sort of bug though I can't find anything on mos, why the query-current-disk aggregated figures do not match the execution plan cr value multiplied by the number of iterations or fetch calls: SEL...
Categories: DBA Blogs

Regarding the Oracle SQL Tuning Report

Tom Kyte - Thu, 2016-06-30 12:46
Team, I recently had one issue with one of my production database where we had an application upgrade completed. Once the upgrade completed , one of the select query stared performing very slow. I have tried debugging using the sqltrpt.sql , but thi...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs