DBA Blogs

NO_DATA_FOUND in Functions

Tom Kyte - Thu, 2017-01-12 15:26
Tom, We've just migrated from Oracle 9.0.1 to 9.2 and, coincidence or not, I'm facing a problem I had never faced before. The NO_DATA_FOUND exception is not being raised from my PL/SQL functions anymore!!! If I put a exception block to handle t...
Categories: DBA Blogs

NEXT vs UNIFORM SIZE

Tom Kyte - Thu, 2017-01-12 15:26
Hi All, Please clarify below doubt, If I use NEXT 10M and UNIFIOM SIZE 1M, which size will my next extent will have 1M or 10M? if we use this command: create TABLESPACE ts_cvliste11_20180815 datafile '/ora1/app/oracle/oradata/L11/2018/ts_c...
Categories: DBA Blogs

MIT Prof Claims RDBMS Model is All Wrong

Tom Kyte - Thu, 2017-01-12 15:26
Hi Team, My manager recently sent out this interesting talk by the founder of Postgres and VoltDB, Michael Stonebraker. https://blog.jooq.org/2013/08/24/mit-prof-michael-stonebraker-the-traditional-rdbms-wisdom-is-all-wrong/ I am curious of ...
Categories: DBA Blogs

Historical CPU and memory usage by service

Tom Kyte - Thu, 2017-01-12 15:26
Hello Tom, Is there a database view like DBA_HIST_SYSSTAT grouping historical session statistics by user or service? I was asked by my boss to create a report showing the CPU and memory usage by department but I could not find a view with that kin...
Categories: DBA Blogs

DYNAMIC INSERT SCRIPT WITH TIMESTAMP ISSUE

Tom Kyte - Thu, 2017-01-12 15:26
Hi, I am new to oracle, i have used your create dynamic insert script for generating the insert script. But that query is taking care of only three datatypes like NUMBER, DATE and VARCHAR2(). It is not taking care about the TIMESTAMP data type si...
Categories: DBA Blogs

Use of Wrap utility for 12K LOC packages

Tom Kyte - Thu, 2017-01-12 15:26
I've create a SP to encrypt the source code of existing packages, my problem is that legacy packages contain more than 12K LoC (lines of code), with small packages I have no issue, but with the heavy ones I got : <i>06502. 00000 - "PL/SQL: nu...
Categories: DBA Blogs

Oracle 11g Exadata SQL performance Tuning books?

Tom Kyte - Thu, 2017-01-12 15:26
Hi Tom, Can you please suggest some books for Oracle 11g Exadata SQL performance Tuning books? Regards, Mayank Jain
Categories: DBA Blogs

Where clause with multiple arguments which can be null or populated

Tom Kyte - Thu, 2017-01-12 15:26
I have a search feature in my application where a user can type filter on 3 different columns(can be more), each of these filters can be used or null. What is the best way to select a ref cursor for the data? I can think of 2 different ways. 1st wa...
Categories: DBA Blogs

Partner Webcast – Oracle Identity Cloud Service: Introducing Secure, On-Demand Identity Management

As corporate computing services continue to evolve and many aspects of the IT infrastructure are on the journey to the cloud, authorizing people to use enterprise information systems becomes more and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Links for 2017-01-11 [del.icio.us]

Categories: DBA Blogs

elegant way to map columns names to row values without system tables?

Tom Kyte - Wed, 2017-01-11 20:46
Hi Tom, We are adding a new component to the client's system. It will need to ingest some data and then display it to users in the GUI based on their customised preferences. We want to load data into columns with sensible names and tie them to t...
Categories: DBA Blogs

Concatenate multiple results into one row

Tom Kyte - Wed, 2017-01-11 20:46
When I query a database that includes a particular field (Condition), it returns multiple rows of Conditions associated with the same result from another column (NCT_ID). See sample output below. NCT_ID CONDITION NCT00531284 Mult...
Categories: DBA Blogs

Limit client connectivity sessions using trigger

Tom Kyte - Wed, 2017-01-11 20:46
Hi, I need to limit/allow client connectivity sessions (ie: toad) connecting to database. My synario: user should not have more than 2 toad connections to database. I need to restrict the client connectivity. Please let me know is this possib...
Categories: DBA Blogs

RefCursors Vs Pipelined Functions (11g)

Tom Kyte - Wed, 2017-01-11 20:46
Hi Team, Could you please go through below scenario - I have a stored procedure lets say SP_BULK_PDF_CARD_DATA( pindate IN VARCHAR2, vcountry IN VARCHAR2, vregion IN VARCHAR2, vpdfemailflag ...
Categories: DBA Blogs

Update-Statement performance differences between childs (v$sql)

Tom Kyte - Wed, 2017-01-11 20:46
Hello, yesterday we recognized that one of our Applications runs very slow. After we did a little bit of researching, we found out that one of our Update-Statements takes significant longer than the day before. After looking into v$sql we saw that...
Categories: DBA Blogs

Opening Cursor

Tom Kyte - Wed, 2017-01-11 02:26
Hi Sir, I have a query of size 70,000 character when I open cursor, it is not opening. what should i do for this type of query. How to find length of string which has more than 4000.
Categories: DBA Blogs

undo buffer

Tom Kyte - Wed, 2017-01-11 02:26
Hi Team, Can you explain below questions in details?. 1.Does undo buffer exists or changes will directly write to undo datafiles? 2.Does redo contains both undo & redo related changes? 3.If db crashes with uncommitted data in undo buffer ...
Categories: DBA Blogs

Library cache lock for wrong passwords

Tom Kyte - Wed, 2017-01-11 02:26
Hi, I want to know what exactly happens in the library cache which in turn puts the users into lock/delay logins when a user tries to login multiple time with wrong password. If you could explain me regarding this it would be a great help. T...
Categories: DBA Blogs

Questions about Oracle TimesTen cache Oracle DB data under Java application

Tom Kyte - Wed, 2017-01-11 02:26
Hi Team: One of our customer wanna construct a db system which includs both OLTP and OLAP architecture(like SAP HANA) to gurantee the speed of historical data searching and everyday transactional processing. As Jim Gray said "Tape is Dead, Disk is ...
Categories: DBA Blogs

Operator Error

Tom Kyte - Wed, 2017-01-11 02:26
Trying to use an operator to create an "overloaded" PL/SQL function. The goal of the function is to accept 3 different formats (Timestamp with timezone, Timestamp, and Date) and return just a timestamp withzone. I am getting different errors ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs