OracleConnections

Oracle Community Network

Forum Discussions (118)

Sort by:

Discussions	Replies	Latest Activity
Oracle performance on Connect/Disconnect for each transaction Currently trying to optimize some code and noticed that there is a connect being done before each transaction and disconnect is called at t… Started by Matthew Perry	0	Aug 19, 2013
Urgent:db link from oracle 10g to sql server 2000 Hi I have a db link 10g from oracle to sql server 2000. This was created a couple of years ago. This is working. I have now created another… Started by Alex John	2	Aug 5, 2013 Reply by Selina Moss
How to view connected session's SQL history Using the below query, I can see whos connected. select username,last_call_et,status,machine from v$session How can I see the SQL history f… Started by Barn Mitchel	1	Aug 1, 2013 Reply by Harry Rivero
Why Listener SID specified for Connection during RMAN duplicate Hi all, During duplication how does RMAN connect auilliary database after we specify the SID and even though the listener service shows it… Started by Leslee Voigt	2	Jul 26, 2013 Reply by Oscar Borgmeyer
How can I get the QPS or TPS of Oracle11g Hi, All My boss told me he wanted to know the QPS(Query Per Second) and TPS(Transaction Per Second) of current Oracle Database. The version… Started by Jared Perla	3	Jul 25, 2013 Reply by Verdell Biggers
Auditing tha auditor Hi all, 11.2.0.3 I want to audit all the actions being done by the user "sys" and "system" and all other users with DBA privilege. Especial… Started by Matthew Perry	3	Jul 25, 2013 Reply by Richard Hames
undo tablespace optimum size hi all, We have oracle 11gr2 database on linux 5.5. for this database undo tablespace is 7GB. Frequently we are receiving alerts for this t… Started by Araceli Gordy	2	Jul 24, 2013 Reply by Asa Labrecque
need refresher on moving to new server I installed oracle 10g on a new server without creating a database. I have taken a cold copy of our database from the old server and copied… Started by Frankie Clark	2	Jul 24, 2013 Reply by Tom Daniel
odbc version Hello, I have an Oracle 11.2.0.3 client running on RedHat Linux. Could you let me know how I can find out the version of ODBC drivers that… Started by Jonathon Roth	2	Jul 23, 2013 Reply by Catherine Jones
each apex items differentiate based on the value i have many items in form region,how to differentiate between value entered and not entered items with any color background. i try to apply… Started by Nathaniel Mau	6	Jul 1, 2013 Reply by Nathaniel Mau