DBA Blogs

Readers don't block Readers

Tom Kyte - Thu, 2016-08-25 23:06
HI Connor Readers don't block Readers, is this true? As I understand waiting for a resource is also a kind of blocking. I am waiting because the access is blocked. Then please help understanding the below " ---- Another example of a prob...
Categories: DBA Blogs

Oracle forms to create a database user

Tom Kyte - Thu, 2016-08-25 23:06
Hello, Is there a way to create a form with username and password and create the user in the database? I have tried using a host command to log into sqlplus and execute the create user .... but it doesn't want to execute from the form host comm...
Categories: DBA Blogs

WHILE Loop Running forever

Tom Kyte - Thu, 2016-08-25 23:06
Hi , My aim is to print week days from a given date, for ex : IF I provide a date like '12-DEC-2012' ( Which is Thursday ) then my program should print as below FRIDAY SATURDAY But below code is running in a loop for ever, I am unable ...
Categories: DBA Blogs

Lock for "grant"

Tom Kyte - Thu, 2016-08-25 23:06
Hi Tom, When we *grant* a privilege on a table acquires a lock on the table. Just curious to know the following... -- Why does Oracle acquires a lock on the table (apart from grant being a DDL) when we issue a grant. Does it change the definiti...
Categories: DBA Blogs

Synchronous refresh cannot be used for the non-partitioned tables?

Tom Kyte - Thu, 2016-08-25 23:06
Hi, as I want to use the new technology in 12c called "Synchronous refresh" of the MView or group of MViews, I read the documentation ( https://docs.oracle.com/database/121/DWHSG/sync.htm#DWHSG029 ), but for me it's not 100% clear what are the res...
Categories: DBA Blogs

The last query gives the error "Invalid Identifier error".Please explain me whether I have refer the correct table?

Tom Kyte - Thu, 2016-08-25 23:06
---------------------types------------------- create type course_ty1 as object( cid number, titlte varchar(15), credits_req integer ) / create type unit_t as object( ui number(5), credit number(5) ) / create type offering_t as obj...
Categories: DBA Blogs

Partner Webcast – Oracle Big Data Preparation Cloud Service: Transform to Self Service Data Preparation for Business Users

When you work with data, the perception is that you spend most of your time on analytics. But in reality, you will devote much more time and effort on importing, profiling, cleansing, repairing,...

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

Future of Oracle PL\SQL

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I am working as PL\SQL developer, I wants to know the future job opportunities for PL\SQL,else whether I needs to update my skills in some other technology to survive in IT industry? Kindly do me suggestion. Thanks, Ganesh
Categories: DBA Blogs

Insert statement finished as per user_segment table but session is not releasing control

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I need to dump data into a temporary table where I do not need to have any data foreigh key, primary key. I kept the table in NOLOGGING mode with parallel 4. I am inserting with /*+ APPEND */ direct path insert. The data is getting inserte...
Categories: DBA Blogs

Oracle SQL Developer

Tom Kyte - Thu, 2016-08-25 04:46
I have a query that returns 50,000 records, how can I quickly get to the last record? if I use the scroll arrow of slide, it takes a long time before it gets to the bottom of the 'Query Results" is there a quick way to go to the last record? I hop...
Categories: DBA Blogs

Identifying only new characters entered in a varchar2 field

Tom Kyte - Thu, 2016-08-25 04:46
I need to write a query that will extract only new characters appended in a text field. Almost like auditing but done by query. Example Select field1 from table1; the dog is running in the park user appends more data into field1 via applicati...
Categories: DBA Blogs

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.0.0

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, We took a backup of prod database running on 11.2.0.4.0 and refreshed it on test database running on 10.2.0.4.0. We are unable to start to start our 10g database and receiving an error. We don't have a backup of our controlfiles as they ar...
Categories: DBA Blogs

File IO Stats - AWR

Tom Kyte - Thu, 2016-08-25 04:46
Hi team We have database showing "Av Rd(ms)" in File IO Stats section of the AWR as high as 500 msec. asvc_t ( SERVICE time) value of iostats data for the mount point is well within the acceptable 20 msec. 1) could you please share the sq...
Categories: DBA Blogs

SGA Size

Tom Kyte - Thu, 2016-08-25 04:46
Hi Team, What are the factors (list) that suggest we should increase the size of the SGA allocated for a database.
Categories: DBA Blogs

csv to oracle with multiple delimiter

Tom Kyte - Thu, 2016-08-25 04:46
I have a CSV file with no break, there is a |~| symbol as a column separator and |~~| has a row separator and ; is the single colum value seperator . I want to insert it into oracle table using utl_file please help . sample data is fname|~|mname...
Categories: DBA Blogs

when I am querying V$Datafile, I am seeing an entry with unrecoverable_change#

Tom Kyte - Wed, 2016-08-24 10:26
Hi team, when I am querying V$Datafile, I am seeing an entry with unrecoverable_change# as below we dont have any Primary standby configuration and this is Standalone DB. 1. how this Column updated (UNRECOVERABLE_CHANGE#) ? FILE# CREATION...
Categories: DBA Blogs

Memory_target and Memory_max_target

Tom Kyte - Wed, 2016-08-24 10:26
Hello Tom, I have very silly question for an experience person in oracle. but i am totally confused. please help As per my knowledge, memory_target is the parameter which oracle use to tune sga and pga components. and Memory_max_target is the p...
Categories: DBA Blogs

Clob EXTRACTVALUE over 4000 char limit

Tom Kyte - Wed, 2016-08-24 10:26
I am trying to extract a piece of text from a clob attribute that has descriptions in it. The problem I am encountering is when the description is over a certain number of characters, I believe 255 char, it fails and throws the error: <i>ORA-...
Categories: DBA Blogs

Transaction Isolation level - Serialization

Tom Kyte - Wed, 2016-08-24 10:26
Hi, I know its not recommended to use transaction isolation level as Serialization but for now we have to stick with it. Please pardon my knowledge as I'm new to this. I currently use Sybase ASA (SQLAnywhere) where we have the isolation level ...
Categories: DBA Blogs

Is it possible to use occi client of oracle11 to fetch/write extended data types that were added in oracle 12c?

Tom Kyte - Wed, 2016-08-24 10:26
Hi, I use oracle11 client library (libocci.so.11.1) to work with extended data types, like RAW(32000), VARCHAR(32000), etc. This is a new feature of Oracle 12c. When I try to fetch RAW data, I get exception: ORA-01461: can bind a LONG value on...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs