DBA Blogs

History of User privileges held

Tom Kyte - Sat, 2016-11-19 10:06
In Oracle 12c or 11g, is it possible to fetch the history of user privileges held by a schema? Say from last two months, I might have granted different roles and privileges. I can get the current privileges the schema holds, but is it possible to kno...
Categories: DBA Blogs

Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package.

Tom Kyte - Sat, 2016-11-19 10:06
Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package. I have a package create or replace pkg_test as Pragma serially_reusable l_var number := 0 //some code here end; this package is called by ...
Categories: DBA Blogs

Frequent Truncate

Tom Kyte - Sat, 2016-11-19 10:06
We are frequently truncating partitions in a stage schema through java after loading data into a target table. Once partitions are truncated frequently are there any other steps to be taken to release the space?
Categories: DBA Blogs

Inserts inside before update trigger

Tom Kyte - Sat, 2016-11-19 10:06
I've come across this issue during trigger code testing today. My requirement is, 1. If INSERTING then statements in this block should execute on T1. 2. If UPDATING then statements in this block should execute on T1. It has IF ELSE block and it ...
Categories: DBA Blogs

Query for selecting top 10 percent of records

Tom Kyte - Sat, 2016-11-19 10:06
Hi Tom, I have the requirement of selecting top 10 percent for each group based on score for the below data "GROUPID" "SCORE" "group1" 13 "group1" 12 "group1" 10 "group1" 12 "group2" 12 "group2" 13 "group2" 16 "group2" 20 "group2" 22 ...
Categories: DBA Blogs

Parse CPU to Parse Elapsd has horrible ratio.. but others not too bad?

Tom Kyte - Sat, 2016-11-19 10:06
Tom - this is from running a statspack report. It captures activity over a 3 day period. Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100...
Categories: DBA Blogs

Columnar Storage

Tom Kyte - Sat, 2016-11-19 10:06
Hi Tom, I recently read an article http://visualstudiomagazine.com/Blogs/Data-Driver/2010/11/SQL-Server-Scan-1-Trillion-Rows-Per-Min.aspx which claims to be revolutionary and unmatched. How does Oracle measure up to it? Very recently new jargons h...
Categories: DBA Blogs

oracle data pump for a list of tables from different schemas

Tom Kyte - Fri, 2016-11-18 15:46
Hi Tom, Please note that I have a requirement where I need to export and import data in oracle 11g. At the source there are 4 schemas and each schema contains different numbers of tables. I need to load the target schema with the exported data fro...
Categories: DBA Blogs

Error when exporting table space which is contained

Tom Kyte - Fri, 2016-11-18 15:46
We are trying to move the database from Solaris to Linux and are facing an issue with the self-contained tablespace. Even after setting the execute sys.dbms_tts.transport_set_check('PSRBS',true); on a tablespace , get the below violation. How do we ...
Categories: DBA Blogs

Saving updates to an filtered table

Tom Kyte - Fri, 2016-11-18 15:46
Hi Thanks for this service I would to filter an table, preferably using interactive reports as it is easy to use, and then use a button to: write the filtered table into a new table or to update the existing table to remove the non fil...
Categories: DBA Blogs

Parser for plsql queries

Tom Kyte - Fri, 2016-11-18 15:46
Dear Tom, I have a requirement for displaying all the tables in the sql statement also columns that are participating in joins in the same sql statement. I am storing the queries that needs to be parsed in a table "PARSEQRY". However, post parsin...
Categories: DBA Blogs

Diff BW Collection type and Object Type

Tom Kyte - Fri, 2016-11-18 15:46
Hi, I am Oracle Beginner,Would you please explain the difference between Object type and Collection Type? Thank you.
Categories: DBA Blogs

SQL queries consuming host memory

Tom Kyte - Fri, 2016-11-18 15:46
Hi Tom, I would like to know which queries currently running is consuming host memory From OS level i came to know that the below process is consuming memory - $ ps aux | head -1; ps aux | sort -rn +3 | head USER PID %CPU %MEM VSZ...
Categories: DBA Blogs

Role behaviour change in 12c

Tom Kyte - Fri, 2016-11-18 15:46
I have created one package(pk_data_updates) in schema A and assigned Execute permission to existing Role Role1(ROLE Role1 is password protected). this Role (R1) is assigned to user venkat. CREATE ROLE Role1 IDENTIFIED BY roc_super; GRANT EXECU...
Categories: DBA Blogs

when redolog turns into archivelog?

Tom Kyte - Fri, 2016-11-18 15:46
Hi, My confiurations says that my redologs are of <b>200MB</b> max, and they are switched every 30minutes. <code>SQL> show parameter ARCHIVE_LAG_TARGET; archive_lag_target 1800 </code> Of course, with more activity, redo logs, are archived ...
Categories: DBA Blogs

Parse HTML in PL/SQL

Tom Kyte - Fri, 2016-11-18 15:46
Hi, Tom! I need some advice in what is the best way to solve the following task in PL/SQL. I have the following link https://wiki.xmldation.com/Support/EPC/List_of_SEPA_countries. I need to get IBAN-s (the third column) from this site and c...
Categories: DBA Blogs

Dynamic Query is running Slow in 12 C

Tom Kyte - Fri, 2016-11-18 15:46
Hi Tom, I had 1 sql file which was running perfectly fine in 10G but after migration to 12 c performance is very poor. The query logic is : A table has around 550 columns and data is getting inserted into this table from XL Sheet. Once loaded then...
Categories: DBA Blogs

Oracle Container Cloud Service is available now!

I am happy to let you know that finally Oracle Container Cloud Service is publicly available. Oracle Container Cloud Service, a new service where customers can bring their own Docker containers and...

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

Links for 2016-11-17 [del.icio.us]

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs