New answers tagged

1

If it was me, I would partition by hour, then you can just drop 24 partitions every day. That is only 744 partitions per month. Then if you query within a relatively short window, you will look at much less data. You may also want to look at your index strategy. My guess is that the cost of maintaining the indexes is too high. IMHO, smaller partitions should ...


0

AUDIT_TRAIL If you want the SQL text to be captured, you need to use the extended option for audit_trail (db, extended or xml, extended). alter system set AUDIT_TRAIL=db, extended scope=spfile; or alter system set AUDIT_TRAIL=xml, extended scope=spfile; Changing this setting requires a database restart to take effect. For FGA you can specify a ...


-1

The problem is the size of message box. Is enough with resizing the message box. Go to lower rigth corner for message box and resizing. The screen does not go away because is waiting your response in the message box.


0

Community Wiki answer containing the solution originally added to the question by the author. Finally I found the solution: I didn't change permission to be owned by the oracle user and oinstall group for the database dir in which the Oracle software is. I think there are some scripts or programs related to listener and the oracle user could not run it.


0

You can change the default retention policy of oracle log and trace files. Source: https://streetkiter.wordpress.com/2011/04/06/do-you-really-need-one-year-old-logs-and-traces-for-your-oracle-database/ Relevant extract: There are two parameters: SHORTP_POLICY (default 720 hours) and LONGP_POLICY (default 8720 hours). so SHORTP_POLICY is 30 days while ...


3

You can calculate a RANK/ROW_NUMBER based on this logic: ROW_NUMBER() OVER (PARTITION BY IMMS_ID ORDER BY CASE WHEN status='DI' THEN 1 WHEN status='OI' THEN 2 WHEN status='FI' THEN 3 WHEN status='OV' THEN 4 WHEN status='FV' THEN 5 END)


1

First of all do not use database links for larger transactions. This can cause too many problems with blocking sessions. Another hint is to keep transactions in a good size (not to small, not to big). If your table is not partitioned then write a piece of code to remove just 1000 rows, commit and delete the next 1000 rows. You said something about alter ...


1

Your connection string is wrong. With easy connect you need to provide a hostname and servicename/SID. In your case you would provide sqlplus user/"SomePass"@HOSTNAME:$PORT/servicename If you want to configure your connection in the tnsnames.ora, you can connect to it using sqlplus user/"SomePass"@TNSALIAS I actually don't understand the part of your ...


2

I found the issue. It is documented an oracle note (Doc ID 1086519.1). I used the first workaround listed which is to set CURSOR_SHARING to exact. ALTER SESSION SET CURSOR_SHARING=EXACT;


0

SQL is a query language that allows you to issue a single query or execute a single insert/update/delete. PL-SQL is Oracle's "Procedural Language" SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple selects/inserts/updates/deletes. You should learn SQL first from https://www.youtube.com/watch?v=7Vtl2WggqOg, then move ...



Top 50 recent answers are included