DBA Blogs

Code enchancement

Tom Kyte - Mon, 2016-07-18 19:26
Hello Chris Saxon, I have a below table structure. CREATE TABLE "PEOPLE" ( "PERSON_ID" NUMBER, "GIVEN_NAME" VARCHAR2(100), "CATEGORY" number(50) ) INSERT INTO people VALUES(1,Connor,1001); / INSERT INTO people VALU...
Categories: DBA Blogs

difference between soft parse and hard parse

Tom Kyte - Mon, 2016-07-18 19:26
Hi Tom Can you explain briefly the difference between soft and hard parse? cheers
Categories: DBA Blogs

Time conversion

Tom Kyte - Mon, 2016-07-18 19:26
Hi Team, Please let me know how we can convert <b>14-JUL-2016 17:11:05 PM</b> into 1<b>7:11:05 or 05:11:05 PM only</b> in Oracle. Regards, Atin
Categories: DBA Blogs

Why it is difficult to scale oracle

Tom Kyte - Mon, 2016-07-18 19:26
Why it is difficult to scale oracle database. Thanks!!
Categories: DBA Blogs

Importing windows scheduled tasks into a Powershell object before 5.0

Matt Penny - Mon, 2016-07-18 07:43

You don’t need this on Powershell 5.0 and upwards because there’s a built-in cmdlet, but for previous versions:


convertfrom-csv $(schtasks /Query /S server1 /TN "run somesstuff" /V /FO CSV)

HostName : server1
TaskName : \run somesstuff
Next Run Time : N/A
Status : Ready
Logon Mode : Interactive only
Last Run Time : 13/07/2016 10:05:43
Last Result : 0
Author : matt
Task To Run : C:\powershell\Modules\somesstuff-PCs\run-somesstuff.bat
Start In : N/A
Comment : Scheduled job which does some stuff
Scheduled Task State :
Idle Time :
Power Management :
Run As User :
Delete Task If Not Rescheduled :
Stop Task If Runs X Hours and X Mins :
Schedule :
Schedule Type :
Start Time :
Start Date :
End Date :
Days :
Months :
Repeat: Every :
Repeat: Until: Time :
Repeat: Until: Duration :
Repeat: Stop If Still Running :

HostName : More detail at http://ourwebsite
TaskName : Enabled
Next Run Time : Disabled
Status : Stop On Battery Mode, No Start On Batteries
Logon Mode : matt
Last Run Time : Enabled
Last Result : 72:00:00
Author : Scheduling data is not available in this format.
Task To Run : One Time Only
Start In : 10:20:21
Comment : 25/05/2016
Scheduled Task State : N/A
Idle Time : N/A
Power Management : N/A
Run As User : Disabled
Delete Task If Not Rescheduled : Disabled
Stop Task If Runs X Hours and X Mins : Disabled
Schedule : Disabled
Schedule Type :
Start Time :
Start Date :
End Date :
Days :
Months :
Repeat: Every :
Repeat: Until: Time :
Repeat: Until: Duration :
Repeat: Stop If Still Running :


This is outputting from schtasks in csv format, then importing that into a PowerShell object.


Categories: DBA Blogs

Document No. Repeat

Tom Kyte - Mon, 2016-07-18 01:26
Hello,Dear Tom: Document No. repeated in the database! SELECT T.*,T.ROWID FROM AR_BILL T WHERE T.BILL_NO = '201607-141055001-001-000091' BILL_ID BILL_TYPE BILL_NO CO_CODE ND REASON PROJECT_CODE APP_ID INPUTOR_ID ORG_CODE INPUT_DATE BILL...
Categories: DBA Blogs

Hash partitioning and number of partition

Tom Kyte - Mon, 2016-07-18 01:26
Hi Tom, I have a question regarding the choice of the number of partitions when using hash partitioning. I have the following table used to store documents <code>CREATE TABLE "DOCUMENT" ( "DOCUMENT_ID" NUMBER(38,0), "CREATED_BY" VARCHA...
Categories: DBA Blogs

Explanation of Hints

Tom Kyte - Mon, 2016-07-18 01:26
Hi Tom, 1)first up all great thanks to you for spending time for me explain about following hints Parallel append index no_index first_rows and all_rows with an example in which situation we may use what hint in select the data from table? ...
Categories: DBA Blogs

Member procedures & Member function in plsql i.e member sub programs in oracle(plsql)

Tom Kyte - Mon, 2016-07-18 01:26
Hi Tom, 1)why we are using,what is purpose of Member procedures & member functions in plsql subprograms explain an example? 2)Difference between stored subprograms and member subprograms?
Categories: DBA Blogs

How to set all elements of collections

Tom Kyte - Mon, 2016-07-18 01:26
I've three questions 1) Suppose I have a collection of numbers say 300 values & i want to initialise with number 72 what would be the best way to do so ,rather than writing 300 times 2) I've to generate reports in pdf so what would you sugg...
Categories: DBA Blogs

Will open cursor hold up more tablespace when it is not closed?

Tom Kyte - Mon, 2016-07-18 01:26
Hi Tom, I am using oracle 11g and the tablespaces keeps growing, I have recently identified a issue with open cursors which is not closed when the session was closed. Will open cursor eats up all the spaces which leads to consume more temp spa...
Categories: DBA Blogs

ORA-01578: ORACLE data block corrupted (file # , block # )

Tom Kyte - Mon, 2016-07-18 01:26
Hi Tom, I m getting following error in my production data base alert log since last 5 month. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_j000_26775.trc: ORA-01578: ORACLE data block corrupted (file # , block # ) ORA-01578: O...
Categories: DBA Blogs

ORA - 08103:Object No Longer Exists

Tom Kyte - Mon, 2016-07-18 01:26
Hi, I am getting an error Ora-08103: Object No longer exists when select queries are fired against a partitioned table having local Bit map indexes. But when the same process/job (which fires select query) is restarted the issue does not come up a...
Categories: DBA Blogs

Why the "Row Source Operation" ('reality exec') differs from the "Execution Plan" ('guess exec')

Tom Kyte - Sun, 2016-07-17 07:06
Hi, Team There's a procedure in our Oracle 11.2.0.1 DB which captures data from MS SQL Server through DB Link, since the context is quite long (cursors, pragma autonomous_transaction and loop included), let us take it brief like this: CREATE OR...
Categories: DBA Blogs

XML Update

Tom Kyte - Sun, 2016-07-17 07:06
Hi Tom, I need to update some attribute(XML) in oracle table whose datatype is XML. Is there any package provided by oracle which help me? Or if you can tell me anyway how can I update it.
Categories: DBA Blogs

clone(duplicate active Database)

Tom Kyte - Sun, 2016-07-17 07:06
I Want to clone a database from one computer to another computer, both computer connected with lan. The database which i have to clone is available on computer 2. on computer 1 i have created an instance using oradim utility On computer 2 <code>...
Categories: DBA Blogs

Add_months

Tom Kyte - Sun, 2016-07-17 07:06
Hi Guys, I am just a little bit confused regarding the following : select add_months(to_date('30/01/2016','DD/MM/YYYY'),1) from dual Result is : 29/02/2016, shouldn't it be 28/02/2016 ?? Thanks Mohannad
Categories: DBA Blogs

issue while adding new apps node in oracle EBS r12.2.5

Tom Kyte - Sun, 2016-07-17 07:06
Hi DBA Experts, I am facing following issue while adding new application node please help me to fix this issue. Executing command: perl /u02/applmgr/SR1225/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-create-node -contextfi...
Categories: DBA Blogs

export to CSV

Tom Kyte - Sun, 2016-07-17 07:06
Tom, I need to export data from a table into a .csv file. I need to have my column headres in between "" and data separated by ','. also depending on the column values a row may be printed upto 5 times with data differing in only one field. ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs