Tag Info

New answers tagged

0

I have gotten burned so many times that I set them all with: set pages 60 select * from dba_profiles where profile='DEFAULT'; alter profile default limit FAILED_LOGIN_ATTEMPTS UNLIMITED; alter profile default limit PASSWORD_LIFE_TIME UNLIMITED; alter profile default limit PASSWORD_GRACE_TIME UNLIMITED; alter profile default limit PASSWORD_LOCK_TIME ...


0

It's really easy to just use the Linux stress utility to selectively load some or all of the system features. It's available via YUM for download... Think of stress as a load-generator. Forcign the system to crash is a different effort. You can use this to see how things operate under load, but I doubt that any sane configurations from the stress utility ...


0

I use the following rb.sql script. -- The Following script shows the time it takes to insert 1 million rows in a database. -- I used it to determine that: -- -- 1) Optimized Databases perform in relation to the hardware they run on, -- and all the databases on 1 platform run within 10% of each other. -- 2) When Rollback, Temp or Redo logs share the same ...


1

I insert a million rows with a script that I have been using since 2000. I have a calling script that creates a nice report for 10 runs and the average. 6 of the top 10 fastest databases are running faster due to performance tuning. INSTANCE SEC_TO_INSERT_250_MEG AVG_SEC_TO_INSERT_25_MEG SYSDATE -------- --------------------- ------------------------ ...


1

Here are the commands that I run in sqlplus to create the directory and sample shell scripts that do the imports and exports: Commands to run in sqlplus prior to running inport: grant create any directory to EPADMRT; create or replace directory MY_DIR as '/content_services/alan'; Sample import shell script: #!/usr/bin/ksh export ORACLE_SID=PADMRT ...


0

I solved the problem in 11g by creating a password file with the following. 1) login as the ORACLE owner 2) cd $ORACLE_HOME/dbs 3) orapwd file=orapw$ORACLE_SID password=yourpasswordhere 4) login to Oracle as SYSDBA locally (sqlplus "/ as sysdba") 5) Enable the remote login password parameter in the spfile (alter system set ...


0

EPADMRT > @resizea CURRENT_MEG SAVINGS ID TABLESPACE_NAME RESIZE_COMMAND ----------- ---------- ----- --------------- --------------------------------------------------------------------------------------- 30000 -1 3 UNDO_TS alter database datafile '/var/oradata03/PADMRT/PADMRT_UNDO_01.dbf' resize 30001m; 30000 ...


0

Not an answer (at least not yet) but I need formatting. I don't know anything about Talend. Possibly it's displaying the exception/stacktrace in an unusual way. Or another possibility: I did some experimenting and I can get a stacktrace more like yours, in particular without the cause chain, but still not identical, using an older ojdbc14.jar I have lying ...



Top 50 recent answers are included